EntityDataSource Where?

I have a entitydatasource connecting to my database and I want to filter the results using the "Where" property. As a test I have the following:

it.CustomerID is not 6

And I get the following error:

The query syntax is not valid. Near term '6', line 6, column 25.

I guess what I'm typing in is wrong, but why?

Answers


Usage of the "Where" property follows the Entity SQL language. So, i think that right syntax is:

it.CustomerID != 6

or

it.CustomerID <> 6

Entity SQL Reference - "Not Equal To" Operator: http://msdn.microsoft.com/en-us/library/vstudio/bb399278(v=vs.100).aspx


Remove 'is not' to != and make sure that we can't write any function on EntityDataSource like upper(), lower().. etc but you can do it as Linq query


Need Your Help

Less css parse error on mixin

wordpress debugging twitter-bootstrap less mixins

I'm using wp-less with wordpress and the Twitter Bootstrap plugin from iControlWP.

How to speed up build downloads for global teams?

build download continuous-integration scalability scaling

I am working with a globally distributed development team that has to download builds of our software across geographies and oceans. Our build output is GBs in size and takes a while for developers...