DevForce Community Forum : Dynamic Query from two predicates.

Dynamic Query from two predicates. : Hi pk55;The patch that I'm...

Mon, 27 Jun 2011 16:00:38 -700

Author: DenisK
Subject: 2758
Posted: 27-Jun-2011 at 4:00pm

Hi pk55;

The patch that I'm sending you will contain this fix as well.

Dynamic Query from two predicates. : Any idea when this would be fixed...

Mon, 27 Jun 2011 15:57:10 -700

Author: pk55
Subject: 2758
Posted: 27-Jun-2011 at 3:57pm

Any idea when this would be fixed to allow a composite?

Dynamic Query from two predicates. : The problem with the CompositionPredicateDescription...

Mon, 27 Jun 2011 13:08:20 -700

Author: kimj
Subject: 2758
Posted: 27-Jun-2011 at 1:08pm

The problem with the CompositionPredicateDescription when used with FilterOperator.Any is actually a bug. The intention with our dynamic query API has been to provide support for common LINQ methods. The Queryable.Any LINQ method, which FilterOperator.Any is trying to proxy, supports either no arguments or a single predicate, and we translated that "predicate" a bit too strictly.

Dynamic Query from two predicates. : Is the requirement that the ANY...

Sat, 25 Jun 2011 14:11:43 -700

Author: pk55
Subject: 2758
Posted: 25-Jun-2011 at 2:11pm

Is the requirement that the ANY filter operator only have one, single predicate description a bug or is that by design?

Seems kind of limited if you can't filter a child collection on more than one property and then filter the parent based on it having a child that matches that condition.

Dynamic Query from two predicates. : Thank you - that works!One remark...

Tue, 14 Jun 2011 03:11:50 -700

Author: sarmaad
Subject: 2758
Posted: 14-Jun-2011 at 3:11am

Thank you - that works!

One remark - pd1 cannot be a CompositePredicateDescription, it generates exception otherwise.

Dynamic Query from two predicates. : That is an ugly exception....

Mon, 13 Jun 2011 14:52:21 -700

Author: kimj
Subject: 2758
Posted: 13-Jun-2011 at 2:52pm

That is an ugly exception. It looks like we have a problem with the use of the nested Queryable.Any() inside of the predicate, but it's going to take more research to determine the underlying problem and how we might fix it.

For now, if you're able to use PredicateDescriptions for both clauses, you can do something like the following:

var baseQuery = EntityQuery.Create(typeof(Contact), Manager);
var pd1 = new PredicateDescription(typeof(CompanyContacts), "Company.CompanyName", FilterOperator.Contains, "some_name");
var pd2 = new PredicateDescription(typeof(Contact), "CompanyContacts", FilterOperator.Any, pd1);
var query = baseQuery.Where(pd2).OrderBySelector(selector).Skip(skip).Take(take);

Dynamic Query from two predicates. : I have got a following query:E...

Mon, 13 Jun 2011 05:48:42 -700

Author: sarmaad
Subject: 2758
Posted: 13-Jun-2011 at 5:48am

I have got a following query:

Expression<Func<Contact, bool>> c2 = (col => col.CompanyContacts.AsQueryable().Any(p => p.Company.CompanyName.Contains("some_name")));

ITypedEntityQuery query = EntityQuery<Contact>.Create(typeof(Contact), Manager).Cast<Contact>().Where(c2).OrderBySelector(selector).Skip(skip).Take(take);

That works perfectly fine. Unfortunatelly when I try to split the first expression into two like this:

var exp1 = (Expression>)(p => p.Company.CompanyName.Contains("some_name"));

Expression> c2 = (col => col.CompanyContacts.AsQueryable().Any(exp1));

I got a nasty serialization error:

Type 'System.Linq.Expressions.Expression`1[System.Func`2[DomainModel.CompanyContact,System.Boolean]]' cannot be serialized. Consider marking it with the DataContractAttribute attribute, and marking all of its members you want serialized with the DataMemberAttribute attribute. If the type is a collection, consider marking it with the CollectionDataContractAttribute. See the Microsoft .NET Framework documentation for other supported types.

The point of splitting the query is simple - I want to generate the inner part from IPredicateDescription.

Thanks in advance.