Search code examples
c#linqtranslationlinq-query-syntax

GroupBy with linq method syntax (not query syntax)


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 }

Solution

  • 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 });