Hi, I am working with an EntityCollection. The EntityCollection need to be filtered and I used

IRelationPredicateBucket filter = new RelationPredicateBucket(); filter.PredicateExpression.Add(WiremessageFields.WireServiceId == wireServiceID); filter.PredicateExpression.AddWithAnd(WiremessageFields.Headline == 's' | WiremessageFields.Category == 'q');

to add filter entries. I have no problem to add filters this way. The problem is, the filter information in my case was stored in a database table field. For example the previous code will be stored in a field:

WireServiceID = 1 AND (Category = 's' OR Category ='q')

I want to apply these filters on to the EntityCollection when I fetch it. Apparently I cannot directly add this string to the PredicateExpression. I am trying to do something like filter.PredicateExpression.Add(" WireServiceID = 1 AND (Category = 's' OR Category ='q')");

Is there a way to do this? Thanks.

There's no direct way to do that, as the entities should be query agnostic. You should try some parser out there (GOLD parser, for instance), then create a method that translate your string into IPredicateExpression and return that. Is the better/clean solution I can think for this.

daelmo wrote:

There's no direct way to do that, as the entities should be query agnostic. You should try some parser out there (GOLD parser, for instance), then create a method that translate your string into IPredicateExpression and return that. Is the better/clean solution I can think for this.

Hi, thanks for the reply. Instead of using the parser, I think the following will also work. extract the filter info from DB and put it into part of the T-sql script. Then create a SqlCommand object, call ExecuteReader() to get all qualified rows. Then create a entity collection EntityCollection<WiremessageEntity> wires = new EntityCollection<WiremessageEntity>();

and we can call wires.Add(wire); in a while loop to add rows one by one.