A specified Include path is not valid. The EntityType does not declare a navigation property with the name *

by

Navigation property should be of entity type of collection of related entities. Including some navigation property means joining your current entity with some related entity or entities. That allows eager loading of data from several tables in single query. LastName is not a navigation property – it is simple field, and it will be loaded by default, you don’t need to include it:

UsersContext db = new UsersContext();
var users = db.UserProfiles.Where(u => u.UserId == WebSecurity.CurrentUserId)
                           .ToList();

This query will be translated into something like

SELECT UserId, UserName, LastName, FirstName 
FROM UserProfiles
WHERE UserId = @value

More Related Contents:

  1. ‘Contains()’ workaround using Linq to Entities?
  2. How to use a string to create a EF order by expression?
  3. Writing Recursive CTE using Entity Framework Fluent syntax or Inline syntax
  4. The type of one of the expressions in the join clause is incorrect in Entity Framework
  5. LEFT JOIN in LINQ to entities?
  6. Linq to EntityFramework DateTime
  7. LINQ to SQL multiple tables left outer join
  8. Entity Framework (.NET Full Framework) Ordering Includes [duplicate]
  9. How to compare only date components from DateTime in EF?
  10. How to Bulk Update records in Entity Framework?
  11. Entity Framework 6 Code First Custom Functions
  12. Entity Framework. Delete all rows in table
  13. “The LINQ expression node type ‘Invoke’ is not supported in LINQ to Entities” – stumped!
  14. LINQ to Entities does not recognize the method ‘System.Web.Mvc.FileResult’
  15. Order by dynamic parameter
  16. LINQ, Unable to create a constant value of type XXX. Only primitive types or enumeration types are supported in this context
  17. Dynamic table name in linq [duplicate]
  18. Linq Syntax – Selecting multiple columns
  19. Join and Include in Entity Framework
  20. Linq to Entity Join table with multiple OR conditions
  21. Creating dynamic queries with entity framework
  22. ‘Date’ is not supported in LINQ to Entities. Only initializers, entity members, and entity navigation properties are supported
  23. Log Queries executed by Entity Framework DbContext
  24. Remove item from list based on condition
  25. How to group by DateTime.Date in EntityFramework
  26. Linq Query keeps throwing “Unable to create a constant value of type System.Object….”, Why?
  27. The LINQ expression node type ‘ArrayIndex’ is not supported in LINQ to Entities
  28. How to include() nested child entity in linq
  29. LINQ Query to Convert string to datetime
  30. Entity Framework select one of each group by date

Leave a Comment