Group in LINQ
I keep forgeting how to group by in LINQ and it’s something I do regularly. So here is my cheat sheet. Here is the original T-SQL. SELECT orgno, psno, sche, projid, RecType, Sum(OBBudExpAmt) AS OBBudExpAmt, Sum(ABBudEncAmt) AS ABBudEncAmt From tbl908_BudSPDGrps Where orgno = ’210′ GROUP BY orgno, psno, sche, projid, RecType And this is the [...]