Hi Mike, Thanks for you replay. I have tried out your code, it throws following error. Currently I am using ES 2007.1.1210.0. 'EntitySpaces.Interfaces.esColumnItem' does not contain a definition for 'Query' on below line of code. itemData.Column.Query = q; I want to add default Where clause in each of the query executed, so I have override the ...

Hi Scott, We have same requirement as dipple, We want to add default criteria in where clause of every query. To achieve this I have override the load method of QueryBase class. Code is given below. But when I execute any query it throws error ''No overload for method 'esWhereItem' takes '3' arguments'' on following line.  this.Where(new ...

Hi, esWhereItem function has been changed in lates version of Entity spaces. When I write below give line in my code it throws error that there is no over loaded method with three parameters while it's working perfectly in previous version. So how I should write below given line in latest verion of Entity spaces. this.Where(new ...

Finally figured it out, and yes these are not valid uniqueidentifiers in my example Code:// I know the following doesn't work in SQL user_id in (@userList) // so I thought the following was generated user_id in (@user_id1, @user_id2, @user_id3) // instead, the following happens if passed in as a Guid or Object user_id in (111-11-1111, ...

Hello all, I am trying to create a function that accepts an entity collection populated with certain data that will be used in turn to create a where clause that is based off the populated field/column name and its value. My current code receives a collection loop through it looking for fields that have data and extracting a field name as a ...