DevForce Community Forum : Skip, Take and Count http://www.ideablade.com/forum/ This is an XML content feed of; DevForce Community Forum : DevForce 2010 : Skip, Take and Count Sun, 12 Apr 2026 05:54:58 -700 Thu, 25 Aug 2011 12:05:17 -700 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 9.69 360 www.ideablade.com/forum/RSS_post_feed.asp?TID=2922 DevForce Community Forum http://www.ideablade.com/forum/forum_images/IdeaBlade_logo_tm.png http://www.ideablade.com/forum/ Skip, Take and Count : Mickan,Projections will return... http://www.ideablade.com/forum/forum_posts.asp?TID=2922&PID=11527#11527 Author: sbelini
Subject: 2922
Posted: 25-Aug-2011 at 12:05pm

Mickan,
 
Projections will return only the entity part you selected (not the entire entity). There is an article in the DevForce Resource Center that explains this topic in detail.
 
When working n-tier, no entities will be loaded into the BOS when returning a count.
 
Silvio.
]]> Thu, 25 Aug 2011 12:05:17 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=2922&PID=11527#11527 Skip, Take and Count : Silvio, thanks thats very helpful,... http://www.ideablade.com/forum/forum_posts.asp?TID=2922&PID=11526#11526 Author: mickan
Subject: 2922
Posted: 25-Aug-2011 at 11:13am

Silvio, thanks thats very helpful, especially the code sample.   To dig a little deeper:
 
Do projections behave the same way, or will they result in data row transfer?
With a BOS involved, will there be data row retrival into the BOS in either of the entity or projection cases when returning a count?
]]> Thu, 25 Aug 2011 11:13:10 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=2922&PID=11526#11526 Skip, Take and Count : Hi mickan,Yes, Count() causes... http://www.ideablade.com/forum/forum_posts.asp?TID=2922&PID=11525#11525 Author: sbelini
Subject: 2922
Posted: 25-Aug-2011 at 10:53am

Hi mickan,
 
Yes, Count() causes immediate execution of the query, but that doesn't mean that all the records have been returned to the client.
 
You can verify that:
 
  mgr.Clear();
  var ordersCount = mgr.Orders.Count(); // will return the number of Orders in the datasource
  var orders = mgr.Orders.With(QueryStrategy.CacheOnly).Execute(); // will be empty because no Orders were loaded in the client
 
or, if working asynchronously:
 
  mgr.Clear();
  var ordersCountOp = mgr.Orders.AsScalarAsync().Count();
  ordersCountOp.Completed += (o, args) => {
    var ordersCount = ordersCountOp.Result; // will return the number of Orders in the datasource
    var orders = mgr.Orders.With(QueryStrategy.CacheOnly).Execute(); // will be empty because no Orders were loaded in the client
  };
 
To answer your questions:
1. Only the requested rows will be transfered from the data source.
2. Not necessary. (given explanation about Count() above)
3. If you are retriving a really large number of records and it's causing your app to 'hang' during this retrieval, I'd suggest issuing 2 queries: one for the records that will populate the first grid page and other for all records.
 
Regards,
   Silvio.
]]> Thu, 25 Aug 2011 10:53:26 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=2922&PID=11525#11525 Skip, Take and Count : From what I've read on the... http://www.ideablade.com/forum/forum_posts.asp?TID=2922&PID=11512#11512 Author: mickan
Subject: 2922
Posted: 24-Aug-2011 at 7:26am

From what I've read on the board I think I understand that the linq Count() operation causes immediate execution of the query.  So if the query was to return thousands of rows that would be "unfortunate" for the user, especially over a wan.
 
I can use Skip() and Take() to chunk the data retrieval, but my Xceed grid wants a count of possible records, presumably to display the thumb slider at an appropriate size and do other housekeeping for "virtualizing" the data presentation.
 
So my questions are:
 
1. Are skip() and take() executed in the BOS so that only the requested rows get transferred from the data source?
2. Is requesting an implementation of a linq extension, say ToCount(), a reasonable ask of the DevForce linq provider?
3. Any better suggestions for me than having two methods for potentially large queries in my repository, such as
 
IList GetLotsOfEntities();
int    GetLotsOfEntitiesCount();
]]> Wed, 24 Aug 2011 07:26:31 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=2922&PID=11512#11512