Convert Sql Query To Lambda Expression

How to convert the following sql query to lambda expression? SELECT Username, COUNT(Username) AS Count FROM user GROUP BY Username

Solution 1:

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

Solution 2:

Try the following:

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