Geeks With Blogs
Guilherme Cardoso, Blog EN .NET geek

The following example group an list by year, month. It counts how much records the groups has and sums some values from the group (in this case is money).

var orders = from ord in Lista
                                 group enc by new
                                                  {

                                                      ord.DateOfPayment.Value.Year,
                                                      ord.DateOfPayment.Value.Month
                                                  }
                                 into g
                                 select new
                                            {
                                                Month = g.Select(n => n.DateOfPayment.Value.Month).First(),
                                                TotalAmount = g.Sum(n => (Decimal) n.TotalAmount),
                                                CountOrders = g.Count()
                                            };

 

Posted on Friday, July 16, 2010 2:57 AM | Back to top


Comments on this post: LINQ - Group By Month, Sum some value and count

# re: LINQ - Group By Month, Sum some value and count
Requesting Gravatar...
Thanks very much, this is what I was looking for.
Left by Brent on Nov 30, 2011 3:09 AM

# re: LINQ - Group By Month, Sum some value and count
Requesting Gravatar...
Thank you. You saved my day!!!!
Cheers
Left by Suranga on Jan 19, 2015 12:06 PM

Your comment:
 (will show your gravatar)


Copyright © Guilherme Cardoso | Powered by: GeeksWithBlogs.net | Join free