I´m using Entity Framework 6 and I have a table with 2000 > rows.
The Grid component doesn´t have OnDemand option yet, then looking for in this forum I found the solution using DataManager (post http://www.syncfusion.com/forums/118301/grid-performance-in-ie)
Meanwhile, I would like to use search instead filtering, then I change the code like this:
//Provide grid datasource
public ActionResult GetOrderData(DataManager dm)
{
RuasModel ruas = new RuasModel();
IEnumerable data = ruas.ListaRuas();
int count = ruas.ListaRuas().Count;
DataOperations operation = new DataOperations();
//Performing filtering operation
if (dm.Where != null)
{
data = operation.PerformWhereFilter(data, dm.Where, "and");
var filtered = (IEnumerable<object>)data;
count = filtered.Count();
}
if (dm.Search != null)
{
data = operation.PerformSearching(data, dm.Search);
}
//Performing sorting operation
if (dm.Sorted != null)
data = operation.PerformSorting(data, dm.Sorted);
//Performing paging operations
data = operation.PerformSkip(data, dm.Skip);
data = operation.PerformTake(data, dm.Take);
return Json(new { result = data, count = count }, JsonRequestBehavior.AllowGet);
}
but when make a search the data object always returns null. Using the Visual Studio debug, the dm.Search is not null.
Is there a option to do this?
Thank you
