LINQ To Entities + Include + Anonymous type issue

by

As Ladislav mentioned, Include only works if you select the Ticket entity directly. Since you’re projecting other information out, the Include gets ignored.

This should provide a good work-around:

var data = ctx.Set<Ticket>()
    .Select(p => new 
         { 
             Ticket = p, 
             Clients = p.Client,
             LastReplyDate = p.Replies.Max(q => q.DateCreated)
         });

First of all, each Ticket’s Clients will be accessible directly from the Clients property on the anonymous type. Furthermore, Entity Framework should be smart enough to recognize that you have pulled out the entire Client collection for each Ticket, so calling .Ticket.Client should work as well.

More Related Contents:

  1. ASP.NET MVC 2.0 Implementation of searching in jqgrid
  2. Code-first vs Model/Database-first [closed]
  3. Entity Framework: One Database, Multiple DbContexts. Is this a bad idea? [closed]
  4. What’s the difference(s) between .ToList(), .AsEnumerable(), AsQueryable()?
  5. Unique Key constraints for multiple columns in Entity Framework
  6. Entity Framework 6 Code first Default value
  7. EntityFramework code-first custom connection string and migrations
  8. Best way to check if object exists in Entity Framework? [closed]
  9. EF Code First “Invalid column name ‘Discriminator'” but no inheritance
  10. Improve navigation property names when reverse engineering a database
  11. Should I enable or disable dynamic proxies with entity framework 4.1 and MVC3?
  12. EF5 Code First Enums and Lookup Tables
  13. Entity Framework 4 / POCO – Where to start? [closed]
  14. Debug code-first Entity Framework migration codes
  15. Entity framework code-first null foreign key
  16. Entity Framework loading child collection with sort order
  17. How do I singularize my tables in EF Code First?
  18. How do you ensure Cascade Delete is enabled on a table relationship in EF Code first?
  19. mapping private property entity framework code first [duplicate]
  20. How to create index in Entity Framework 6.2 with fluent configuration
  21. Entity Framework Code First : Setting up One-To-One foreign key association using Annotations
  22. Mocking or faking DbEntityEntry or creating a new DbEntityEntry
  23. Include Grandchildren in EF Query
  24. How to use Entity Framework to map results of a stored procedure to entity with differently named parameters
  25. EF Code First foreign key without navigation property
  26. LINQ to Entities for subtracting 2 dates
  27. Entity Framework Code First Using Guid as Identity with another Identity Column
  28. Why does EF5 code first use datetime2 when inserting a nullable datetime into the database?
  29. EF4 LINQ Ordering Parent and all child collections with Eager Loading (.Include())
  30. Entity framework code first delete with cascade

Leave a Comment