Entity Framework Include() is not working

by

The problem might be related to the subquery in your Linq expression. Subselects, grouping und projections can cause eager loading with Include to fail silently, as mentioned here and explained in more detail here (see answers of Diego Vega somewhere in the middle of the thread).

Although I cannot really see that you violate any of the rules to follow when using Include as described in those posts, you could try to change the query according to the recommendation:

var questions = from q in db.Questions
                from sq in db.SurveyQuestions
                where sq.Survey == surveyTypeID
                orderby sq.Order
                select q;

var questionsWithInclude = ((ObjectQuery)questions).Include("QuestionType");

foreach( var question in questionsWithInclude ) {
    Console.WriteLine("Question Type: " + question.QuestionType.Description);
}

(Or use the extension method mentioned in the posts.)

If I understand the linked posts correctly, this does not necessarily mean that it will work now (probably not), but you will get an exception giving you more details about the problem.

More Related Contents:

  1. There is already an open DataReader associated with this Command which must be closed first
  2. Validation failed for one or more entities. See ‘EntityValidationErrors’ property for more details [duplicate]
  3. Entity Framework Join 3 Tables
  4. Entity Framework Timeouts
  5. EF Including Other Entities (Generic Repository pattern)
  6. Entity Framework/Linq EXpression converting from string to int
  7. LEFT JOIN in LINQ to entities?
  8. The mapping of CLR type to EDM type is ambiguous with EF 6 & 5?
  9. The result of a query cannot be enumerated more than once
  10. Does Entity Framework 4 Code First have support for identity generators like NHibernate?
  11. Entity Framework Code First Lazy Loading
  12. Entity Framework – Add Navigation Property Manually
  13. Internal .NET Framework Data Provider error 1025
  14. Creating dynamic queries with entity framework
  15. Better way to query a page of data and get total count in entity framework 4.1?
  16. Entity Framework Code Only error: the model backing the context has changed since the database was created
  17. EF4 Code First: how to add a relationship without adding a navigation property
  18. Entity Framework 4: How to find the primary key?
  19. How to Refresh DbContext
  20. Is it possible to prevent EntityFramework 4 from overwriting customized properties?
  21. Change db table name in EF4 (entity framework 4)
  22. Entity Framework Multiple Object Contexts
  23. Entity Framework Code First naming conventions – back to plural table names?
  24. Repository Pattern, POCO, and Business Entities
  25. ASP.NET MVC – Attaching an entity of type ‘MODELNAME’ failed because another entity of the same type already has the same primary key value
  26. Ignoring a class property in Entity Framework 4.1 Code First
  27. “A lambda expression with a statement body cannot be converted to an expression tree”
  28. How can I lock a table on read, using Entity Framework?
  29. Adding stored procedures complex types in Entity Framework
  30. Questions about Entity Framework Context Lifetime

Leave a Comment