Adding more items to a group by statement

Question

I have this query:

 var rowsPerProvider = (from row in dt.Select() let emp = row["f_name"].ToString().Trim() group row by emp into g select g).ToDictionary( g => g.Key, g => g.ToArray());

How can I update it to also filter on some more columns? for example currently it is on f_name. How can I update it to group on f_name and m_name and l_name?

demoncodemonkey · Accepted Answer · 2014-07-22 21:50:55Z

3

Make an anonymous object containing the fields you want to group by:

var rowsPerProvider = (from row in dt.Select() group row by new { emp1 = row["f_name"].ToString().Trim(), emp2 = row["m_name"].ToString().Trim(), emp3 = row["l_name"].ToString().Trim(), } into g select g).ToDictionary( g => g.Key, g => g.ToArray());

answered Jul 22, 2014 at 21:50

demoncodemonkey

12k10 gold badges64 silver badges105 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

CutHimSomeSlack Over a year ago

thanks, so when we do grouping this way, it ensures that all of them for each key of this dictionary have the same first name, middle name and last name. right?

DaveShaw Over a year ago

@CutHimSomeSlack - yes, the anonymous type has an Equals and GetHashCode that check all the properties are the same - see this answer: stackoverflow.com/a/12123542/383710

MarcinJuraszek · Accepted Answer · 2014-07-22 21:50:53Z

3

Use anonymous class:

// (...) group row by new { emp, something }

answered Jul 22, 2014 at 21:50

MarcinJuraszek

126k15 gold badges200 silver badges267 bronze badges

Collectives™ on Stack Overflow

Adding more items to a group by statement

2 Answers 2

2 Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Linked

Related