Jader Dias
Reputation: 90465
How do you group by multiple columns in LINQ TO SQL?
How do you group by multiple columns in LINQ TO SQL?
db.Table.GroupBy(a => a.column1.ToString() + a.column2.ToString())
It seems ugly and with poor performance, and I don't even know if it works. Which is the right way to do it?
Upvotes: 13
Views: 7561
Answers (1)
David Hedlund
Reputation: 129782
try grouping by an anonymous type:
group by new { item.Col1, item.Col2 }
you'll then be able to access Key.Col1, etc
Upvotes: 16
Related Questions
- LINQ 2 SQL Group by multiple custom columns
- Multiple column group by on Linq
- Linq Group BY Multiple Values
- Group By multiple columns in Linq statement
- SQL to Linq select multiple columns in group by
- Linq To SQL equivalent group by with multiple table columns in the output
- LINQ-to-SQL - Group By
- Group By Multiple Columns - LINQ
- SQL to LINQ group by
- SQL Group By column value in LINQ