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

1 vote192 views1 answer
Check valid binary search tree
C#
2 votes258 views1 answer
Ef Select 2 or more items from DB
C#
0 vote178 views1 answer
Start wpf application when windows start
C#
1 vote200 views1 answer
String in int c#
C#
0 vote176 views1 answer
Orderby make sunday last day c#
C#
0 vote203 views1 answer
Unity 2d swap out background image
C#
0 vote242 views1 answer
How to get point of collision in unity
C#Unity
0 vote234 views1 answer
Mouse click unity raycast unity
C#Unity
0 vote193 views1 answer
Print the top view of the binary tree
C#
0 vote343 views1 answer
How to get the position of a camera in unity
C#Unity