GroupBy with linq method syntax (not query syntax)

Dane O'Connor picture Dane O'Connor · Jun 8, 2009 · Viewed 20k times · Source

How would the following query look if I was using the extension method syntax?

var query = from c in checks
group c by string.Format("{0} - {1}", c.CustomerId, c.CustomerName) 
into customerGroups
select new { Customer = customerGroups.Key, Payments = customerGroups }

Answer

mqp picture mqp · Jun 8, 2009

It would look like this:

var query = checks
    .GroupBy(c => string.Format("{0} - {1}", c.CustomerId, c.CustomerName))
    .Select (g => new { Customer = g.Key, Payments = g });