常用Lambda

//升序
list.OrderBy(s=>s.name).ToList();
//降序
list.OrderByDescending(s=>s.name).ToList();
//去重 两个集合去掉相同的数据
list1.Where(i=>!list2.Where(o=>o.name.Trim().Contains(i.name.Trim())).Any()).ToList();
//取重 两个集合取出相同的数据
list1.Where(i=>list2.Where(o=>o.name.Trim().Contains(i.name.Trim())).Any()).ToList();
//分组
list.GroupBy(s=>s.order).Count();
list.GroupBy(s=>s.order).ToList();
//for
list.ForEach(p=>p.line_name=p.building+"-"+p.line);
//按照某个条件查询select where
list.Where(s=>s.Number>=1).Select(s=>s.Name).First().ToString();
list.Where(m => m.state== true).OrderBy(m => m.name).ToList();
//最后一个值
list.Select(s => s.SerialNumber).Last().ToString();
//获取第一个值
list.Select(s => s.SerialNumber).First().ToString();
//Sum
list.Sum(p => p.Number);
//Min
list.Sum(p => p.Number);
//Count
list.Count();
//Average
list.Average(p => p.Number);
//Top 降序
list.Take(10).OrderByDescending(p => p.Number);