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