Hello,

Is there a way to merge several IRelationPredicateBucket objects into a single one?

So if you want to fetch a collection of OrderEntities according to different criterias (Employee, Customer, Product), you could use

myCustomer.GetRelationInfoOrder() myEmployee.GetRelationInfoOrder() myProduct.GetRelationInfoOrderViaOrderDetails()

to form a single IRelationPredicateBucket to use with fetchEntityCollection()

this should work. although the order of relationships is significant so this may be fragile.

function void Merge(IRelationshipBucket source, IRelationshipBucket destination)
{
     foreach(IEntityRelation relation in source.Relationships)
     {
            destination.Relationships.Add(relation);
     }
     foreach(IPredicateExpression predicate in source.PredicateExpression)
     {
            destination.PredicateExpression.Add(predicate);
     }
}

Note: I haven't tested this.

dstFilter.Relations.AddRange((RelationCollection)srcFilter.Relations); dstFilter.PredicateExpression.AddWithAnd(srcFilter.PredicateExpression);

Thanks Otis and jmeckley, That's exactly the code I wrote, but I was not sure if it was a good practice or not.

Just an idea : I think it would be nice to add this to the "How do I..." section of the help?