Entity Framework – Include Multiple Levels of Properties

by

For EF 6

using System.Data.Entity;

query.Include(x => x.Collection.Select(y => y.Property))

Make sure to add using System.Data.Entity; to get the version of Include that takes in a lambda.

For EF Core

Use the new method ThenInclude

using Microsoft.EntityFrameworkCore;

query.Include(x => x.Collection)
     .ThenInclude(x => x.Property);

More Related Contents:

  1. Why does the EF 6 tutorial use asynchronous calls?
  2. ‘Contains()’ workaround using Linq to Entities?
  3. Entity Framework .Remove() vs. .DeleteObject()
  4. How to add/update child entities when updating a parent entity in EF
  5. How to use a string to create a EF order by expression?
  6. Why is inserting entities in EF 4.1 so slow compared to ObjectContext?
  7. How do I clear tracked entities in entity framework
  8. Why is Asp.Net Identity IdentityDbContext a Black-Box?
  9. Navigation Property without Declaring Foreign Key
  10. Entity Framework Specification Pattern Implementation
  11. MySQL Entity Framework Error – The specified store provider cannot be found in the configuration, or is not valid
  12. Join and Include in Entity Framework
  13. Creating dynamic queries with entity framework
  14. How to I apply filter while paginating in Asp.net MVC and entity Framework?
  15. Global setting for AsNoTracking()?
  16. Json.Net adding $id to EF objects despite setting PreserveReferencesHandling to “None”
  17. Remove item from list based on condition
  18. Unit testing with EF Core and in memory database
  19. Entity Framework – how do I get the columns?
  20. Entity Framework Eager Load Not Returning Data, Lazy Load Does
  21. EF models. Navigation properties can only participate in a single relationship
  22. Seed Entities AND Users, Roles?
  23. How to group by DateTime.Date in EntityFramework
  24. Testing an Entity Framework database connection
  25. Entity Framework Code First naming conventions – back to plural table names?
  26. Should the order of LINQ query clauses affect Entity Framework performance?
  27. How should I access a computed column in Entity Framework Code First?
  28. MVC 4 – Many-to-Many relation and checkboxes
  29. How can set a default value constraint with Entity Framework 6 Code First?
  30. Why Entity Framework performs faster than Dapper in direct select statement [closed]

Leave a Comment