This is my first post on channel9 so let me start by saying "Hi!" I hope the holiday season has been treating you all well.
Now, onto the problem I have been having with LINQ...
I am new to LINQ and I have been trying to do something pretty simple with a DB I am playing around with: There are 3 tables, User, UserToClub, and Club. UserToClub maps clubs to a given user and has the user's ID and the club's ID as FKs. When I generated
EDMX for this DB I got two Entities - User and Club. I just want to filter clubs based on a given list of users, in this case based on a given city. The code compiles fine but I get a runtime error when I try to call Count on myClubs which I guess is when
the statement gets actually evaluated. The error is:
LINQ to Entities does not recognize the method 'Boolean Contains(Club)' method, and this method cannot be translated into a store expression. (System.NotSupportedException)
Any help would be appreciated. The code follows:
//Pick user with the right ID var myUser = from aUser in myDB.User where aUser.City.Equals(city) select aUser;
//Filter clubs based on user ID var myClubs = from aUser in myUser from aClub in myDB.Club where aUser.Club.Contains(aClub) select aClub;
It seems pretty straightforward to me but I guess I am missing something (yeah, "Doh!", I know...).