Linq-to-entities – Include() method not loading

by

UPDATE: Actually I recently added another Tip that covers this, and provides an alternate probably better solution. The idea is to delay the use of Include() until the end of the query, see this for more information: Tip 22 – How to make include really include

There is known limitation in the Entity Framework when using Include().
Certain operations are just not supported with Include.

Looks like you may have run into one on those limitations, to work around this you should try something like this:

var results = 
   from e in dc.Entities //Notice no include
   join i in dc.Items on e.ID equals i.Member.ID
   where (i.Collection.ID == collectionID) 
   select new {Entity = e, Properties = e.Properties};

This will bring back the Properties, and if the relationship between entity and Properties is a one to many (but not a many to many) you will find that each resulting anonymous type has the same values in:

anonType.Entity.Properties
anonType.Properties

This is a side-effect of a feature in the Entity Framework called relationship fixup.

See this Tip 1 in my EF Tips series for more information.

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. Entity framework linq query Include() multiple children entities
  4. How to filter nested collection Entity Framework objects?
  5. LINQ to Entities does not recognize the method ‘System.String Format(System.String, System.Object, System.Object)’
  6. Only initializers, entity members, and entity navigation properties are supported
  7. Convert String to Int in EF 4.0
  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. LINQ to Entities does not recognize the method
  17. Unable to create a constant value of type Only primitive types or enumeration types are supported in this context
  18. LINQ-to-SQL vs stored procedures? [closed]
  19. “A lambda expression with a statement body cannot be converted to an expression tree”
  20. How to view LINQ Generated SQL statements?
  21. Entity Framework/Linq EXpression converting from string to int
  22. Error: “The specified LINQ expression contains references to queries that are associated with different contexts”
  23. LINQ to Entities does not recognize the method ‘Int32 Int32(System.String)’ method, and this method cannot be translated into a store expression
  24. How can I reject all changes in a Linq to SQL’s DataContext?
  25. How to convert an expression tree to a partial SQL query?
  26. Converting flattened hierarchical data from SQL Server into a structured JSON object with C#/Linq
  27. Greater Than Condition in Linq Join
  28. How do I write this cross apply query in LINQ-to-SQL?
  29. How to include() nested child entity in linq
  30. How to implement Unit of Work that works with EF and NHibernate

Leave a Comment