Thanks for the answer, I was examining your sample, first thing the Kendo reference was missing, so I added this one 2016.1.226.440, and the problem still appear.
I attached some pics that will show you the result.
By the way on my solution, I got the data be display on the grid, by changing the ActionResult to JsonResult on the controller, like this
public Json LoadProducts([DataSourceRequest]DataSourceRequest request)
clsData cns = new clsData();
IQueryable<consultProducts> s2 = cns.getProducts().ToList().AsQueryable();
DataSourceResult result = s2.ToDataSourceResult(request, p => new Products
return Json(result, JsonRequestBehavior.AllowGet);
Also I'm rendering this js files
But the result is not the efficient enough that I expect, I will continue doing test and let you know.
Have a nice day.!