Today I wanted to do a group-by query with LINQ which is something I did before. It turned out to be kind of easy. If you just want to group by a single field. (from s in db.CrewStatsSet where s.LogDate >= date1 && s.LogDate <= date2 && s.Action == action group s by s.User.nick into