一句简单的linq group by 语句

最新推荐文章于 2022-06-21 08:19:11 发布

baimanmu3398

最新推荐文章于 2022-06-21 08:19:11 发布

阅读量133

点赞数

原文链接：http://www.cnblogs.com/KQNLL/p/10117088.html

版权

拼接筛选条件

 // 拼接条件
            Expression<Func<ProductLangDailySummaryDetail, bool>> whereCondition = p => 1 == 1;
            if (dateTimeStart != null) whereCondition = whereCondition.And(m => m.SummaryDate >= dateTimeStart);
            if (dateTimeEnd != null) whereCondition = whereCondition.And(m => m.SummaryDate <= dateTimeEnd);

通过ProductType和Language分组，得到分组后的对象列表　　　　　　


            var ProductLangDailySummaryDetailGroup = _productLangDailySummaryDetailRepository.Query().Where(whereCondition).GroupBy(x => new
            {
                x.ProductType,
                x.Language
            }).Select(m => new { ProductType = m.Key.ProductType, Language = m.Key.Language, Count = m.Count() }).ToList();

转载于:https://www.cnblogs.com/KQNLL/p/10117088.html