LINQ to Entities exception on search

[luposky]

Sorry, I get an exception using the search box:

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

in Mvc.JQuery.Datatables.DynamicLinq.DynamicQueryable.Count(IQueryable source)
in Mvc.JQuery.Datatables.DataTablesFilter.FilterPagingSortingSearch(DataTablesParam dtParameters, IQueryable data, Int32& totalRecordsDisplay, Tuple`2[] columns)
in Mvc.JQuery.Datatables.DataTablesResult`2.GetResults(IQueryable q, DataTablesParam param, Tuple`2[] searchColumns)
in Mvc.JQuery.Datatables.DataTablesResult`2..ctor(IQueryable`1 q, DataTablesParam dataTableParam, Func`2 transform)
in Mvc.JQuery.Datatables.DataTablesResult.Create[T,TRes](IQueryable`1 q, DataTablesParam dataTableParam, Func`2 transform)
in LizardSetup.Controllers.ResultController.GetResults(DataTablesParam dataTableParam) in (myfile.cs)

I installed the package with nuget, followed the sample ... the grid is working (paging, sorting) but using the seach box give the exception ...

Any info ? Thanks,
Best regards,
Luca

[mcintyre321]

So this is down to EF not handling the .ToString() function correctly on one or more of the properties of the object being queried, which is needed so the query can get parsed.

According to http://stackoverflow.com/questions/1228318/linq-int-to-string there are some workarounds you can try, but it could also be down to some issues in my library.

If you can't get it to work using SqlFunctions.StringConvert or one of the other workarounds, I would be happy to fix the issue if you can provide me with a project with an example of the bug.

One thing that might make it easier for you to diagnose the problem would be to enable the per column filters

@{
    DataTableVm vm = Html.DataTableVm("table-id", "/home/getusers", "Id", "Name", "Email");
    vm.ColumnFilters = true;
}
@Html.Partial("DataTable", vm)

[luposky]

Thanks for the support.
I'm not in the office now, but I would let you know that you can reproduce the problem adding this single line in the User class of your example:

public class User
...
public List<Guid> Test { get; set; }

The library try to search in this field and get an exception ..
There is a way to tell to the library the columns to use for search (or exclude this kind of column) ?

Best regards,
Luca

[mcintyre321]

Try doing a select statement against your data source which returns an
anonymous type which only has the column you want to display. If the column
type doesn't work, you can do a .ToString().

e.g. Test.Select(t => t.ToString())

This won't work with EF due to the bug you found

On 9 February 2012 12:28, luposky <
reply@reply.github.com

wrote:

Thanks for the support.
I'm not in the office now, but I would let you know that you can reproduce
the problem adding this single line in the User class of your example:

public class User
...
public List Test { get; set; }

The library try to search in this field and get an exception ..
There is a way to tell to the library the columns to use for search (or
exclude this kind of column) ?

Best regards,
Luca

---

Reply to this email directly or view it on GitHub:

#2 (comment)

[mcintyre321]

I'm going to close this as I think it is caused by Linq To Entities not handling .ToString() operators