将SQL查询转换为lambda表达式 [英] convert sql query to lambda expression

问题描述

如何将以下sql查询转换为lambda表达式?

How to convert the following sql query to lambda expression?

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

推荐答案

尝试以下操作:

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

这篇关于将SQL查询转换为lambda表达式的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！