Entity Framework Core set Navigation property to null with include doesn't work

c# entity-framework-core


I am trying to reset the project navigation property in my asset entity.

Asset Model (removed everything unrelated):

public class Asset
    public int Id { get; set; }
    public int? ProjectId { get; set; }
    public Project Project { get; set; }

Reset logic:

var asset = await context.Assets.Include("Project").FirstAsync(a => a.Id == assetId);
asset.Project = null;
asset.ProjectId = null;
await context.SaveChangesAsync();

I included the project in the query and tried to set the Project and the ProjectId to null, but it doesn't update in the database. Additionally I already tried to only set the Project and only set the ProjectId to null but neither works.

There are a few related questions on SO for this problem, but for all of them the Include("xy") seems to solve the problem.

6/24/2019 1:02:41 AM

Accepted Answer

Easy to solve but hard to track down. I called context.ChangeTracker.QueryTrackingBehavior = QueryTrackingBehavior.NoTracking; on the context at some point before, which makes the result read only. source

Two solutions:

  • Either remove this line (for me it was a leftover from playing around),
  • or add .AsTracking() to the query if you want to keep the general no tracking behavior.

With my example from above it would look like:

var asset = await context.Assets.Where(a => a.Id == assetId).Include("Project")
asset.Project = null;

If you have the foreign key available on your model you can remove the include and just set the foreign key to null like this:

var asset = await context.Assets.Where(a => a.Id == assetId).AsTracking().FirstOrDefaultAsync()
asset.ProjectId = null;

And again without context.ChangeTracker.QueryTrackingBehavior = QueryTrackingBehavior.NoTracking; you can omit .AsTracking() because that is the standard behavior.

6/24/2019 1:42:23 AM

Related Questions


Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow