We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. Image for the cookie policy date
close icon

DataManager Search

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

3 Replies

PK Prasanna Kumar Viswanathan Syncfusion Team March 9, 2015 12:09 PM UTC

Hi Sidnei,

Sorry about the inconvenience caused.

We created a sample using IEnumerable data and performing Datamanager operations. We afraid that we were unable to reproduce the issue at run time. Did the object returns null only for string values or all values? Because the searching is case sensitive for string values.

Are you facing that case sensitive issue or any other issues?

Please download the sample from the below link:

Sample Link: http://www.syncfusion.com/downloads/support/directtrac/118425/RemoteServerAdaptorSample_129241-818803486.zip

If we misunderstood your query, please provide a simple sample for us or make this one as issue reproducible sample, we are happy to assist you.

Please let me know if you have any concerns.

With Regards,

Prasanna Kumar N.S.V

SV Sidnei V Lavandoski March 9, 2015 11:47 PM UTC

Hi Prasanna, thank you by your quick assistance!

In fact, the problem was case sensitive, you are correct.

Is there a way to ignore the case sensitive in the search?

Thank you again.

PK Prasanna Kumar Viswanathan Syncfusion Team March 10, 2015 05:06 PM UTC

Hi Sidnei,

We considered this requirement “Searching is case sensitive using DataManager Operations” as a bug and a support incident has been created under your account to track the status of this requirement. Please log on to our support website to check for further updates.



Prasanna Kumar N.S.V

Live Chat Icon For mobile
Up arrow icon