DevForce Community Forum : Where can I find info/documentation about "Adding API for composing dynamic queries" in the 5.2.2 release http://www.ideablade.com/forum/ This is an XML content feed of; DevForce Community Forum : DevForce 2009 : Where can I find info/documentation about "Adding API for composing dynamic queries" in the 5.2.2 release Tue, 28 Apr 2026 22:35:42 -700 Fri, 30 Oct 2009 00:15:43 -700 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 9.69 360 www.ideablade.com/forum/RSS_post_feed.asp?TID=1458 DevForce Community Forum http://www.ideablade.com/forum/forum_images/IdeaBlade_logo_tm.png http://www.ideablade.com/forum/ Where can I find info/documentation about "Adding API for composing dynamic queries" in the 5.2.2 release : Yeah for the situation I want... http://www.ideablade.com/forum/forum_posts.asp?TID=1458&PID=5712#5712 Author: *Calsy
Subject: 1458
Posted: 30-Oct-2009 at 12:15am

Yeah for the situation I want to use it in I need to provide the nested query property as a string i.e. "Supplier.CompanyName". This is so we can dynamically build up our filter.

Thanks
]]> Fri, 30 Oct 2009 00:15:43 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=1458&PID=5712#5712 Where can I find info/documentation about "Adding API for composing dynamic queries" in the 5.2.2 release : Unfortunately the PredicateDescription... http://www.ideablade.com/forum/forum_posts.asp?TID=1458&PID=5711#5711 Author: kimj
Subject: 1458
Posted: 29-Oct-2009 at 6:36pm

Unfortunately the PredicateDescription does currently have the limitation that the property exist on the supplied type, but we'll open a bug report for this since it should be possible to query for nested properties.
 
The workaround right now would be to use the Expression<Func<T, bool>> syntax of the PredicateBuilder, which may not quite meet your needs ...
 
      Expression<Func<Product, bool>> crit1 = p => p.Supplier.CompanyName.Contains("Blah");
      var query = entityManager.Products.Where(crit1);
      var list = query.ToList();
]]> Thu, 29 Oct 2009 18:36:04 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=1458&PID=5711#5711 Where can I find info/documentation about "Adding API for composing dynamic queries" in the 5.2.2 release : Hi People, Is there any way that... http://www.ideablade.com/forum/forum_posts.asp?TID=1458&PID=5701#5701 Author: *Calsy
Subject: 1458
Posted: 28-Oct-2009 at 2:52pm

Hi People, Is there any way that we can build subqueries with the predicate builder. e.g.
var expr1 = new PredicateDescription(entityType, "Supplier.CompanyName", FilterOperator.Contains, "Blah");
 
Or is there a work around to do this?
 
Thanks
]]> Wed, 28 Oct 2009 14:52:57 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=1458&PID=5701#5701 Where can I find info/documentation about "Adding API for composing dynamic queries" in the 5.2.2 release : You can aslo dynamically create... http://www.ideablade.com/forum/forum_posts.asp?TID=1458&PID=5344#5344 Author: kimj
Subject: 1458
Posted: 09-Sep-2009 at 8:01pm

You can aslo dynamically create an EntityQuery<T>, where T isn't known until run time.  Here's a sample - 
var entityType = typeof(Product);
var baseQuery = (IQueryable) TypeFns.ConstructGenericInstance(typeof(EntityQuery<>), entityType);
var expr1 = new PredicateDescription(entityType, "UnitPrice", FilterOperator.IsGreaterThanOrEqualTo, 24);
var expr2 = new PredicateDescription(entityType, "Discontinued", FilterOperator.IsEqualTo, true);
var query = PredicateBuilder.FilterQuery(baseQuery, expr1.And(expr2));
var results = _entityManager.ExecuteQuery((IEntityQuery)query);

 

]]> Wed, 09 Sep 2009 20:01:19 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=1458&PID=5344#5344 Where can I find info/documentation about "Adding API for composing dynamic queries" in the 5.2.2 release : That description refers to the... http://www.ideablade.com/forum/forum_posts.asp?TID=1458&PID=5343#5343 Author: GregD
Subject: 1458
Posted: 09-Sep-2009 at 5:26pm

That description refers to the material described in the release notes and developers’ guide under… the following headings:

Ideablade.Linq.PredicateBuilder
Ideablade.Linq.PredicateDescription
 
]]> Wed, 09 Sep 2009 17:26:33 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=1458&PID=5343#5343 Where can I find info/documentation about "Adding API for composing dynamic queries" in the 5.2.2 release : I&#039;ve looked through the release... http://www.ideablade.com/forum/forum_posts.asp?TID=1458&PID=5337#5337 Author: pk55
Subject: 1458
Posted: 08-Sep-2009 at 4:47pm

I've looked through the release notes as well as the reference help and the developers guide but didn't see any mention of one of the new features mentioned in the forum post that announced the new release; Adding API for composing dynamic queries.
 
Was this referring to the PredicateDescription and building dynamic filters (I was hoping for dynamic queries where the type could also be specified in the same way you're specifying the field as a string in the PredicateDescription)?
 
Thanks.
]]> Tue, 08 Sep 2009 16:47:06 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=1458&PID=5337#5337