http://www.ideablade.com/forum/ This is an XML content feed of; DevForce Community Forum : DevForce 2012 : WinRT, Code First - query with Count() Wed, 29 Apr 2026 01:46:32 -700 Sun, 28 Jul 2013 09:32:19 -700 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 9.69 360 www.ideablade.com/forum/RSS_post_feed.asp?TID=4251 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=4251&PID=16660#16660 Author: kimj
Subject: 4251
Posted: 28-Jul-2013 at 9:32am

"Count" is a scalar query operator and will return the integer value, not a query. You can use the DevForce AsScalarAsync method to turn this into an actual query which can be awaited, eg:

var result = await appTestEntityManager.Users.AsScalarAsync().Count();

More information here - http://drc.ideablade.com/devforce-2012/bin/view/Documentation/async-immediate-execution.]]> Sun, 28 Jul 2013 09:32:19 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=4251&PID=16660#16660 http://www.ideablade.com/forum/forum_posts.asp?TID=4251&PID=16659#16659 Author: zbig
Subject: 4251
Posted: 27-Jul-2013 at 2:10pm

Hi,

WinRT, DevForce 7.2, EF Code First.

I would like to retrieve the number of my entities (let say Users), but very simple query code with Count() extension gives compile error message 'cannot convert from 'int' to 'IdeaBlade.EntityModel.IEntityQuery':

var usersQuery = appTestEntityManager.Users.Count();
var result = await appTestEntityManager.ExecuteQueryAsync(usersQuery);

How to get a number of Users without retrieving the whole set of Users to the client?

Thanks in advance for any advice. ]]> Sat, 27 Jul 2013 14:10:48 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=4251&PID=16659#16659