CODEWITHSUNDEEP
c#entity-frameworkentity-framework-core
Allen Rufolo
Allen Rufolo

Reputation: 1202

Entity Framework Core Eager Loading Then Include on a collection

I have three Models that I want to include when performing a query.

Here is the scenario. 

public class Sale
{
     public int Id { get; set; }
     public List<SaleNote> SaleNotes { get; set; }
}

public class SaleNote
{
    public int Id { get; set; }
    public User User { get; set; }
}

public class User 
{
    public int Id { get; set; }
}

I can eager load the SaleNotes like this... 

_dbContext.Sale.Include(s => s.SaleNotes);

However, trying to eager load the User model from the SaleNote using ThenInclude is challenging because it is a collection. I cannot find any examples on how to eager load this scenario. Can someone supply the code the goes in the following ThenInclude to load the User for each item in the collection. 

_dbContext.Sale.Include(s => s.SaleNotes).ThenInclude(...);

Upvotes: 50

Views: 35919

Answers (2)

Bandito
Bandito

Reputation: 329

For reference, the latest release (at the time of posting) EF Core 1.1.0 also supports explicit loading for this scenario. Something like this...

using (var _dbContext = new DbContext())
{
    var sale = _dbContext.Sale
        .Single(s => s.Id == 1);

    _dbContext.Entry(sale)
        .Collection(n => n.SalesNotes)
        .Load();
  
    _dbContext.Entry(sale)
        .Reference(u => u.User)
        .Load();
}

Upvotes: 4

ocuenca
ocuenca

Reputation: 39326

It doesn't matter that SaleNotes is collection navigation property. It should work the same for references and collections:

_dbContext.Sale.Include(s => s.SaleNotes).ThenInclude(sn=>sn.User);

But as far I know, EF7 also supports the old multi-level Include syntax using Select extension method:

_dbContext.Sale.Include(s => s.SaleNotes.Select(sn=>sn.User));

Upvotes: 70

Related Questions