using System.Linq;//引入命名空间
查询
var result = from l in list(查询的集合)
where l.property对比条件
select l;
排序
var result = from l in list
where 条件
orderby 排序的属性,属性,属性(字符串也可以排序) descending(降序)
select l;
联合查询
var result = from l1 in list1
from l2 in list2
where 条件
select new{l1,l2}
join on
var result = from l1 in list1
join l2 in list2 on l1.?? equals l2.?? 连接条件
where 条件
select new{l1,l2}