I have simple list, consisting of 2 columns - Date, Order. Now what I want to do, is to GroupBy Date and count orders. So, for example if I have following items
Date Order 08/10/2012 5 08/13/2012 1 08/13/2012 2
I need to get following results
Date OrderCount 08/10/2012 5 08/13/2012 3
As far as I know, I can use CAML query and use GroupBy, but I can't seem to find how to use aggregate function Count ( like in sql ). I know I can read all items from list, and then use linq to objects, but it's the last option I'd like to consider. Any ideas how can I do this ?