c# - 按多列分组(Group By Multiple Columns)

Question

How can I do GroupBy Multiple Columns in LINQ

(如何在LINQ中对多个列进行分组)

Something similar to this in SQL:

(在SQL中与此类似：)

SELECT * FROM <TableName> GROUP BY <Column1>,<Column2>

How can I convert this to LINQ:

(如何将其转换为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

  ask by Sreedhar translate from so

Answer 1

Use an anonymous type.

(使用匿名类型。)

Eg

(例如)

group x by new { x.Column1, x.Column2 }