Only primitive types or enumeration types are supported in this context

by

My guess is that error indicates that EF cannot translate the equality operator for Employee to SQL (regardless of whether you’re assuming referential equality or an overridden == operator). Assuming the Employee class has a unique identifier try:

var query = from a in db.Activities
            where a.AssignedEmployeeId == currentUser.Id
            where a.IsComplete == false
            orderby a.DueDate
            select a;
return View(query.ToList());

More Related Contents:

  1. Filter/Search using Multiple Fields – ASP.NET MVC
  2. How to group by on 2 child entities and get total of both this child entities?
  3. LINQ to Entities does not recognize the method ‘System.Web.Mvc.FileResult’
  4. The operation cannot be completed because the DbContext has been disposed using MVC 4
  5. Export Model to DataTable
  6. Linq: help me to make this work
  7. How do I apply OrderBy on an IQueryable using a string column name within a generic extension method?
  8. Writing Recursive CTE using Entity Framework Fluent syntax or Inline syntax
  9. The type of one of the expressions in the join clause is incorrect in Entity Framework
  10. Validation failed for one or more entities while saving changes to SQL Server Database using Entity Framework
  11. LEFT JOIN in LINQ to entities?
  12. Linq to EntityFramework DateTime
  13. LINQ to SQL multiple tables left outer join
  14. Entity Framework (.NET Full Framework) Ordering Includes [duplicate]
  15. How to compare only date components from DateTime in EF?
  16. How to Bulk Update records in Entity Framework?
  17. Entity Framework 6 Code First Custom Functions
  18. “The LINQ expression node type ‘Invoke’ is not supported in LINQ to Entities” – stumped!
  19. Order by dynamic parameter
  20. When should I create a new DbContext()
  21. Linq Syntax – Selecting multiple columns
  22. C# Entity-Framework: How can I combine a .Find and .Include on a Model Object?
  23. Log Queries executed by Entity Framework DbContext
  24. Max return value if empty query
  25. Where can I find the System.Linq.Dynamic dll?
  26. How to wrap Entity Framework to intercept the LINQ expression just before execution?
  27. Repository Pattern, POCO, and Business Entities
  28. MVC 4 – Many-to-Many relation and checkboxes
  29. .NET Managing Layers Relationships
  30. Entity Framework Many to many through containing object

Leave a Comment