1.基本语法:
涉及到的常用关键字:from , in , join , on , where , equals ....
例子:
Table1 table1 = new Table1();//t1 中存在int类型字段i , 时间字段 date
Table2 table2 = new Table2();
//存在相同字段field1
//查找 table1 与 table2 中存在field1的相同的数据,且t1.i > 0 并且按时间的倒序排列
var vv = from t1 in table1
join t2 in table2
on t1.field1 equals t2.field1
selet t1
where t1.i > 0
OrderByDescending(t1=>t1.date) ;