SQL to Entity Framework Count Group-By

by

Query syntax

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

Method syntax

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

More Related Contents:

  1. How to use count and group by at the same select statement
  2. Entity Framework VS LINQ to SQL VS ADO.NET with stored procedures? [closed]
  3. SQL query for finding records where count > 1
  4. Conditional SQL count
  5. Select first row in each GROUP BY group?
  6. Reason for Column is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause [duplicate]
  7. How to concatenate strings of a string field in a PostgreSQL ‘group by’ query?
  8. GROUP BY with MAX(DATE) [duplicate]
  9. SQL – using alias in Group By
  10. Group by minimum value in one field while selecting distinct rows
  11. must appear in the GROUP BY clause or be used in an aggregate function
  12. How to group time by hour or by 10 minutes
  13. How to Create a real one-to-one relationship in SQL Server
  14. Query with LEFT JOIN not returning rows for count of 0
  15. JOIN two SELECT statement results
  16. Conditional Count on a field
  17. GROUP BY + CASE statement
  18. SQL Group by & Max
  19. Compute percents from SUM() in the same SELECT sql query
  20. Fastest way to determine if record exists
  21. Is it possible to run native sql with entity framework?
  22. SQL count(*) performance
  23. PostgreSQL Where count condition
  24. Calling a SQL User-defined function in a LINQ query
  25. The object ‘DF__*’ is dependent on column ‘*’ – Changing int to double
  26. How to return a incremental group number per group in SQL
  27. SQL query to group by day
  28. Doesn’t Linq to SQL miss the point? Aren’t ORM-mappers (SubSonic, etc.) sub-optimal solutions?
  29. Why doesn’t Oracle SQL allow us to use column aliases in GROUP BY clauses?
  30. Entity Framework Skip/Take is very slow when number to skip is big

Leave a Comment