Yup, that worked like a charm Thanks a lot!dpratt71 said:
The most straightforward way I can think to do this involves stepping outside the "from...in" syntax a bit:
var myClubs =
from aClub in myDB.Club
where aClub.Users.Any(aUser => aUser.City == city)
This assumes that the navigation property from Club to User is named "Users" (if you haven't changed anything, it's probably "User").
I hope VS will be able to tell what is not supported in LINQ queries at some point. Or even better, may be the Entity Framework will be able to translate everything you can do in code