Hi, I am doing a Linq to SQL join var something = (from TB1in db.Table1 join TB2 in db.Table2 on new { TB1.criteria1, TB1.criteria2, TB1.criteri3 } equals new { TB2.criteria1, TB2.criteria2, TB2.criteri3 } select TB1); The syntax looks fine to me, but it alwasy give me an error : The type of one of the expressions in the join clause is incorrect. Type inference failed in the call to 'Join'. If I remove any 2 fields in the join, then it is going to work.. Can anyone help ?
Read More...