Entity framework linq query Include() multiple children entities

by

Use extension methods.
Replace NameOfContext with the name of your object context.

public static class Extensions{
   public static IQueryable<Company> CompleteCompanies(this NameOfContext context){
         return context.Companies
             .Include("Employee.Employee_Car")
             .Include("Employee.Employee_Country") ;
     }

     public static Company CompanyById(this NameOfContext context, int companyID){
         return context.Companies
             .Include("Employee.Employee_Car")
             .Include("Employee.Employee_Country")
             .FirstOrDefault(c => c.Id == companyID) ;
      }

}

Then your code becomes 

     Company company = 
          context.CompleteCompanies().FirstOrDefault(c => c.Id == companyID);

     //or if you want even more
     Company company = 
          context.CompanyById(companyID);

More Related Contents:

  1. Entity Framework: There is already an open DataReader associated with this Command
  2. Linq: adding conditions to the where clause conditionally
  3. How to filter nested collection Entity Framework objects?
  4. LINQ to Entities does not recognize the method ‘System.String Format(System.String, System.Object, System.Object)’
  5. Only initializers, entity members, and entity navigation properties are supported
  6. Convert String to Int in EF 4.0
  7. Linq-to-entities – Include() method not loading
  8. Entity Framework – “Unable to create a constant value of type ‘Closure type’…” error
  9. Instantiating a context in LINQ to Entities
  10. conditional include in linq to entities?
  11. EF 4: Removing child object from collection does not delete it – why?
  12. Linq To Entities – how to filter on child entities
  13. Entity Framework, Code First and Full Text Search
  14. LINQ OrderBy not ordering .. changing nothing .. why?
  15. Simple Linq query has duplicated join against same table?
  16. ‘Contains()’ workaround using Linq to Entities?
  17. How to use a string to create a EF order by expression?
  18. System.LINQ.Dynamic: Select(” new (…)”) into a List (or any other enumerable collection of )
  19. Standard Deviation in LINQ
  20. How To Project a Line Number Into Linq Query Results
  21. Calculate difference from previous item with LINQ
  22. LINQ with SQLite (linqtosql)
  23. How to create a dynamic LINQ join extension method
  24. Join and Include in Entity Framework
  25. Creating dynamic queries with entity framework
  26. Remove item from list based on condition
  27. Entity Framework Eager Load Not Returning Data, Lazy Load Does
  28. How to group by DateTime.Date in EntityFramework
  29. How to include() nested child entity in linq
  30. LINQ Query to Convert string to datetime

Leave a Comment