EF LINQ include multiple and nested entities

by

Have you tried just adding another Include:

Course course = db.Courses
                .Include(i => i.Modules.Select(s => s.Chapters))
                .Include(i => i.Lab)
                .Single(x => x.Id == id);

Your solution fails because Include doesn’t take a boolean operator

Include(i => i.Modules.Select(s => s.Chapters) &&          i.Lab)
                           ^^^                  ^             ^ 
                          list           bool operator    other list

Update
To learn more, download LinqPad and look through the samples.
I think it is the quickest way to get familiar with Linq and Lambda.

As a start – the difference between Select and Include is that that with a Select you decide what you want to return (aka projection). The Include is a Eager Loading function, that tells Entity Framework that you want it to include data from other tables.

The Include syntax can also be in string. Like this:

           db.Courses
            .Include("Module.Chapter")
            .Include("Lab")
            .Single(x => x.Id == id);

But the samples in LinqPad explains this better.

More Related Contents:

  1. LINQ to Entities does not recognize the method
  2. How do I enable EF migrations for multiple contexts to separate databases?
  3. ASP.NET MVC: Is Controller created for every request?
  4. LINQ to Entities does not recognize the method Int32 get_Item(Int32)
  5. Entity Framework 4 Single() vs First() vs FirstOrDefault()
  6. The model backing the ‘ApplicationDbContext’ context has changed since the database was created
  7. LINQ: When to use SingleOrDefault vs. FirstOrDefault() with filtering criteria
  8. MVC3 and Entity Framework
  9. Fake DbContext of Entity Framework 4.1 to Test
  10. Entity Framework: table without primary key
  11. Wrap a delegate in an IEqualityComparer
  12. how to use views in code first entity framework [closed]
  13. Non-static method requires a target
  14. Linq int to string
  15. Does Entity Framework support parallel async queries? [duplicate]
  16. How to make Entity Framework Data Context Readonly
  17. .NET List Concat vs AddRange
  18. The repository itself is not usually tested?
  19. Why use LINQ Join on a simple one-many relationship?
  20. Can’t find ADO.net Entity Data Model template in VS2017
  21. Entity Framework is Too Slow. What are my options? [closed]
  22. Where to run a duplicate check for an entity
  23. Remove item from list based on condition
  24. Why are some object properties UnaryExpression and others MemberExpression?
  25. How can I configure Entity Framework to automatically trim values retrieved for specific columns mapped to char(N) fields?
  26. How to perform merge sort using LINQ?
  27. Entity Framework Find vs. Where
  28. ‘ObjectContext’ vs ‘DbContext’ in Entity Framework
  29. LINQ Query to Convert string to datetime
  30. Using Entity Framework entities as business objects?

Leave a Comment