This project is read-only.

Aggregation Function

Jan 2, 2008 at 3:49 AM
Hi,

Is there any plan that you will include aggregation functions on this? (max, min, etc)
(I don't know if any CAML translation is available for those though).

thanks'

Jan 3, 2008 at 7:08 AM
Hi,

just a direct workaround (not necessarily related to your project though).
I just created a more direct approach to listitems via an extender class, who knows it might help.
herehttp://asadewa.wordpress.com/2008/01/03/direct-linq-to-splistitemcollection/
Feb 7, 2008 at 8:01 AM
Thanks for the suggestion and the link to your post. We're limited indeed by what CAML can do (one design goal is to enforce explicitness to distinguish between local and remote execution) but this is definitely on the radar for further investigations. The way to accomplish aggregates today is like this:

var totalPrice = (from p in ctx.Products select p.UnitPrice).AsEnumerable().Sum();

where AsEnumerable() transitions from remote execution into local (LINQ to Objects) execution.

Hope this helps,
-Bart