DataGrid - Is it possible to use a case-insensitive filter if DevExtreme.AspNet.Data is used

Hello Uriah!

Thanks for your answer. This is that I've implemented:

First, I added DevExpress.Data (18.2.6) in order to set "DevExpress.Data.Helpers.ServerModeCore.DefaultForceCaseInsensitiveForAnySource = true;" (cause I didn't found on DevExtreme.AspNet.Data) in Main()  (Program.cs). So these are my dependencies:

DevExpress.Data.es (18.2.6)
DevExtreme.AspNet.Core (18.2.5)
DevExtreme.AspNet.Data (2.1.1)

And this is my grid config:

C#
Html.DevExtreme().DataGrid()  
    .ID(this.ClientId);  

    .DataSource(ds => ds.WebApi()  
    .Controller(this.Controller)  
    .LoadAction(this.Action)  
    .Key(this.Key))  
    .Columns(  
      columns =>  
      {  
        foreach (var itemModel in this.DataModel)  
          {  
              columns.Add()  
             .DataField(data?.ToString() ?? "")  
             .DataType(Enum.Parse<GridColumnDataType>(resultado))  
             .Caption(textResource);  
          }  
        }  
    .Selection(s => s.Mode(SelectionMode.Single))  
          .OnInitialized("gridInitialized")  
          .OnRowClick("rowClicked")  
          .Paging(p => p.PageSize(10))  
          .FilterRow(f => f.Visible(true))  
          .HeaderFilter(f => f.Visible(true))  
          .AllowColumnReordering(true)  
          .RowAlternationEnabled(true)  
          .ShowBorders(true)  
          .GroupPanel(p => p.Visible(true))  
          .Export(e => e.Enabled(true).FileName(DateTime.Now.ToString("yyyy-mm-dd_HH.mm.ss") + "_TE ST").AllowExportSelectedData(false))  
          .ColumnHidingEnabled(true)  
          .ColumnAutoWidth(true)  
          .SearchPanel(d => d.Visible(true));  

This Grid is generated dynamicly and send to view.

Maybe, I forget something?

Thank you so much for your help.

(I forget comment that we are using EF storage)

Thank you for the clarification. The DevExpress.Data assembly does not extend the third party components functionality. The ServerModeCore.DefaultForceCaseInsensitiveForAnySource option is in effect only for specific data sources implemented in the DevExpress.Data library.

I modified the ticket description and passed it to the DevExtreme team. Please await the final response from them.