按多列分组 [英] Group By Multiple Columns
本文介绍了按多列分组的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
如何在LINQ中实现GroupBy多列
类似于SQL中的这个:
SELECT * FROM< TableName> GROUP BY< Column1>,< Column2>
如何将其转换为LINQ:
QuantityBreakdown
(
ProductID int,
ProductID int,
数量float
)
INSERT INTO @QuantityBreakdown(MaterialID,ProductID,Quantity)
SELECT MaterialID,ProductID,SUM(Quantity)
FROM @Transactions
GROUP BY MaterialID,ProductID
解决方案使用匿名类型。
group x by new {x.Column1,x.Column2}
How can I do GroupBy Multiple Columns in LINQ
Something similar to this in SQL:
SELECT * FROM <TableName> GROUP BY <Column1>,<Column2>
How can I convert this to LINQ:
QuantityBreakdown ( MaterialID int, ProductID int, Quantity float ) INSERT INTO @QuantityBreakdown (MaterialID, ProductID, Quantity) SELECT MaterialID, ProductID, SUM(Quantity) FROM @Transactions GROUP BY MaterialID, ProductID
解决方案Use an anonymous type.
Eg
group x by new { x.Column1, x.Column2 }
这篇关于按多列分组的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文