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, I am trying to randomise the results of a Collection. We are in the process of replacing old code using entity spaces so that we use only the generated stored procedures. Before entityspaces, i was using something like this:  SELECT TOP 5 * FROM tblUser WHERE profile_exists=1 ORDER BY NEWID()  But, i can't figure out a way to use ...

Hello Guys, I've been struggling to find a solution to a problem I've come up with and I'm hoping you might know of an answer. In my database I currently have 3 summary tables used for searches (columns in brackets): Products (ProductID, Brand, Model, Price) PDAs (ProductID, Brand, Model, Price, Screen Size, Operating System) MobilePhones ...