c# - 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

Answer 1

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