LINQ Group by SUM
问题描述：
给出以下查询
Dim Query = From c In DB.Crt _
Where c.Member.Locked = False _
And c.Member.Verified = True _
And c.Ct > 0 _
Order By c.Ct Ascending _
Select New With {.MemberID = c.MemberID, _
.Ct = c.Ct}
我如何通过 c.ct ？
类似于 SUM OF（c.Ct）> 0
答
试试这个：
Try this:
Dim Query =
From c In DB.Crt _
Where c.Member.Locked = False _
And c.Member.Verified = True _
And c.Ct > 0 _
Order By c.Ct Ascending _
Group c.Ct By Key = c.MemberID Into Cts = Group _
Select New With { .MemberID = Key, .Ct = Cts.Sum() }