We are using newest version 6.1.4

In one of our queries, we use a predicate like this:

var ids = someIds as List<int>;

 

var predicate = PredicateBuilder.False<EntAlarm>();

 

if (ids.Count > 0)

predicate = ids.Aggregate(predicate,

                           (current, id) =>

                           current.Or(a => a.p_alarmID == id));

 

var query = p_manager.EntAlarms.Where(predicate);

 

query.QueryStrategy = new QueryStrategy(FetchStrategy.DataSourceThenCache, MergeStrategy.PreserveChanges);

 

Query(query, callback);

If the list of someIds gets big (2000 ids), we get a stackoverflow error in IdeaBlade.Linq.dll.

Are there some limits, when working with predicates?

I find that when using the predicate builder - the queries become slow, but this is perhaps expected?

Now I have discovered ESQL – so I tried it instead like this:

var ids = alarmIds as List<int>;

 

var q = new PassthruEsqlQuery(typeof (EntAlarm),

"SELECT VALUE A from EntAlarms as A where A.p_alarmID in {" + String.Join(",",ids.Select(id => id.ToString()).ToArray()) + "}");

 

q.With(p_manager).ExecuteAsync(results => test(results, callback));

I think it is faster.

{EntityServerException: The query syntax is not valid. Near term '}', line 1, column 59. ---> System.Data.EntitySqlException: The query syntax is not valid. Near term '}', line 1, column 59.

   at IdeaBlade.EntityModel.Server.EntityServerQueryInterceptor.HandleException(Exception e, PersistenceFailure failureType)...