DevForce Community Forum : PassthruEsqlQuery http://www.ideablade.com/forum/ This is an XML content feed of; DevForce Community Forum : DevForce 2009 : PassthruEsqlQuery Sat, 11 Apr 2026 11:37:25 -700 Mon, 14 Sep 2009 14:13:10 -700 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 9.69 360 www.ideablade.com/forum/RSS_post_feed.asp?TID=1470 DevForce Community Forum http://www.ideablade.com/forum/forum_images/IdeaBlade_logo_tm.png http://www.ideablade.com/forum/ PassthruEsqlQuery : EF is expecting an EntitySet named... http://www.ideablade.com/forum/forum_posts.asp?TID=1470&PID=5380#5380 Author: kimj
Subject: 1470
Posted: 14-Sep-2009 at 2:13pm

EF is expecting an EntitySet named "DailyVehicleRoute" in the conceptual model.  If you've used the pluralizer, the name is most likely "DailyVehicleRoutes".

]]> Mon, 14 Sep 2009 14:13:10 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=1470&PID=5380#5380 PassthruEsqlQuery : I am trying to run a query that... http://www.ideablade.com/forum/forum_posts.asp?TID=1470&PID=5374#5374 Author: mbevins1
Subject: 1470
Posted: 14-Sep-2009 at 10:09am

I am trying to run a query that looks like this:
 

parameterizedEsql =

SELECT VALUE oo FROM

Employees AS oo

WHERE oo.EmployeeID NOT IN

(SELECT DER.EmployeeID FROM DailyEmployeeRoute as DER WHERE DER.DailyVehicleRouteID IN

(SELECT DailyVehicleRouteID FROM DailyVehicleRoute as DVR WHERE DVR.RouteDate = '9/9/2009' ))

AND oo.isActive =1

AND oo.OperationID = 1

 

var query = new PassthruEsqlQuery(typeof(Employee), parameterizedEsql);

When i run it I get this error:
'DailyEmployeeRoute' could not be resolved in the current scope or context. Make sure that all referenced variables are in scope, that required schemas are loaded, and that namespaces are referenced correctly.
 
 
How do I go about running a query like this?
 
 
]]> Mon, 14 Sep 2009 10:09:54 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=1470&PID=5374#5374