How does LINQ expression syntax work with Include() for eager loading

by

I figured it out, thanks for the suggestions anyway.
The solution is to do this (2nd attempt in my question):

var qry = (from a in Actions
join u in Users on a.UserId equals u.UserId    
select a).Include("User")

The reason intellisense didn’t show Include after the query was because I needed the following using:

using System.Data.Entity;

Everything worked fine doing this.

More Related Contents:

  1. Linq: help me to make this work
  2. Dynamic where clause (OR) in Linq to Entities
  3. How do I apply OrderBy on an IQueryable using a string column name within a generic extension method?
  4. Bulk-deleting in LINQ to Entities
  5. Writing Recursive CTE using Entity Framework Fluent syntax or Inline syntax
  6. The type of one of the expressions in the join clause is incorrect in Entity Framework
  7. Entity framework left join
  8. Why doesn’t Include have any effect?
  9. Recursive Hierarchy – Recursive Query using Linq
  10. Filter/Search using Multiple Fields – ASP.NET MVC
  11. Linq to EntityFramework DateTime
  12. LINQ to SQL multiple tables left outer join
  13. How to Bulk Update records in Entity Framework?
  14. Entity Framework. Delete all rows in table
  15. “The LINQ expression node type ‘Invoke’ is not supported in LINQ to Entities” – stumped!
  16. Entity-framework code is slow when using Include() many times
  17. LINQ, Unable to create a constant value of type XXX. Only primitive types or enumeration types are supported in this context
  18. The operation cannot be completed because the DbContext has been disposed using MVC 4
  19. Linq to Entity Join table with multiple OR conditions
  20. Export Model to DataTable
  21. ‘Date’ is not supported in LINQ to Entities. Only initializers, entity members, and entity navigation properties are supported
  22. Dynamic query with OR conditions in Entity Framework
  23. Simulating Cross Context Joins–LINQ/C#
  24. Only primitive types or enumeration types are supported in this context
  25. Max return value if empty query
  26. Check if list contains item from other list in EntityFramework
  27. How to do an “in” query in entity framework?
  28. Keep Getting ‘The LINQ expression node type ‘Invoke’ is not supported in LINQ to Entities’ Exception
  29. Should the order of LINQ query clauses affect Entity Framework performance?
  30. How to wrap Entity Framework to intercept the LINQ expression just before execution?

Leave a Comment