Why Entity Framework have AddAsync?

What is the best way to set navigation property having only id in Entity Framework?

It is possible to create the ...MySecondEntity... object manually, and attach it to the context as an unchanged object....var secondEntity = new MySecondEntity(); secondEntity.Id = id; context.MySecondEntities.Attach(secondEntity); entity.SecondEntity = secondEntity; ...To keep it simple, I have ignored the possibility that a ...MySecondEntity... o...

Entity Framework Core - .Contains() - Why escaping instead of parametrization?

In a web application, I get user input in the form of a ...List<string>... from the ViewModel and use this information to select the Ids of the users with the following code:...var selectedUsersIds = Context.Users .Where(user => SelectedUsers.Contains(user.Email)) .Select(user => user.Id) .ToList(); ...SelectedUsers... is the list of strings (user...

Why does my Required property not being cascade deleted in Entity Framework Core?

I have the following class with a required property, and am running into issues deleting dependent properties via cascade delete....public class City { [Key] public int Id {get; private set; } [Required] public ZipCode ZipCode { get; private set; } } public class ZipCode { [Key] public int Id { get; private set; } ...

I am having trouble creating DB in SQL Server Express with Entity Framework Core 2.0

I am going through the MvcMusicStore tutorial on the www.asp.net website....I am able to use Entity Framework Core 2.0 and migrations to create a DB in localDb. Here is the connection string from that in appsettings.json:..."MvcMovieContext": "Server=(localdb)\\mssqllocaldb;Database=MvcMovieContext-19840e0a-5fb4-409c-9f38-7f2946cd3937;Trusted_Conne...

Why does Entity Framework Core 2 Attach() method not cause subsequent changes to be tracked?

I'm porting an application to EF Core 2, and I want to do a lot of partial updates to objects. But, I don't want to query those objects first (I already know they are there and I don't care what the previous values of the properties I'm changing are; querying them is a waste of a round trip to the DB)....In EF6, I'd simply create an object with th...

Why stored procedure out parameter is not getting read by entity framework's ExecuteSqlCommand method?

I am trying to read the OUT parameters value returned by stored procedure but it throws error ...DBNULL.... Even the procedure is returning the value....Code:... int? outParam= 0; SqlParameter sqlParam= new SqlParameter("@model", user.Name+" Model"); SqlParameter sqlParamOut = new SqlParameter("out", outParam); sqlParamOut.DbType = Syst...

Why am I getting duplicate ID columns when using Table Per Hierarchy in Entity Framework Core?

I am trying to use "table per hierarchy" to model a variety of account types in my database using EF Core (2.1) and I am having a problem where I am getting additional foreign key columns added for the derived types. I have seen ...this... question/answer but I don't think it is the same as my situation....Here are my account classes:...public abst...

Why is Entity Framework trying to update more than one row when I save my changes?

Just to explain why:...You ask the database for all active users with the specific id and take the first result....Entity Framework sends the request and materializes the result into an object....You change the property....Entity framework will set the state of the object to changed....You call ...SaveChanges... to signal EF that it sends back the ...

Why is Entity Framework core loading entity's relations without adding include

Regarding @cristi71000 answer, that was the case. my solution was adding ...AsNoTracking()... as the following:...var dbProject = db.Projects.AsNoTracking()...

Entity Framework Core use Dbset without having T

I want to be able use a type instead of T with Dbset...For example Dbset(myType) instead of DbSet...EF core 3.1 requires you to use DbSet and all the functionality is encapsulated in Extension methods.