EF Including Other Entities (Generic Repository pattern)

by

Use just the Include extension on IQueryable. It is available in EF 4.1 assembly. If you don’t want to reference that assembly in your upper layers create wrapper extension method in your data access assembly.

Here you have example:

public static IQueryable<T> IncludeMultiple<T>(this IQueryable<T> query, params Expression<Func<T, object>>[] includes)
    where T : class
{
    if (includes != null)
    {
        query = includes.Aggregate(query, 
                  (current, include) => current.Include(include));
    }

    return query;
}

You will use it for example like:

var query = context.Customers
                   .IncludeMultiple(
                       c => c.Address,
                       c => c.Orders.Select(o => o.OrderItems));

This query will load all customers with their addresses and orders and every order will contain its order items.

More Related Contents:

  1. Does Entity Framework 4 Code First have support for identity generators like NHibernate?
  2. Entity Framework Code First Lazy Loading
  3. EF4 Code First: how to add a relationship without adding a navigation property
  4. Entity Framework Code First naming conventions – back to plural table names?
  5. Ignoring a class property in Entity Framework 4.1 Code First
  6. Entity Framework Join 3 Tables
  7. Entity Framework Timeouts
  8. Implementing Zero Or One to Zero Or One relationship in EF Code first by Fluent API
  9. Entity Framework/Linq EXpression converting from string to int
  10. One to one optional relationship using Entity Framework Fluent API
  11. EF Code First: How to get random rows
  12. The result of a query cannot be enumerated more than once
  13. Entity Framework – Add Navigation Property Manually
  14. Internal .NET Framework Data Provider error 1025
  15. Entity Framework Include() is not working
  16. Optimistic concurrency: IsConcurrencyToken and RowVersion
  17. Better way to query a page of data and get total count in entity framework 4.1?
  18. Entity Framework Code Only error: the model backing the context has changed since the database was created
  19. Entity Framework 4: How to find the primary key?
  20. How to Refresh DbContext
  21. How do I specify that a property should generate a TEXT column rather than an nvarchar(4000)
  22. How to Specify Primary Key Name in EF-Code-First
  23. Is it possible to prevent EntityFramework 4 from overwriting customized properties?
  24. Change db table name in EF4 (entity framework 4)
  25. Entity Framework: Duplicate Records in Many-to-Many relationship
  26. Mixing Fluent API and DataAnnotations in EF code first
  27. The relationship could not be changed because one or more of the foreign-key properties is non nullable
  28. Repository Pattern, POCO, and Business Entities
  29. How should I access a computed column in Entity Framework Code First?
  30. How can set a default value constraint with Entity Framework 6 Code First?

Leave a Comment