Group by linq multiple columns C#

var query = (from t in Transactions
             group t by new {t.MaterialID, t.ProductID}
             into grp
                    select new
                    {
                        grp.Key.MaterialID,
                        grp.Key.ProductID,
                        Quantity = grp.Sum(t => t.Quantity)
                    }).ToList();

Source: stackoverflow.com

Linq group by multiple

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

Source: stackoverflow.com

Similar codes

0 vote113 views2 answers
Edit database from datagridview with right click on data c#
C#
0 vote117 views2 answers
How to show a first item in a combobox in c# winforms
C#
0 vote116 views1 answer
Reverse Coding Challenge 1
C#
0 vote122 views2 answers
Winforms reportviewer.print report
C#
3 votes112 views6 answers
While loop in c#
C#
2 votes124 views2 answers
C# datagridview hide row selector
C#
26 votes121 views1 answer
C# date formats custom
C#
0 vote126 views1 answer
C# is string nullable
C#
0 vote112 views1 answer
Resharper render pages folder asp.net core
C#
0 vote110 views1 answer
Query Parent-GrandChild collection
C#