EF4 LINQ Ordering Parent and all child collections with Eager Loading (.Include())

by

If you need to have Ordering or Filtering on inner navigation properties (e.g. Models) then you cannot eager load them using Include method anymore. Instead,
you can use EntityCollection<TEntity>.CreateSourceQuery Method like this:

List years = db.Years.OrderBy("it.Name").ToList();
foreach(year in years) 
{
    var makesQuery = year.Makes.CreateSourceQuery().OrderBy(m => m.Name);
    year.Makes.Attach(makesQuery);  

    foreach(make in year.Makes) 
    {
        var modelsQuery = make.Models.CreateSourceQuery().OrderBy(m => m.Name);
        make.Models.Attach(modelsQuery);

        foreach(model in make.Models) 
        {
            var colQuery = model.Colors.CreateSourceQuery().OrderBy(c => c.Name);
            model.Models.Attach(colQuery);        
        }
    }
}

This way, the years object will be constructed with having all of its navigation properties ordered.

More Related Contents:

  1. ASP.NET MVC 2.0 Implementation of searching in jqgrid
  2. What’s the difference(s) between .ToList(), .AsEnumerable(), AsQueryable()?
  3. The specified type member ‘Date’ is not supported in LINQ to Entities Exception
  4. Best way to check if object exists in Entity Framework? [closed]
  5. Entity Framework 4 / POCO – Where to start? [closed]
  6. Entity Framework 4.1 default eager loading
  7. Include Grandchildren in EF Query
  8. LINQ to Entities for subtracting 2 dates
  9. LINQ To Entities + Include + Anonymous type issue
  10. ORM Entities vs. Domain Entities under Entity Framework 6.0
  11. LEFT JOIN in LINQ to entities?
  12. Entity Framework Code First – No Detach() method on DbContext
  13. How to compare only date components from DateTime in EF?
  14. Entity Framework validation with partial updates
  15. Solution for “Validation failed for one or more entities. See ‘EntityValidationErrors’ property for more details.”
  16. NOT using repository pattern, use the ORM as is (EF)
  17. How do you update an edmx file with database changes?
  18. Cascading deletes with Entity Framework – Related entities deleted by EF
  19. EF Query With Conditional Include
  20. Entity Framework CTP 4 – Code First Custom Database Initializer
  21. How do I singularize my tables in EF Code First?
  22. Set decimal(16, 3) for a column in Code First Approach in EF4.3 [duplicate]
  23. Efficient way to do bulk insert/update with Entity Framework
  24. Entity Framework and calling context.dispose()
  25. Entity Framework Code First : Setting up One-To-One foreign key association using Annotations
  26. Error 6002: The table/view does not have a primary key defined
  27. check constraint entity framework
  28. Entity Framework 4.0: Error 113: Multiplicity is not valid in Role
  29. Paging in Entity Framework
  30. Using SimpleMembership with EF model-first

Leave a Comment