Include does not load related data

Question

Any idea why this line

var guild = _context.Guilds.Include(x => x.Heroes).Single(x => x.Id == 1);

Will leave heroes null on the guild but if I do this first

var heroes = _context.Heroes.ToList();
var guild = _context.Guilds.Include(x => x.Heroes).Single(x => x.Id == 1);

Then heroes on the guild object has been included and now works fine?

DbContext

public class TestContext : DbContext
{
    public TestContext(DbContextOptions options) : base(options)
    { }

    public DbSet<Guild> Guilds { get; set; }
    public DbSet<Hero> Heroes { get; set; }
}

public class Hero : IEntity
{
    public int Id { get; set; }

    public string FirstName { get; set; }
    public string LastName { get; set; }
    public string AvatarId { get; set; }
}

public class Guild : IEntity
{
    public int Id { get; set; }
    public string Name { get;  set; }
    public string UserId { get; set; }
    public List<Hero> Heroes { get; set; }

    public void AddHeroes(IEnumerable<Hero> heroes)
    {
        foreach (var hero in heroes)
        {
            Heroes.Add(hero);
        }
    }
}

Can you add both classes and how you configured them on the DbContext? — Camilo Terevinto, Jan 06 '18 at 19:39
Where's the Foreing Key that links `Hero` to `Guild`? You need a `GuildId` in `Hero` — Camilo Terevinto, Jan 06 '18 at 19:46
I dont think so as ef core seems to have figured that out with the migration script, also that would not explain how include works fine when calling all the heroes first — Luke, Jan 06 '18 at 19:47
Please read [here](https://learn.microsoft.com/en-us/ef/core/miscellaneous/logging) to enable SQL logging. We'll need to see what SQL is being generated and what's your database — Camilo Terevinto, Jan 06 '18 at 19:51

Include does not load related data

0 Answers0