SQL 到实体框架计数 Group-By [英] SQL to Entity Framework Count Group-By

问题描述

我需要将此SQL 语句转换为Linq-Entity 查询...

I need to translate this SQL statement to a Linq-Entity query...

SELECT name, count(name) FROM people
GROUP by name

推荐答案

查询语法

var query = from p in context.People
            group p by p.name into g
            select new
            {
              name = g.Key,
              count = g.Count()
            };

方法语法

var query = context.People
                   .GroupBy(p => p.name)
                   .Select(g => new { name = g.Key, count = g.Count() });

这篇关于SQL 到实体框架计数 Group-By的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！