我正在用SQL Server数据库学习Linq,遇到了ASP.Net操作查询的问题。有人能帮我把这个SQL查询转换成Linq吗?
SELECT ShipName, COUNT(*) AS ShipValues
FROM Invoinces GROUP BY ShipName HAVING COUNT(*) > 30发布于 2019-05-30 12:58:53
尝尝这个
var result = Invoinces.GroupBy(x => x.ShipName)
.Where(y => y.Count() > 30)
.Select(o => new {ShipName = o.ShipName, Count = o.Count()});https://stackoverflow.com/questions/56371810
复制相似问题