Group By Multiple Columns

Question

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 

Answer 1

Use an anonymous type.

Eg

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

Answer 2

Procedural sample:

.GroupBy(x => new { x.Column1, x.Column2 })