Clever Geek Handbook

Linq to Entities simple group query

How do I write a (simple) LINQ to Entities query that groups elements by some attributes and counts them?

SELECT answernumber, count(answerID) FROM answers
WHERE questionID = id
GROUB BY answernumber
ORDERBY answernumber;

It should be easy, but I don't know how to write it.

+2


source to share


1 answer 


var query = answers
   .GroupBy(a => a.answernumber, a => a, (k, g) => new {answernumber = k, Count = g.Count()})
   .OrderyBy(i => i.answernumber);

Or in another way:



var query2 = from a in answers
         group a by a. answernumber into g
         orderby g.Key
         select new { answernumber = g.Key, Count = g.Count() };
+4


source






More articles:


All Articles