Error in filtering grid when data source is LinqDataSource

[reza meshksar]

In my form I have a RadGrid control and the data source is LinqDataSource which is connected to Entity Framework Model.

Everything works fine except when I am trying to do filtering on columns. For example when I try to apply contains filter on a string column I am getting this error:

LINQ to Entities does not recognize the method 'System.String ToString()' method, and this method cannot be translated into a store expression.

We are using DataSourceID property in the grid for data binding.

I tried EntityDataSource as datasource and filtering works fine, but we have to use LinqDataSource in our specific case.

Any ideas why it happens?

[Maria Ilieva]

Hello,

Linq to Entities does not support as many conversion of functions to server hosted sql.

ToString (on anything) is one of them

Here's a post suggesting workarounds and here's the list of supported functions

All the best,
Maria Ilieva
the Telerik team