EF CORE Group by 及Sum的使用例子

code:9527

已于 2023-04-04 17:12:46 修改

阅读量927

点赞数 1

文章标签： c# asp.net

于 2023-03-14 15:18:31 首次发布

本文链接：https://blog.csdn.net/Jacob946/article/details/129528856

版权

该文章展示了如何在EFCore数据库上下文中，通过LINQ查询对myUserModel实体进行过滤，然后使用GroupBy按UserKind分组，并利用Sum函数计算不同用户类型的数量。主要计算了ErpUserNum、SaleUserNum和FeiYongUserNum这三个指标。

摘要由CSDN通过智能技术生成

EF CORE Group by 及Sum的使用例子

- 例子

例子

 var headerTask = _coreDbContext.Set<myUserModel>().Where(u => u.IsDisabeld == 0).Select(c => new
            {
                c.UserKind,
                c.UserCode
                //其它属性
            }).GroupBy(c => c.UserKind, (k, g) => new
            {
                ErpUserNum = g.Sum(a => a.UserKind == 1 ? 1 : 0),
                SaleUserNum = g.Sum(a => (a.UserKind == 2 || a.UserKind == 6 || a.UserKind == 18 || a.UserKind == 22) ? 1 : 0),
                FeiYongUserNum = g.Sum(a => (a.UserKind == 4 || a.UserKind == 6 || a.UserKind == 18 || a.UserKind == 22) ? 1 : 0)
            }).ToList();

            var ErpUserNum = _coreDbContext.Set<myUserModel>().Where(t => t.IsDisabeld == 0).Sum((a => a.UserKind == 1 ? 1 : 0)).ToString() ;
            var SaleUserNum = _coreDbContext.Set<myUserModel>().Where(t => t.IsDisabeld == 0).Sum((a => (a.UserKind == 2 || a.UserKind == 6 || a.UserKind == 18 || a.UserKind == 22) ? 1 : 0)).ToString();
            var FeiYongUserNum = _coreDbContext.Set<myUserModel>().Where(t => t.IsDisabeld == 0).Sum((a => (a.UserKind == 4 || a.UserKind == 6 || a.UserKind == 18 || a.UserKind == 22) ? 1 : 0)).ToString();