Grid Read Error: The Result of the Query cannot be enumerated more than once Error

[Bob]

I have a  Grid read method that throws this error on the ToDataSourceResult line at the bottom.   
The context.Search_All method is a SQL Stored Procedure in the context object.    

Any suggestions?
             
  public ActionResult Search_Read([DataSourceRequest]DataSourceRequest request, SearchInputModel input)
        {
            var username = _identityService.UserID;
            using (var context = new eEntities.eWJB())
            {
                context.Configuration.ProxyCreationEnabled = false;

                
                IQueryable search = context.Search_All("a", "b", "c", "d", "1", true)
              .AsQueryable()    
              .Select( item => new SearchResultModel
                                      {
                                          ID1 = item.ID1,
                                          ID2 = item.ID2,
                                          1D3 = item.ID3,
                                          Name= item.Name,
                                          Name2= item.Name2});
                var result = search.ToDataSourceResult(request);        <--- Error Here
          
                return Json(result, JsonRequestBehavior.AllowGet);
            }

        }
          

[Jayesh Goyani]

Hello,

Please use ToList() in place of IQueryable.

var search = context.Search_All("a", "b", "c", "d", "1", true)

             .ToList()  

             .Select( item => new SearchResultModel

                                     {

                                         ID1 = item.ID1,

                                         ID2 = item.ID2,

                                         1D3 = item.ID3,

                                         Name= item.Name,

                                         Name2= item.Name2}).ToList();

//OR Name2= item.Name2});




Note : We can not usedc cached query more than once in linq.


Thanks,
Jayesh Goyani

[Bob]

Thanks - I cannot get the JSON passed via jquery to the Search/Read Controller

var dataSource = new kendo.data.DataSource({    // create datasource
        transport: {
            read:  {
                url: "/Search/Search_Read",
                dataType: "json",
                data: data,
                contentType: "application/json; charset=utf-8"

            }
        }
This code hits the correct controller and the data element is correctly formatted JSON (I have tested it)...  But when this hits the controller the data is null.

Any suggestions?

[Daniel]

Hello,

You should use a POST request when sending JSON:

read:  {
    url: "/Search/Search_Read",
    type: "POST",
    dataType: "json",
    data: data,
    contentType: "application/json; charset=utf-8"
}

Regards,
Daniel
Telerik