Entity Framework navigation property not set when adding entity

Question

When I add an a new entity to a table I would want to populate the navigation properties after saving the changes. How would I do this?

Here's what I'm doing now, and the navigation property Condition is null. I have checked that the foreign key has been set. I also tried just assigning to the nav property manually by reading from the other table directly but even that did not work.

...
var group = _context.Groups.AddRange(groups).First();
await _context.SaveChangesAsync();
// group.Condition which is a navigation property is null after this. 
// The property does work when I get the group from the context, after adding.

Have you tried var group = _context.Groups.AddRange(groups).First().Include(x=>x.Condition); — Mashton
– Mashton, Commented Jun 5, 2014 at 14:53
That doesn't work, can't even use Include there. Doing an update of the entity where I use Include after saving did it. — JuhaKangas
– JuhaKangas, Commented Jun 5, 2014 at 15:46

Community · Accepted Answer · 2017-05-23 11:44:43Z

4

This will be the case when lazy loading is disabled. Enable it by adding virtual keyword to the properties. You can also use eager loading by using _context.Groups.Include("Condition")

You can get details from similar question Navigation property returns null after inserting

edited May 23, 2017 at 11:44

CommunityBot

11 silver badge

answered Jun 5, 2014 at 14:56

Ankit Sinha

4213 silver badges11 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

JuhaKangas Over a year ago

The property was already marked virtual. I got it to work by looking at your link though. Include did it, however I had to update the entity after saving.

Community · Accepted Answer · 2017-05-23 11:44:43Z

0

Here's how I got it to work by checking the link provided by Ankit Sinha:

var group = _context.Groups.AddRange(groups).First();
await _context.SaveChangesAsync();
var group = _context.Groups.Include(x => x.Condition).SingleOrDefaultAsync(x => x.Id == group.id);

edited May 23, 2017 at 11:44

CommunityBot

11 silver badge

answered Jun 5, 2014 at 15:51

JuhaKangas

8935 silver badges17 bronze badges

Collectives™ on Stack Overflow

Entity Framework navigation property not set when adding entity

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related