convert sql query to lambda expression

Question

How to convert the following sql query to lambda expression?

SELECT Username, COUNT(Username) AS Count 
FROM user 
GROUP BY Username

try this: var grpUsers = empList.GroupBy(user => user.Username) .Select(lst => new {Username = lst.Key, Count = lst.Count()} ); — SHEKHAR SHETE
– SHEKHAR SHETE, Commented Jun 13, 2014 at 4:37

MarmiK · Accepted Answer · 2014-06-13 05:06:42Z

0

 var UserCount = yourEntityObject.GroupBy(m => m.Username)
                       .Select(c => new {Username = c.Key, Count = c.Count()});

MarmiK

5,8156 gold badges47 silver badges51 bronze badges

answered Jun 13, 2014 at 4:49

Arijit Mukherjee

3,8952 gold badges36 silver badges53 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

SHEKHAR SHETE · Accepted Answer · 2014-06-13 05:10:28Z

0

Try the following:

var grpUsers = empList.GroupBy(user => user.Username)
                         .Select(lst => new {Username = lst.Key, Count = lst.Count()} );

answered Jun 13, 2014 at 5:10

SHEKHAR SHETE

6,08415 gold badges89 silver badges144 bronze badges