DevForce Community Forum : using sub query with PassthruEsqlQuery http://www.ideablade.com/forum/ This is an XML content feed of; DevForce Community Forum : DevForce Classic : using sub query with PassthruEsqlQuery Thu, 11 Jun 2026 04:42:01 -700 Fri, 30 May 2008 11:27:14 -700 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 9.69 360 www.ideablade.com/forum/RSS_post_feed.asp?TID=820 DevForce Community Forum http://www.ideablade.com/forum/forum_images/IdeaBlade_logo_tm.png http://www.ideablade.com/forum/ using sub query with PassthruEsqlQuery : I know you posted elsewhere that... http://www.ideablade.com/forum/forum_posts.asp?TID=820&PID=3007#3007 Author: kimj
Subject: 820
Posted: 30-May-2008 at 11:27am

I know you posted elsewhere that you found an answer, but I thought I'd add a link to a good Microsoft resource on Entity SQL - http://msdn.microsoft.com/en-us/library/bb399560.aspx.
 
The DevForce EF PassthruEsqlQuery takes the query given it and performs no validation, but just passes it along to the Entity Framework for execution; so you need to provide a valid eSQL query.
]]> Fri, 30 May 2008 11:27:14 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=820&PID=3007#3007 using sub query with PassthruEsqlQuery : Hi, How can I use sub query... http://www.ideablade.com/forum/forum_posts.asp?TID=820&PID=3004#3004 Author: amit
Subject: 820
Posted: 29-May-2008 at 10:50pm

Hi,
 
   How can I use sub query with PassthruEsqlQuery as we write in transact SQL
like
 
 "select * from Account where PaymentType in(select paymentType from Payment) "
 
I want to use such query with PassthruEsqlQuery.
 
regards
Amit
]]> Thu, 29 May 2008 22:50:40 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=820&PID=3004#3004