How to include() nested child entity in linq

by

To get a job and eager load all its quotes and their quoteitems, you write:

var job = db.Jobs
        .Include(x => x.Quotes.Select(q => q.QuoteItems))
        .Where(x => x.JobID == id)
        .SingleOrDefault();

You might need SelectMany instead of Select if QuoteItems is a collection too.

Note to others; The strongly typed Include() method is an extension method so you need to include using System.Data.Entity; at the top of your file.

More Related Contents:

  1. Linq: help me to make this work
  2. How do I apply OrderBy on an IQueryable using a string column name within a generic extension method?
  3. Why is .Contains slow? Most efficient way to get multiple entities by primary key?
  4. Entity Framework/Linq EXpression converting from string to int
  5. Filter/Search using Multiple Fields – ASP.NET MVC
  6. How to convert an expression tree to a partial SQL query?
  7. Join and Include in Entity Framework
  8. Max return value if empty query
  9. Remove item from list based on condition
  10. How to do an “in” query in entity framework?
  11. Keep Getting ‘The LINQ expression node type ‘Invoke’ is not supported in LINQ to Entities’ Exception
  12. Linq Query keeps throwing “Unable to create a constant value of type System.Object….”, Why?
  13. Should the order of LINQ query clauses affect Entity Framework performance?
  14. LINQ Query to Convert string to datetime
  15. How to write this nested foreach loop query in LINQ?
  16. Linq: GroupBy, Sum and Count
  17. How to compare only Date without Time in DateTime types in Linq to SQL with Entity Framework?
  18. Extension methods syntax vs query syntax
  19. Conversion from List to array T[]
  20. How do I create an expression tree calling IEnumerable.Any(…)?
  21. Entity Framework – Cannot convert lambda expression to type ‘string’ because it is not a delegate type
  22. Internal .NET Framework Data Provider error 1025
  23. How to filter data using Entity Framework in a way that DataGridView be editable and context track changes?
  24. What is the performance of the Last() extension method for List?
  25. Filtering include items in LINQ and Entity Framework [duplicate]
  26. Should I use two “where” clauses or “&&” in my LINQ query?
  27. Entity Framework Code Only error: the model backing the context has changed since the database was created
  28. Performance of Find() vs. FirstOrDefault() [duplicate]
  29. Update records using LINQ
  30. How to convert DataTable to class Object?

Leave a Comment