LINQ to SQL: Multiple joins ON multiple Columns. Is this possible?
Joining on multiple columns in Linq to SQL is a little different. var query = from t1 in myTABLE1List // List<TABLE_1> join t2 in myTABLE1List on new { t1.ColumnA, t1.ColumnB } equals new { t2.ColumnA, t2.ColumnB } … You have to take advantage of anonymous types and compose a type for the multiple columns you … Read more