Print Page | Close Window

using sub query with PassthruEsqlQuery

Printed From: IdeaBlade
Category: DevForce
Forum Name: DevForce Classic
Forum Discription: For .NET 2.0
URL: http://www.ideablade.com/forum/forum_posts.asp?TID=820
Printed Date: 11-Jun-2026 at 4:34am


Topic: using sub query with PassthruEsqlQuery
Posted By: amit
Subject: using sub query with PassthruEsqlQuery
Date 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


Replies:
Posted By: kimj
Date 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 - 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.


Print Page | Close Window