Linq/EF/lambda Group by/Order by 多个字段详细用法

1)单个字段Group by:

//a.Key类型与a.Province字段类型一样 

  .GroupBy(a => a.Province).Select(a => a.Key).ToList(); 

2)多个字段Group by:

//此时返回的数据列表需要自己转换 

  .GroupBy(a => new { a.Date, a.Week }).Select(a => a.Key).ToList();

3)单个字段Order by:

.OrderBy(a => a.Date).ToList()

4)多个字段Order by:

.OrderBy(a => a.Date).ThenBy(a => a.EndTime).ThenBy(a => a.StartTime).ToList()

5)多个字段Order by倒序:

.OrderByDescending(a => a.Date).ThenByDescending(a => a.EndTime).ThenByDescending(a => a.StartTime).ToList()
posted @ 2016-12-06 10:03  jory  阅读(20407)  评论(0编辑  收藏  举报