DevForce Community Forum : ParameterizedEsql and TOP or Take() http://www.ideablade.com/forum/ This is an XML content feed of; DevForce Community Forum : DevForce 2010 : ParameterizedEsql and TOP or Take() Mon, 13 Apr 2026 20:39:13 -700 Fri, 26 Aug 2011 12:38:52 -700 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 9.69 360 www.ideablade.com/forum/RSS_post_feed.asp?TID=2931 DevForce Community Forum http://www.ideablade.com/forum/forum_images/IdeaBlade_logo_tm.png http://www.ideablade.com/forum/ ParameterizedEsql and TOP or Take() : Chuck, It appears that in ESQL... http://www.ideablade.com/forum/forum_posts.asp?TID=2931&PID=11549#11549 Author: robertg
Subject: 2931
Posted: 26-Aug-2011 at 12:38pm

Chuck,

It appears that in ESQL (and not just our implementation via PassThruEsqlQuery), you have to implement the ORDER BY keyword with LIMIT() to limit the number of responses returned. For example the following simple query is valid, and returns the expected results:
 

_em1 = new NorthwindIBEntities();

var query0 = new PassthruEsqlQuery(typeof(Customer),"SELECT VALUE c FROM Customers AS c order by c.CustomerID limit(5)");

var result0 = query0.With(_em1).Execute().Cast<Customer>();

Yours,
Robert
]]> Fri, 26 Aug 2011 12:38:52 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=2931&PID=11549#11549 ParameterizedEsql and TOP or Take() : Is there some way to restrict... http://www.ideablade.com/forum/forum_posts.asp?TID=2931&PID=11548#11548 Author: chuckc
Subject: 2931
Posted: 26-Aug-2011 at 11:38am

Is there some way to restrict the number of returned entities when using ParameterizedEsql?  Take() is not supported by PassthruEsqlQuery, and my first couple tries at using TOP embedded in the sql string weren't successful.

Thanks for any help.
]]> Fri, 26 Aug 2011 11:38:29 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=2931&PID=11548#11548