DevForce Community Forum : EntityQuery, with "dynamic" where clause http://www.ideablade.com/forum/ This is an XML content feed of; DevForce Community Forum : DevForce 2010 : EntityQuery, with "dynamic" where clause Sun, 26 Apr 2026 22:46:45 -700 Fri, 27 May 2011 14:04:44 -700 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 9.69 360 www.ideablade.com/forum/RSS_post_feed.asp?TID=2725 DevForce Community Forum http://www.ideablade.com/forum/forum_images/IdeaBlade_logo_tm.png http://www.ideablade.com/forum/ EntityQuery, with "dynamic" where clause : Well, thank you for just saving... http://www.ideablade.com/forum/forum_posts.asp?TID=2725&PID=10856#10856 Author: Randar
Subject: 2725
Posted: 27-May-2011 at 2:04pm

Well, thank you for just saving me hours of banging my head against the wall.

Worked perfectly, after I ported it over to VB.Net. ;-)
]]> Fri, 27 May 2011 14:04:44 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=2725&PID=10856#10856 EntityQuery, with "dynamic" where clause : In case anybody is wondering what... http://www.ideablade.com/forum/forum_posts.asp?TID=2725&PID=10855#10855 Author: sbelini
Subject: 2725
Posted: 27-May-2011 at 1:17pm

In case anybody is wondering what a possible solution would look like:
 
  var queriedID = 1;
  var queryType = typeof(Employee);
 
  var baseQuery = EntityQuery.Create(queryType, mgr);
  var properties = queryType.GetProperties();
  IEnumerable result;
  if (properties.Any(p => p.Name == "CompanyID")) {
    PredicateDescription predicate = PredicateBuilder.Make(queryType, "CompanyID", FilterOperator.IsEqualTo, queriedID);
    var query = baseQuery.Where(predicate);
    result = query.Execute();
  }
 
Detailed information about dynamic queries is available in the DevForce Resource Center.
 
Silvio.
]]> Fri, 27 May 2011 13:17:29 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=2725&PID=10855#10855 EntityQuery, with "dynamic" where clause : Hi Randar -I saw you talked with... http://www.ideablade.com/forum/forum_posts.asp?TID=2725&PID=10854#10854 Author: ting
Subject: 2725
Posted: 27-May-2011 at 12:13pm

Hi Randar - I saw you talked with Albert on the phone about this. Let us know if you need any more help with it.

]]> Fri, 27 May 2011 12:13:03 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=2725&PID=10854#10854 EntityQuery, with "dynamic" where clause : I've got some code I'm... http://www.ideablade.com/forum/forum_posts.asp?TID=2725&PID=10850#10850 Author: Randar
Subject: 2725
Posted: 27-May-2011 at 8:40am

I've got some code I'm trying to port over.  A key part of it generates some dynamic sql like so:

strSQL = "Select * From " & SqlTableName & " Where CompanyID=" & CompanyID

I'm trying to figure out the best way to map this to an EntityQuery(Of T).  What I would like to do is:
1) Check if T has a specific property, called CompanyId.  This *should* be possible through reflection.
2) Once I've verified that this property exists, extend the EntityQuery to include this in the Where clause.  That, I'm not so sure how to do.

My current thinking is either:
a) Expose an interface on the underlying Entity called ICompany, that exposes the CompanyId.  I think I *should* be able to build predicate up once I have that and then attach that to the Where clause.
b) Give up...and change all the calling methods to include the company filter. 

Any thoughts?
]]> Fri, 27 May 2011 08:40:37 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=2725&PID=10850#10850