All Questions
Tagged with .net entity-framework
9,741
questions
0
votes
0
answers
23
views
Strategy for handling multiple EF Migrations
I need help formulating a strategy for handling situations where two or more team members create an EF migration independently and for different reasons. Every single time we've had this scenario so ...
- 7,075
0
votes
1
answer
37
views
Why installation of dotnet-ef fails even if --ignore-failed-sources is specified
I'm building a .NET 6 project via Azure DevOps Pipelines. One of the step is to install the Entity Framework tools so a later step can generate a SQL migration script.
However, the installation step ...
- 2,324
0
votes
0
answers
26
views
Problem with concurrency while updating data in DB using Quartz .NET and EF Core
I want to introduce horizontal scaling instead of vertical in my app.
Now we are using Quartz .NET for background tasks, but in non-clustered mode, just 1 instance.
So I found ability to do horizontal ...
0
votes
0
answers
12
views
How to create 3 tables using EF OData concept, without foThe title key reference constraint in C table
For example A, B, C are 3 tables I want to create in A table 1 column collection of id's in B table primary key.
B table has details of that id's.
C table 2 primary keys only that is A & B tables....
0
votes
1
answer
57
views
Pagination on the result from multiple collection .net
I am trying to add offset pagination( input is pagesize and limit) on combined result which is aggregating multiple collections. Earlier I had only limit on the reponse. Below is the code for the API ...
- 333
0
votes
0
answers
27
views
Need to order by list using row value using entity framework [duplicate]
I have data in following format as shown in the sample table data. I want to order by this data in ascending order for ND values.
Means like from ND1 to ND10.
I tried the following way:
return await ...
- 330
0
votes
0
answers
24
views
'Skip navigation doesn't have an inverse navigation configured' error when migrating
I am working on a C# Web API project and when attempting to Add-Migration, I keep getting this error:
Unable to create a 'DbContext' of type ''. The exception 'The skip navigation 'Class.Staffs' doesn'...
0
votes
0
answers
53
views
The instance of entity type 'ApplicationUser' cannot be tracked because another instance with the same key value for {'Id'} is already being tracked
I have an app that uses the entity framework. I have 2 DB contexts, one for the live sql database and another using InMemory for users to demo the site without changing the live db. The problem is ...
- 39
-1
votes
1
answer
65
views
Cannot add multiple same objects to DB, only distinct are saved. .NET EntityFramework
I have a template of exercise with name, description and amount of sets. I want to create multiple objects of Exercise * amount of sets. For example I have template [{ "name" : "Legs&...
- 13
0
votes
0
answers
28
views
Use some kind of helper function In EF Select query to make subquery [duplicate]
I have several tables that handles different kinds of translations for my entities and those tables to linked via relations to other entities.
I use subquery to directly access translations tables ...
0
votes
1
answer
30
views
.Net Entity Framework. Updating ICollection of an object
I've searched for resolution on similar problems and I made some progress but I got stuck to the poin I can't progress.
I'm woring on a practie project where I can update the member of the app details....
0
votes
1
answer
67
views
Better way of handling many-to-many relations with EF db-first approach in .NET6
I'm having a Request table (EF generated):
public class Request
{
public int Id { get; set; }
public string Name {get; set; }
public virtual ICollection<AttendeeRequest> ...
- 179
0
votes
1
answer
38
views
How to manage multiple uses of a model in an application?
I'm currently implementing an application and have for example a Customer model that's used in several different parts of the application. Each part only uses a subset of the properties from the ...
- 71
0
votes
0
answers
14
views
EF Core: How to scaffold and work with 2 schemas from Postgres with shared FK between them
I try for the first time to manage two schemas in Postgres where one id from the 1st schema is referenced as FK in the 2nd schema in another table. I tried scaffolding the schemas as separate contexts ...
0
votes
0
answers
30
views
Search implemented using LinqKit predicateBuilder working fine in the local but not working in the dev build
I have implemented a search functionality using the LinqKit predicate builder. It is working fine in the local environment and when it is published to a folder the same functionality is not working. ...
- 1