I am unable to find where this property would apply in the helper. 

I would guess, that it will look like this: .CaseSensitiveFilter(true)

I tried various spots and can't find where it would belong - nothing in the documentation as well. 

@(Html.Kendo().Grid<MyViewModel>()
          .Name("grid")
          .Columns(columns =>
          {
              columns.Bound(model => model.id).Title("ID").Width(65).MinScreenWidth(769);
              columns.Bound(model => model.username).Width(125);
          })
          .DataSource(dataSource => dataSource
                .Ajax()
                .Read(read => read.Action("MyController"), "EventLogs"))
            )
            )
    )

Great news that it made the release - where is the change documented - how do we configure the case-sensitive option?

This is great news - we have been waiting diligently for this improvement. Please reach out if you need beta testing. 

Hi, when can we expect a release date for this feature ? 

 

Best Regards

This one is an issue for 1 of the projects I'm working on too so I hope this functionality is added soon. It would be great if we are able to execute a predicate on the queryable before determining what the behavior for the current filtering should be because we are using 2 DBs and for 1 of them the current behavior is beneficial for us but for the other one it introduces performance issues. A setting like `Func<IQueryableProvider, bool>` when configuring Kendo services in DI container would best match our usages.

Hi Eyup,

 

I really appreciate that. A solution for this long-standing issue would significantly improve the performance of our application and would allow us to use Telerik Grids more often.

Thanks!

 

Holger

Can we have an update on this topic please? It is a huge performance issue and our DBAs want to stop using KendoUI for this problem.

I ended up writing custom filters for the DataSourceRequest that apply LINQ where clauses to the IQueryable. These are applied to the IQueryable prior to ToDataSourceResult(). Basically I do all the filtering and leave the pagination to ToDataSourceResult(). 

My filters do not cover all the filter options that DataSourceRequest has available, but as my use case is limited that approach worked for me. 

Since this is still a workaround I would still appreciate this to be patched by Telerik. 

@Holger

Were you able to implement a workaround? I looked for an example of the method you referred to, but could not find anything.

I would also appreciate a fix, but I also really need a workaround if it exists.

It appears that "IgnoreCase" is only implemented for client-side filtering. Server-side filtering uses ToDataSourceResult() and the case filtering flag is not passed through in DataSourceRequest. As stated in other comments this has a severe impact on query performance as the database will not use indexes if comparisons are wrapped in LOWER() functions in the generated SQL. 

Especially for databases that are case insensitive, this is completely unnecessary. 

A possible approach would be to add a global flag to ToDataSourceResult() to indicate that the database is case insensitive and the TOLOWER() wrapper should not be generated. 

I am aware of the workaround to implement filtering server-side manually, but that takes away from the simplicity a framework should deliver. 

Given that this issue has been out there for years and reported multiple times a fix would be very much appreciated. 

This has been brought up in ticket 1339310 and in feedback request: https://feedback.telerik.com/kendo-jquery-ui/1360465-todatasourceresult-avoid-casting-to-lower-to-enable-index-use-in-database

Please reconsider this item - to provide an opt-out for the case-insensitive lower expression so that indexes can be leveraged on SQL string fields.

I Agree, huge performance decrease on large SQL tables! Please fix asap

I am agreeing with the rest of the comments, there is a lack of regard to the optimisation of the query being performed against the database, database developers and API developers go to great lengths to ensure case sensitive on models, databases and columns and then the Kendo library decides to lower everything causing our indexes to be worthless.

This has a huge performance impact on large tables as the SQL ToLower prevents the database from using the index. 

This really should be implemented. Adding the ToLower() calls to databases that are already case insensitive is a huge performance decrease.