Don't forget add EntitySpaces operands to Where method.

In EntitySpaces  you can specify filter to load data. I've wrote the following code

EmployeesCollection collection = new EmployeesCollection();   
Collection.Query.LastName.Like("A%")   
collection.Query.Load();   

and couldn't understand why the filter doesn't work.

The reason is that functions similat to Like, LessThan return esWhereItem that will work only after they passed to esDynamicQuery.Where(Object[]()) method.
So the correct code must be

Dim collection As EmployeesCollection = New EmployeesCollection()  
collection.Query.Where(collection.Query.LastName.Like("A%"))
collection.Query.Load()    
 

Exclude non-stringable columns in EntitySpaces templates.

In MyGeneration template for EntitySpaces (see Template: Ajax Auto Complete WebServices using EntitySpaces) I wanted to loop through all columns of the table but exclude those that can not be converted to string(e.g TimeStamp).
It's can be done by calling EntitySpaces esPlugIn methods IsObjectType and IsArrayType

  foreach(IColumn col in cols)
  {
    if(!esPlugIn.IsArrayType(col) && !esPlugIn.IsObjectType(col))
    {//exclude fields like TimeStamps
         //put your code here
    }
  
  }

«February»
SunMonTueWedThuFriSat
28293031123
45678910
11121314151617
18192021222324
25262728123
45678910