CODEWITHSUNDEEP
linq
shinra tensei
shinra tensei

Reputation: 713

linq joint type inference failed to call 'join' error

i have 3 tables User, TeamMember and Assessment all three have the user_id column, User is linked to TeamMember by userid and TeamMember and Assessment are linked with user_id(TeamMember) & rater,rated(Assessment)

Im trying to join in with this

          from a in db.Assessments
                         join u in db.Team_Members on a.rated equals u.user_id
                         join u2 in db.Team_Members on a.rater equals u2.user_id

It's throwing this error

The type of one of the expressions in the join clause is incorrect. Type inference failed in the call to 'Join'.

Any idea what going on?

Upvotes: 1

Views: 3634

Answers (1)

Aducci
Aducci

Reputation: 26694

You need to make sure a.rated / u.user_id and a.rater / u2.user_id are the same type

Upvotes: 4

Related Questions