DevForce Community Forum : Best practice for aggregate functions http://www.ideablade.com/forum/ This is an XML content feed of; DevForce Community Forum : DevForce 2010 : Best practice for aggregate functions Thu, 23 May 2013 23:24:10 -700 Thu, 24 Mar 2011 06:32:12 -700 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 9.69 360 www.ideablade.com/forum/RSS_post_feed.asp?TID=2577 DevForce Community Forum http://www.ideablade.com/forum/forum_images/IdeaBlade_logo_tm.png http://www.ideablade.com/forum/ Best practice for aggregate functions : Thank you, this works great, in... http://www.ideablade.com/forum/forum_posts.asp?TID=2577&PID=10274#10274 Author: AuerRo
Subject: 2577
Posted: 24-Mar-2011 at 6:32am

Thank you, this works great, in addition with dynamic composition of queries it opens great possibilities with charting!]]> Thu, 24 Mar 2011 06:32:12 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=2577&PID=10274#10274 Best practice for aggregate functions : Hi Roland, You can accomplish... http://www.ideablade.com/forum/forum_posts.asp?TID=2577&PID=10255#10255 Author: sbelini
Subject: 2577
Posted: 22-Mar-2011 at 11:45pm

Hi Roland,

 
You can accomplish this by using projection:
 
var aggregateResultsQuery = mgr.Orders.Where(o => o.EmployeeID == 3) // base query 
  .GroupBy(o => true)
  .Select(orders => new {
    Count = orders.Sum(order => 1),
    TotalPayments = orders.Sum(order => order.Freight),
    AveragePayments = orders.Average(order => order.Freight)
  });
 
aggregateResultsQuery.ExecuteAsync(args => {
  if (args.CompletedSuccessfully) {
    var results = args.Results;
 
    // orders should be empty as no entities were loaded in the cache
    var orders = mgr.Orders.With(QueryStrategy.CacheOnly).ToList();
  }
});
 
Regards,
    Silvio
]]> Tue, 22 Mar 2011 23:45:48 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=2577&PID=10255#10255 Best practice for aggregate functions : Hi, one more question, this time... http://www.ideablade.com/forum/forum_posts.asp?TID=2577&PID=10244#10244 Author: AuerRo
Subject: 2577
Posted: 22-Mar-2011 at 7:19am

Hi, one more question, this time I'd like to know more about the possibility for aggregating query results.

In my SL-LOB-Application, I'd like to query my database for some aggregate values. Eg: I'd like to have the following values out of my "AccountTransactions"-Table: The count of (all or a queried amount of) entities stored, the sum of (all or a queried amount of) payments, the avg of (all or a queried amount of) payments.... The entities should not be loaded to the client, the query should be executed server-side, only the result (or a created result-entity) should be submitted.

Hopefully this might be simple. Is there a "best practice" to achieve that?

Thanks for any help in advance! Roland
]]> Tue, 22 Mar 2011 07:19:33 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=2577&PID=10244#10244