Linq Getting Customers group by date and then by their type

by 
var query = _customerRepo.Table
     .GroupBy(c => new {Date = c.Date.Date,  Type = c.TypeOfCustomer})
     .Select(g => new 
                   {
                       Date = g.Key.Date,
                       Type = g.Key.Type, 
                       Count = g.Count
                   }
            )
     .OrderByDescending (r = r.Date);

More Related Contents:

  1. How to write this nested foreach loop query in LINQ?
  2. Group by in LINQ
  3. Reading a file line by line in C#
  4. ToList()– does it create a new list?
  5. Combination of List
  6. The ‘:’ character, hexadecimal value 0x3A, cannot be included in a name
  7. How to use the IEqualityComparer
  8. Check if two lists are equal
  9. ASP.NET MVC 3: Override “name” attribute with TextBoxFor
  10. LINQ aggregate and group by periods of time
  11. Cannot use a lambda expression as an argument to a dynamically dispatched operation without first casting it to a delegate or expression tree type
  12. How set value a property selector Expression
  13. LINQ: Using INNER JOIN, Group and SUM
  14. linq distinct or group by multiple properties
  15. Filtering include items in LINQ and Entity Framework [duplicate]
  16. How to get duplicate items from a list using LINQ? [duplicate]
  17. Max or Default?
  18. How to check for nulls in a deep lambda expression? [duplicate]
  19. What does LINQ return when the results are empty
  20. How to declare a local variable in Razor?
  21. LINQ performance FAQ
  22. Better way to get active page link in MVC 3 Razor
  23. How to implement left join in JOIN Extension method
  24. How do I get the Controller and Action names from the Referrer Uri?
  25. Sorting a List
  26. linq: order by random
  27. Uploading image in ASP.NET MVC
  28. The ObjectContext instance has been disposed and can no longer be used for operations that require a connection [duplicate]
  29. Select distinct rows from datatable in Linq
  30. MVC Form Validation on Multiple Fields

Leave a Comment