All Questions
129
questions
0
votes
2
answers
98
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; }
...
-1
votes
2
answers
881
views
How to handle primary key in child table which is also primary and foreign key in parent table?
How can I create a relationship in EF core where the child(FullName) table has DrugId which is the primary key. In the parent table(Basic Data), DrugId is foreign key. But there are other child tables ...
1
vote
0
answers
57
views
Update user inputs into C# Service-based Database (using textboxes, MonthCalendars and Comboboxes)
I am new to C# and this was my general idea for the C# form: user (who has the role of a Technician) would be able to view Service Requests stored in the table RequestHistory, and would be able to ...
-1
votes
1
answer
401
views
How to represent a Football match model?
Currently I'm working on an application that operates with the following entities:
Football Matches
Teams
And I am dealing with a dilemma: How to represent the FootballMatch domain entity, which of ...
0
votes
1
answer
584
views
Setting up relationship between Users table and other tables like Clients in a SQL database
I'm using .NET 5 and Entity Framework Core, but this is more of a database schema question. I know how to set up relationships, but I'm not sure what the best approach is.
I have a table called '...
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 ...
0
votes
0
answers
77
views
Database schema design by Entity Framework
I have a problem with design DB schema when I try to build schema by db model ef.
I need to get a model according to this scheme:
My DbContext:
public class AppContext : DbContext
{
public ...
0
votes
1
answer
447
views
How to search in dynamodb with a complex value using .net sdk
I have just started with DynamoDB. I have background in MongoDB and relational databases and I am structuring my JSON in more like a graph structure than a flat structure. For example,
[
{
"id"...
0
votes
1
answer
153
views
Dynamically creating an SQL query with many ANDs and ORs
I have a .NET Forms application that is a tracking system for manufacturing. I have a DataGridView and several ListViews with checkable items to filter the data table. Filters include part number, ...
-2
votes
1
answer
1k
views
Data deleting logically from table but still sqlite db file size same
I am using sqlite database.
I created fresh database and I performed bulk insert of 20K rows in a transaction and then commited the transaction.
Later I perormed delete query
delete from Table
...
0
votes
1
answer
49
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 {...
0
votes
1
answer
73
views
Two Table Database Design for Large Project
I'm starting work on a fairly complex project that will eventually be used to run multiple departments (HR, finance, etc.) as well as hold client data, etc. I've been handed a database design doc ...
0
votes
2
answers
33
views
Query SQL Sum of Value Total Time between StartDate and EndDate Parameter
Good Day!
I have some detail column (table a) like this
ID DateStart DateEnd Name TotalActivity(h)
1 2018-11-10 2018-11-25 LSA 24
2 2018-11-11 2018-11-...
0
votes
0
answers
51
views
C# Extreme duplication of log entries in database table
This C# class is making a lot of duplicates in my Oracle DB table, how do i optimize fix it to not do that, but still make logs / error reports? I have included the code for the methods that creates ...
0
votes
2
answers
32
views
Designing database with Filename, Testname and its result on every build
I have to design a database where I have to store Test Name for each Filename and Each Test Name can run on several Builds and can either Pass or Fail.
There is 1-1 relationship between Filename & ...