LINQ Group By Multiple fields -Syntax help

by

Use the same anonymous type in the dot notation that you do in the query expression:

var qry = cust.GroupBy(cm => new { cm.Customer, cm.OrderDate }, 
             (key, group) => new { Key1 = key.Customer, Key2 = key.OrderDate, 
                                   Count = group.Count() });

(In a real IDE I’d have (key, group) lined up under the cm parameter, but then it would wrap in SO.)

More Related Contents:

  1. Group by in LINQ
  2. Group By Multiple Columns
  3. LINQ with groupby and count
  4. C# Linq Group By on multiple columns [duplicate]
  5. LINQ Grouping dynamically
  6. Client side GroupBy is not supported
  7. LINQ: combining join and group by
  8. Linq order by, group by and order by each group?
  9. ILookup vs. IGrouping
  10. linq distinct or group by multiple properties
  11. Group by variable integer range using Linq
  12. LINQ to Entities group-by failure using .date
  13. Get All instead of FirstOrDefault
  14. Linq: GroupBy, Sum and Count
  15. Find an item in a list by LINQ
  16. LINQ Select Distinct with Anonymous Types
  17. LINQ Orderby Descending Query
  18. How to get the closest number from a List with LINQ?
  19. Enumerating Collections that are not inherently IEnumerable?
  20. Comparing 2 objects and retrieve a list of fields with different values
  21. C# Linq where clause as a variable
  22. Find if listA contains any elements not in listB
  23. Split an IEnumerable into fixed-sized chunks (return an IEnumerable where the inner sequences are of fixed length) [duplicate]
  24. Remove item from list based on condition
  25. Creating a LINQ select from multiple tables
  26. how do access previous item in list using linQ?
  27. How do I compose Linq Expressions? ie Func
  28. Is it possible to perform joins across different databases using LINQ?
  29. If Else in LINQ
  30. Parsing a string C# LINQ expression

Leave a Comment