Hi,  We are using NVarchar and NText datatype in our database. How can I compare the value of a neutral field? In noraml MS SQL query we have to place ''N'' before criteria. How to do unicode comparision while using Entity Spaces? Ex: Select * from tblCountry Where CountryName = N'बूबह' Please provide your expert comments Thanks,Mahesh

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 ...

Hi,I have an issue with one of my projects and I was wondering if someone could help me out. We are doing a join on a number of tables and creating a collection. So  Create a collection of table1 then create a query joining table1 to table2 on a PK and thus adding a new column to our collection.  IF this query does not return a value ...

Hi Everyone, this is my first time using entity spaces. I am using a query that joins two tables and loading it into a collection object. The problem l have is that l cannot access the columns/values from the other part of the join from the object. here is the code l have for doing that.... If e.RowIndex >= 0 And e.ColumnIndex = ...

Hi there, As a follow up question, what if I have aliased fields in the query? For example, Code:UserCustomerQuery u2 = new UserCustomerQuery(''u2''); UserExaminerQuery ue = new UserExaminerQuery(''ue''); UserQuery u = new UserQuery(''u''); u2.Select(u2.UserId, (u2.FirstName + '' '' + ...

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 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 ...