All Questions
Tagged with database-design c#
574 questions
0
votes
0
answers
28
views
PluginInterface and Entity Framework
I have the following projects:
MyApp.DAL (Contains the dbcontext)
MyApp.PluginInterface (Contains interfaces that the plugin projects can implement)
I make dll out of it by publishing. Then I add ...
0
votes
2
answers
91
views
How to structure my MSSQL DB to handle arrays
At work we have a C# program a machine operator use to send article data to a machine.
Now they want us to adjust the program so that we can save different articles on Azure.
The article data in the C#...
0
votes
1
answer
72
views
Using OnModelCreating ModelBuilder how can I restrict an int attribute range?
If I have a class with 2 attributes
class Person
{
public string Name {get; set;}
public int Score {get; set;}
}
When I use the ModelBuilder for example I can restrict the length of the name ...
- 63
0
votes
1
answer
39
views
Containing Object Design
I'm trying to design a class in an object oriented way and not seeing any great options.
I have a containing object that needs to contain a list of values.
So each row in the containing object could ...
- 181
1
vote
0
answers
70
views
Table Design for Calculating Median Over User-Defined Period from Pre-Processed Data
I’m working with a table that contains pre-processed data from several other tables. This data is segmented by a time period (like a day) to speed up queries that could take minutes if I had to ...
- 21
0
votes
1
answer
51
views
Multiple components data storage in one table
I am developing a project that helps administrators store applications infrastructure information in one place.
During planning phase I faced with problem how to store & process some components ...
- 3
1
vote
6
answers
360
views
What would be a good approach of storing inexact/imprecise dates?
In the application I'm working on, I need to store some metadata which includes dates that can be inexact. As an example, let's say that I want to store the release date of a product. Some examples of ...
- 3,875
0
votes
1
answer
70
views
EF Core Shared Domain Project
I have a base Domain Project that has base classes for multiple projects to use.
Inside this base proj I have the following classes
public abstract class CommonUserAccount : IdentityUser<Guid>, ...
0
votes
0
answers
112
views
Entity Framework Core : model schema one-to-many relationship
I am used to building a database and accessing data through tables, views, and stored procedures. In this case I have to build the database using Entity Framework Core migrations.
My database schema ...
- 1,265
1
vote
1
answer
325
views
Splitting a big database into small DbContexts
In our company we are going to relaunch a proprietary ERP System and for the backend we will use EFCore for dataaccess.
As usual the database design is not the best, but will do the work. But for ...
- 33
0
votes
2
answers
112
views
At what layer i should determine if something does not exist [closed]
Suppose I have a Comment entity defined as follows:
public class comment
{
public int Id { get; set; }
public int TopicId { get; set; }
public string Text { get; set; }
...
- 55
0
votes
0
answers
57
views
A Large Entity Table vs Related to the Large Entity Additional Entity?
I am working on a project where I cannot make 100% independent architectural decisions.
I was asked to convert a JSON field in an SQL Server database table into the relational data model from a JSON ...
- 483
-3
votes
2
answers
113
views
Tradeoff - Performance vs Space - Boolean vs String Comparison [closed]
I'm having a use case to display a modal popup only if there is a content to be shown. Content is configurable in the portal.
Check if content is not empty and then render the modal popup code
Cons - ...
- 636
0
votes
1
answer
152
views
EF Code First database schema: Represent User entity by two tables where either one should be used
I modelled the database this way and while it works just fine, I'm unable to integrate it into an existing system because the User is in that system is representated by two tables: Employee and ...
- 6,439
0
votes
1
answer
550
views
C# Unity - How to find the name of a field/property? Alternatively how to set up an Item Attributes system? (HealOnUse, Damage, Condition, etc)
Im trying to design a robust Item system that can be used in Inventories but can also be serialized and saved easily. I use JSON for serialization, but thats not what this Q is about.
So I have a ...
user20494201