linq join两个表连接的多个条件使用

1.SQL语句格式：select * from table1 a join table2 b on a.id=b.id and a.name=b.name

2.换成linq:

from a in table1 join b in table2 on new{a.id,a.name} equals new{b.id,b.name}

或

from a in table1

from b in table2

where a.id==b.id&&a.name==b.name