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

Question

I'm trying to get data from a LocalDb into my MVC Controller. I tried this:

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

It returns this error:

A specified Include path is not valid. The EntityType 'ChatProj.Models.UserProfile' does not declare a navigation property with the name 'LastName'.

Here is a picture of my localDb and model.

Any idea why it's not working?

I would rather suggest you go through this post https://stackoverflow.com/questions/3356541/entity-framework-linq-query-include-multiple-children-entities — MSI Abu Zafar Newton, Jan 07 '19 at 11:42

Sergey Berezovskiy · Accepted Answer · 2013-12-17T15:21:39.407

48

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

edited Dec 17 '13 at 15:21

answered Dec 17 '13 at 15:15

Sergey Berezovskiy

232,247
41
429
459

1

Cheers m8, great answer! – JazzMaster Dec 17 '13 at 15:24
2

@JazzMaster welcome :) consider also reading about [Navigation Properties](http://msdn.microsoft.com/en-us/data/jj713564.aspx) – Sergey Berezovskiy Dec 17 '13 at 15:26
@SergeyBerezovskiy, would you mind taking a look at my question? https://stackoverflow.com/questions/28988951/export-to-excel-linq-include-foreignkey-values-in-tolist – Analytic Lunatic Mar 11 '15 at 15:58
1

so there is no way to avoid always loading all properties in UserProfiles? – Toolkit Jul 11 '18 at 05:48
The most common mistake I see people, including myself, make, is Including an enum property. Or, refactoring an entity to just be an enum, and then this silently blows up in your face. – John Zabroski Aug 18 '21 at 22:08

score 25 · Answer 2 · answered Dec 17 '13 at 15:16

25

Include is only for navigation properties, and LastName is a scalar property, so you don't need Include at all.

answered Dec 17 '13 at 15:16

Thomas Levesque

286,951
70
623
758

1

Couldn't've said it better, myself. Very succinct. – vapcguy Jan 07 '15 at 23:57
I didn't know where an error I had came from, untill I saw your answer. Said enough. +1 – Max May 28 '18 at 08:09

Serj Sagan · Answer 3 · 2019-08-28T08:35:35.757

Even though this is not quite related to the question, since Google brings you here, I thought it might be helpful to notice that a likely possibility is that you are using IEnumerable for your collection. Instead you should be using ICollection, see more here: https://stackoverflow.com/a/32997694/550975

This seems to be a problem in EF6 and perhaps earlier versions only... no longer a problem to use either in EF Core.

score 8 · Answer 4 · answered Dec 17 '13 at 15:16

If you want to retrieve only the LastName, use

Select(m => m.LastName)

so

 var users = db.UserProfiles
                .Where(u => u.UserId == WebSecurity.CurrentUserId)
                .Select(u => u.LastName)//not Include
                .ToList();

LastName is just a string (Scalar property) in your model, not a Navigation property (relation with another entity)

score -2 · Answer 5 · answered Dec 23 '21 at 07:45

-2

In my case I solved it as the following

the code with the error :

LabResults = db.LAB_RESULTS.Where(o => o.ORDER_ID == id)
.Include(p => p.LabTests).ToList()

then I removed .Include :

LabResults = db.LAB_RESULTS.Where(o => o.ORDER_ID == id).ToList()

answered Dec 23 '21 at 07:45

Ziad Adnan

710
5
18

This solution is not directly relevant to question and doesn't solve it either. :) – Babajide M. Moibi Nov 13 '22 at 23:51

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

5 Answers5

Linked

Related