Eager loading of 2 levels in entity framework using Lambda Expression

Question

I am working with MS entity-framework core and I am trying to do a eager loading query. For that I have the following method:

public FieldSet GetFieldSetById(int id)
{
    return _context.FieldSet.Include("FieldSetFields.Field").SingleOrDefault(fs => fs.FieldSetId == id);
}

this code works fine, but I was wondering how can I achieve it using the lambda syntax (System.Func).

So far I have this one that works as well, but does not include the "Field".

return _context.FieldSet.Include(e => e.FieldSetFields).SingleOrDefault(fs => fs.FieldSetId == id);

FieldSetFields is a list, and then I cannot call .Field. How can I achieve this?

DavidG · Accepted Answer · 2018-09-26 11:43:09Z

1

return _context.FieldSet
    .Include(e => e.FieldSetFields)
        .ThenInclude(fsf => fsf.Field)
    .SingleOrDefault(fs => fs.FieldSetId == id);

answered Sep 26, 2018 at 11:43

DavidG

120k13 gold badges232 silver badges239 bronze badges

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

1 Answer 1