All Questions
114 questions
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#...
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
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
1
vote
1
answer
241
views
Why can I not get the names of my tables using System.Data.SqlClient?
I did not create and do not own this database. My job is usually just to put data in it, so I don't have to think too much about the DBA side. I am messing with a side project and can not figure out ...
- 116
0
votes
0
answers
19
views
Can database create relating tables at the same time and mandatorily on query?
Developing tool: C#
Database : SQL Server Express
enter image description here
For the first time, I designed customer entity like model A which had phonenumber field.
But I changed the database ...
1
vote
1
answer
605
views
Is there any way generate database-design diagram of databases using C#
Is there any way to generate database-design diagrams using C# code?
I want to automate database design generation to be able to generate multiple sequence diagrams at once of different database ...
- 158
0
votes
1
answer
51
views
Reference a child table from another table?
So I'm using TPT (Table per Type) in EntityFramework 6 to create a table hierarchy, assume something like this one:
public class Model
{
public int Id { get; set; }
public int CommonProperty {...
- 157
0
votes
2
answers
66
views
how to accommodate default values for parent table In database design using EF 6?
I have following tables (Its not actually accessories but I am using it as an analogy),
- Accessories {AccessoriesId, Name, other accessory related attributes...}
- ClientAccessories (...
0
votes
1
answer
143
views
.net ef core - How to set a relation to a compsite key and does my table design make sense at all?
Im not sure how I need to set the relations between a table with a Unique Key to a table with a composite key. I want to do this with .net Entity Framework Core but I guess it is a sqlserver db design ...
- 132
0
votes
0
answers
34
views
is Key-Value a acceptable in this case?
There is a backend module which simply sends out system requests to different service providers and the partner would be changed frequently. We plan to store the request and request payload into ...
- 82
0
votes
0
answers
29
views
Whats is a viable approach for a Template Data Model consists of two lists?
At the moment im working on a project where you can create a template for a report. At this point im struggling between two viable approaches for the entity model and I'm not sure which way is from ...
- 328
0
votes
1
answer
151
views
Deleting stale data from mapper table
I am working on a design with the following entities with C# and Microsoft sql server for my school project
User table - User table that stores user information
Product table - Product table that ...
- 307
-3
votes
1
answer
166
views
Save Arabic data of datagridview in database
I have datagridview that contain two columns (name, age). The data of that gridview in Arabic. (((Failed to convert parameter value from a String to a Int32.)))
Her my code
SqlConnection connection = ...
- 27
1
vote
1
answer
606
views
F1 season database individual races
I'm making a C#/SQL/LINQ web form site to handle a single season in Formula 1. The tricky part appears to be designing tables for single races, each describing around 20 drivers, teams they drive with ...
- 177