LINQ Include vs Join. Are they equivalent?

by

An Included is intended to retain the original object structures and graphs. A Join is needed to project a flattened representation of the object graph or to join types which are not naturally related through the graph (ie. join the customer’s city with a shipping facility’s city).

Compare the following:
db.Customers.Include("Orders")
Generates an IEnumerable each of which may contain their corresponding list of Orders in an object graph like this:

Customer 1
   Order
   Order
   Order
Customer 2
   Order
   Order

In contrast, if you do the same with a join projecting into an anonymous type you could get the following:

    from c in db.Customers 
    join o in db.Orders on c.CustomerId equals o.CustomerId 
    select new {c, o}

This produces a new IEnumerable<Anonymous<Customer, Order>> where the customer is repeated for each order.

{ Customer1, orderA }
{ Customer1, orderB }
{ Customer1, orderC }
{ Customer2, orderD }
{ Customer2, orderE }
{ Customer2, orderF }

While both may issue the same request to the database, the resulting type may be quite different.

More Related Contents:

  1. Multiple “order by” in LINQ
  2. C# LINQ find duplicates in List
  3. What are the benefits of a Deferred Execution in LINQ?
  4. How to filter nested collection Entity Framework objects?
  5. Linq with group by having count
  6. LINQ Partition List into Lists of 8 members [duplicate]
  7. LINQ Between Operator
  8. LINQ recursion function?
  9. LINQ OrderBy versus ThenBy
  10. LINQ: Dot Notation vs Query Expression
  11. Learning about LINQ [closed]
  12. What’s the difference between IQueryable and IEnumerable [duplicate]
  13. Can LINQ be used in PowerShell?
  14. Use LINQ to concatenate multiple rows into single row (CSV property)
  15. Linq-to-entities – Include() method not loading
  16. PowerShell equivalent of LINQ Any()?
  17. Instantiating a context in LINQ to Entities
  18. conditional include in linq to entities?
  19. LINQ not updating on .SubmitChanges()
  20. Linq To Entities – how to filter on child entities
  21. Expose IQueryable Over WCF Service
  22. The specified type member ‘Date’ is not supported in LINQ to Entities. Only initializers, entity members, and entity navigation properties
  23. Is there a pattern using Linq to dynamically create a filter?
  24. Entity Framework, Code First and Full Text Search
  25. Simple Linq query has duplicated join against same table?
  26. Linq to SQL how to do “where [column] in (list of values)”
  27. OrderBy descending in Lambda expression?
  28. Point connectionstring in dbml to app.config
  29. LINQ: How to convert the nested hierarchical object to flatten object
  30. Fun (?) with Linq Expressions in extension methods

Leave a Comment