All Questions
Tagged with sql-server entity-framework
30 questions
2
votes
2
answers
113
views
Could concurrent user-triggered data fetches and inserts lead to deadlocks in a multi-user ASP.NET Core + MSSQL application?
I'm facing a tricky situation that might result from a not thoroughly thought-out design, and I'm hoping to understand whether a deadlock might be a realistic cause – and if so, how to prevent similar ...
1
vote
3
answers
674
views
Creating Unit and Integration Tests with Database elements
This is something that I've heard a number of opinions and theories about, but I'm still torn on how to go forward.
For context, this particular issue deals with the following technologies, in case ...
- 323
1
vote
2
answers
85
views
Should I avoid putting Id's in a contract/response model?
Here is the scenario:
Let's assume that we have a Telephone and a Driver.
Here is the definition of the classes (Pseudocode):
Telephone:
{
Id: number,
[Unique] TelephoneNumber: string
}
Driver:
{
...
- 109
-1
votes
1
answer
134
views
Strategy to make sure relevant cache records are expired on data update
In our database, we have around 150 different tables. However, there are a handful of them that are key, as in they get referenced pretty much everywhere. We also have quite a few reports that we pull ...
- 206
0
votes
0
answers
545
views
Net Core: Solutions to Update History Tables in Application Design
Our company did not properly design Address Record Code Module. Developers are updating Address SQL table with Multiple Service Methods, and are not updating AddressHistory Sql table. They're asking ...
user354368
2
votes
1
answer
152
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
0
votes
1
answer
199
views
Venue Reservation System Logic Approach/Clarification
I hope this is the right place to ask since this is a programming related question.
I’m developing a venue reservation app (similar to booking.com) and am almost done however I have 1 request for ...
- 103
0
votes
0
answers
180
views
Real-time application and RDBMS bottleneck
I'm currently developing a real-time application using .NET Core 2.2. Many IOT devices (could be up to 100) are concurrently sending messages via MQTT. These messages are parsed, elaborated to extract ...
- 101
2
votes
4
answers
6k
views
Is Entity Framework Core slower than using ADO .NET and stored procedures?
I'm looking at designing some new software for work, and I have been using EF Core quite a bit in my personal projects.
In my mind, EF Core generates queries for the underlying data provider which ...
- 159
0
votes
3
answers
3k
views
Nullable foreign keys and creating join tables
I'm not that experienced in sql modeling, but i´m thinking of an intricate problem (or/and a silly one).
I have a project table(table 1) with many projectassignments(table 2), which is a join table. ...
- 111
2
votes
0
answers
4k
views
Entity Framework naming conventions for the same table name across multiple schemas
The DbContext of my application's Entity Framework setup (which I will refer to as ApplicationContext, the name of our derived type) contains classes for all of the tables in our SQL Server database, ...
- 302
2
votes
2
answers
6k
views
Data Encryption in Data Layer with ASP.NET Core Entity Framework
I am currently designing a web application where the data needs to be stored encrypted.
Planned technologies used:
ASP.NET Core API
ASP.NET Core Entity Framework
MS SQL Server 2016
any Web Frontend
...
- 129
0
votes
2
answers
4k
views
Entity framework vs pure ado .net in calling stored procedure in an enterprise project
There is an enterprise project, which all the business implemented in databases and in the stored procedures, and web API is just like a light wrapper which get the request and deliver it to proper ...
- 133
7
votes
1
answer
2k
views
Determining the best way(s) of adding unit tests to a large project that makes good use of stored procedures
We work on a fairly large casino/gaming/wallet/lottery platform. It's a turn-key application that is currently in use by 4 clients, and soon to be much more. I've made some bullet points regarding the ...
- 269
2
votes
3
answers
4k
views
Is it OK to create and drop databases during unit tests
I am working with EntityFramework 6 code first approach and SQL Server 2014 Express. However, the DBMS may change in future.
That setup allows easily to create a database and add some dummy data for ...
- 306