How do I eagerly Include the child and grandchild elements of an entity in Entity Framework Code First?
Solution 1:
Also, it isn't necessary to use the string overload. This method will work too:
var customers = db.Customers.Include(c => c.Books.Select(b => b.Author));
For more examples see the EF team blog post: http://blogs.msdn.com/b/adonet/archive/2011/01/31/using-dbcontext-in-ef-feature-ctp5-part-6-loading-related-entities.aspx
And this tutorial: http://www.asp.net/entity-framework/tutorials/reading-related-data-with-the-entity-framework-in-an-asp-net-mvc-application
Solution 2:
There's an overload for Include
that accepts a string which can denote the full path to any extra properties you need:
var customers = db.Customers.Include("Books.Author");
It looks strange because "Author" isn't a property on a collection of books (rather a property on each individual book) but it works. Give it a whirl.
Solution 3:
You can use ThenInclude
keyword:
var customers = db.Customers.Include(c => c.Books).ThenInclude(book => book.Author));}