Linq分组后,再对分组后的每组数据进行排序,获取每组的第一条记录
时间:2021-09-02 14:30:13
收藏:0
阅读:13
Linq分组后,再对分组后的每组数据进行排序,获取每组的第一条记录
Linq to SQL
var result = from transRecord in TransRecord group transRecord by transRecord.TransType into g select g.OrderByDescending(o=>o.Date) .FirstOrDefault();
Linq to Entity
var result = _dbContext .TransRecord .GroupBy(g => g.TransType) .Select(s => s.OrderByDescending(o => o.Date) .FirstOrDefault());
原文:https://www.cnblogs.com/anjou/p/15217524.html
评论(0)