http://www.ideablade.com/forum/ This is an XML content feed of; DevForce Community Forum : DevForce 2012 : GroupBy with Sum Sat, 11 Apr 2026 01:09:16 -700 Mon, 03 Dec 2012 06:48:27 -700 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 9.69 360 www.ideablade.com/forum/RSS_post_feed.asp?TID=3831 http://www.ideablade.com/forum/forum_images/IdeaBlade_logo_tm.png http://www.ideablade.com/forum/ http://www.ideablade.com/forum/forum_posts.asp?TID=3831&PID=15321#15321 Author: sbelini
Subject: 3831
Posted: 03-Dec-2012 at 6:48am

Hi Greg.

Thanks for the update.

sbelini]]> Mon, 03 Dec 2012 06:48:27 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=3831&PID=15321#15321 http://www.ideablade.com/forum/forum_posts.asp?TID=3831&PID=15318#15318 Author: gregweb
Subject: 3831
Posted: 02-Dec-2012 at 6:40am

I found a good example here

Edited by gregweb - 02-Dec-2012 at 6:43am]]> Sun, 02 Dec 2012 06:40:52 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=3831&PID=15318#15318 http://www.ideablade.com/forum/forum_posts.asp?TID=3831&PID=15317#15317 Author: gregweb
Subject: 3831
Posted: 01-Dec-2012 at 7:12pm


I am trying to do a report that groups orders by date and sums them.

In SQL I would write: Select Sum(Orders.Amount) from Orders Group By Orders.Date

The sum works OK, but I don't see how to do the group by.

var op = this.EntityManager.Orders.AsScalarAsync().Sum(a=> a.Amount).GroupBy(a=> a.Date);

Greg]]> Sat, 01 Dec 2012 19:12:06 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=3831&PID=15317#15317