Seems this is an issue that multiple people have asked around at several occasions.<\/p>\n
The question is how to use a Linq query where you want to group on more than one ‘field’<\/p>\n
Turns out it is really not that hard. Thanks to ‘Anonymous’ methods that was also introduced ‘yay back’ it is as simple as the following example. Lets say you have a list of values like these:<\/p>\n
Person 1: Age = 25, Gender = M, HighScore = 123
\nPerson 2: Age = 21, Gender = F, HighScore = 99
\nPerson 3: Age = 27, Gender = M, HighScore = 140
\nPerson 4: Age = 19, Gender = M, HighScore = 131
\nPerson 5: Age = 25, Gender = M, HighScore = 119
\nPerson 6: Age = 22, Gender = M, HighScore = 108
\nPerson 7: Age = 27, Gender = M, HighScore = 152
\nPerson 8: Age = 21, Gender = M, HighScore = 98
\nPerson 9: Age = 22, Gender = M, HighScore = 101
\nPerson 10: Age = 25, Gender = M, HighScore = 167
\nPerson 11: Age = 22, Gender = F, HighScore = 105
\n… etc<\/p><\/blockquote>\nTo get a simple report on average high score by Age and Gender you’ll have to use a query like this:<\/p>\n
foreach<\/span>(var<\/span> entry in<\/span> (from<\/span> p in<\/span> Persons
\ngroup<\/span> p by new<\/span> { \u00a0Age = p.Age, Gender = p.Gender }<\/strong> into<\/span> g
\norderby<\/span> g.Key.Age, g.Key.Gender
\nselect new<\/span>
\n{
\nAge = g.Key.Age,
\nGender = g.Key.Gender,
\nAvg = g.Average(pavg=>p.HighScore)
\n} ))<\/p>\n{<\/p>\n
Console<\/span>.WriteLine(“Age: {0}, Gender: {1}, Avg: {2}”, entry.Age, entry.Gender, entry.Avg);<\/p>\n
}<\/p><\/blockquote>\n
Perhaps it might have simpler if you could simply have stated : “group p by p.Age, p.Gender” but unfortunately this is not supported. Then again this allows you to be more creative in defining the anonymous type so you can manipulate the data even more. Perhaps in the next version of Linq… if there is ever one…<\/p>\n
<\/p>\n","protected":false},"excerpt":{"rendered":"
Seems this is an issue that multiple people have asked around at several occasions. The question is how to use a Linq query where you want to group on more than one ‘field’ Turns out it is really not that …<\/p>\n