All Questions
Tagged with database-design c#
41
questions
1
vote
1
answer
357
views
How can I restore an entity from the database while keeping my entities database-independent?
Background
I'm currently working on a project using domain-driven design and Dapper as my ORM. The entities are naturally slightly different than the tables in which they are stored (e.g. _id is ...
- 225
0
votes
0
answers
142
views
How to design entities to keep up with the depth of JSON objects?
To better context see Rich Authorization Requests for OAuth2
As u can read here there are some common data field types like actions, locations etc.
So I have created C# entity for EF as below:
public ...
- 111
0
votes
2
answers
644
views
How should design my entities when I sometimes need only a subset of fields?
I have a class that is mapped using Entity Framework. This class has dozens of fields, and in the database there are millions of rows for this class. The class looks like this
public class MyEntity
{...
- 151
0
votes
2
answers
263
views
Extend the ApplicationUser class or use a Person class?
I am making a web system using Asp.Net Core with individual user accounts (Identity), and I was thinking about how I should store the users' personal information in the database.
The system will have ...
- 131
-4
votes
1
answer
507
views
Efficient database for multiple key searching?
I'm trying to implement a solution that stores every product from a shop, and then allows me to search them either by ID (an integer index), description (string) or barcode (string).
The idea I came ...
- 3
-2
votes
2
answers
131
views
Dependency of program code on specific database values
I have two approaches to solving a problem but I don't know which one is better.
I will give a simplified example.
First approach
The database will look like this:
color |
--------
FFFFFF |
0000FF ...
- 15
9
votes
2
answers
956
views
How to design microservices with large number of joint entities outside of the domain border?
I'm working on breaking down a monolith application in smaller applications or microservices. Like always, sometimes it's easy and sometimes it's harder to identify domains and split those into ...
- 225
2
votes
1
answer
140
views
Application Security Trimming vs Database Security Trimming
We have a fairly complex Meetings Management solution which would have one meeting to contain different agendas which would contain some tasks and also documents, etc. There are also different roles ...
- 131
2
votes
2
answers
265
views
Different types of account transactions
I'm working on a system where users have different types of 'Accounts' of the financial type. I'm struggling to come up with a design that works.
Background
A user has 2 types of accounts: A 'tab' ...
3
votes
4
answers
488
views
How to Handle Item Prices Change for Reporting
I am building a Point of sales software with Sql Server 2008-R2. I am now confused about how to handle multiple items with prices change.
Let us say price of Pepsi is $2.0 on 10-09-2019 but today it'...
- 33
0
votes
2
answers
1k
views
Best way to match timezone with time offset?
I have a c# solution which uses mssql database to store data.
In my database there is a big table of entities (e.g. accounts) for each of which the TimezoneId field is defined. This field is filled ...
1
vote
2
answers
198
views
Branching SQL relationship to C# object model
I'm developing a C# WPF desktop application where I need to read/write to an SQL database regularly. Now I want to map the data from the database to objects in C#. I can't use Entity Framework so I'm ...
- 21
0
votes
0
answers
65
views
What should I do if I am unfamiliar with my organisation's codebase? [duplicate]
I've recently started my first job as a software developer at a small startup company.
I do not have a degree in a software engineering related field, although, I have very recently completed an A-...
- 109
6
votes
7
answers
4k
views
Should I use entity framework for CRUD and let the database handle the complexity that comes with high end queries?
I am new to ef and liking it since it reduces the overhead of writing common queries by replacing it with simple add, remove functions. Agreed.
Today I got into the argument with my colleague who has ...
- 169
1
vote
1
answer
177
views
Hybrid Database of serialized data and columns. What issues should I expect
I have a system that acts like a message hub. It normalizes data and stores it to be picked up by a different system. Currently I convert my object model into tables and columns for storage. I came ...
- 145