New Posts New Posts RSS Feed: using sub query with PassthruEsqlQuery
  FAQ FAQ  Forum Search   Calendar   Register Register  Login Login

using sub query with PassthruEsqlQuery
 Post Reply Post Reply
Author
  Share Topic Share Topic  Topic Search Topic Search  Topic Options Topic Options
amit View Drop Down
Newbie
Newbie
Avatar

Joined: 29-May-2008
Location: India
Posts: 2 		Post Options Post Options   Quote amit Quote  Post ReplyReply Direct Link To This Post Topic: using sub query with PassthruEsqlQuery
    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
Back to Top
kimj View Drop Down
IdeaBlade
IdeaBlade
Avatar

Joined: 09-May-2007
Posts: 1391 		Post Options Post Options   Quote kimj Quote  Post ReplyReply Direct Link To This Post 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.
Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down