Hi,

Is there a way to use IN operator while using FetchEntityCollection? My code is given below:

  public IList FindAll(IEntity2 obj, IRelationPredicateBucket filter, IPrefetchPath2 prefetchPath2, bool isEventBind)
        {
            using (var adapter = new DataAccessAdapter())
            {
                var entityCollection = new EntityCollection(obj.GetEntityFactory());
                adapter.FetchEntityCollection(entityCollection, filter, prefetchPath2);
                if (isEventBind)
                {
                    BindEvents(entityCollection);
                }
                return entityCollection.GetList();
            }
        }

Using linq will be bad situation since, we have too many records in the collection.

Sure, you'll need to use FieldCompareSetPredicate

In your code add it to:

filter.PredicateExpression.Add(new FieldCompareSetPredicate(......))