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

I’m tiring to allow the user to populate the select clause from as saved list or list box.  I’m hoping to be able to pass a list into the Select or Where clause as needed.   Myview coll = new myview(); List<object> myList = new List<object>   //logic to add column names ...

I'm trying to implement a cached where clause with parameters that get converted to esParameters. Code:ItemFilter filter = new ItemFilter(); filter.WhereClause = ''[issueType_id] IN (@issueList)''; filter.AddParameter(''issueList'', ''2,3,5,6,7,8,9''); filter.Save(); IssueCollection coll = new IssueCollection(); ...

Is there a way to get the generated SQL string without calling Load? I'm trying to build a conditional where clause like John describes in an Adv Search page and would like to save the generated SQL to a database field so that it can be recalled an ran again.  A ''MySearches'' section where people can save off search parameters with a ...

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