How do I use group by in LINQ?

Question

How do I use group by in LINQ? I want to group by tow filed of table in C# by linq.

possible duplicate question http://stackoverflow.com/questions/1869001/linq-group-by-multiple-fields-syntax-help — pmtamal, Apr 23 '12 at 10:02

score 1 · Accepted Answer · answered Apr 23 '12 at 10:00

1

var query =
    from t in db.tableName    
    group t by new { t.column1, t.column2 } into g
    select new { g.Key.column1, g.Key.column2 };

answered Apr 23 '12 at 10:00

sarwar026

1 Answers1