I got error message when I called Stored Procedures "GetCustOutstanding" from Web API and want to send data to kendo grid. How can I fix that? Thanks.
Error message: "The result of a query cannot be enumerated more than once."
IQueryable<GetCustOutstanding_Result> result = db.GetCustOutstanding().OrderBy(x=>x.NetDay).AsQueryable();
return result.ToDataSourceResult(request.Take, request.Skip, request.Sort, request.Filter); <=== error in this line
3 Answers, 1 is accepted
Hello,
Please refer to the Grid Read Error: The Result of the Query cannot be enumerated more than once Error, where same problem is discussed and a solution is provided.
Regards,Boyan Dimitrov
Telerik by Progress
Rank 1
When I change the IQueryable to ToList(), I cannot compile because it said the result does not contain a definition of ToDataSourceResult and no extension method. What did I miss? Thanks.
DataSourceRequest request = JsonConvert.DeserializeObject<DataSourceRequest>(
requestMessage.RequestUri.ParseQueryString().GetKey(0)
);
List<GetCustOutstanding_Result> result = db.GetCustOutstanding().OrderBy(x=>x.NetDay).ToList();
return result.ToDataSourceResult(request.Take, request.Skip, request.Sort, request.Filter); <=== cannot compile here
Hello Bertha,
To use the ToDataSourceResult extension method you need to import the Kendo.Mvc.Extensions namespace. Could you please check whether this namespace is added in your controller?
Regards,Boyan Dimitrov
Telerik by Progress