Filtering datagrid for T-SQL

Hi guys,

I need to filter datagrid server-side using ORM Dapper, or RAW SQL,

however the datagrid LoadDataArgs returns me in a standard that would be used by the entity only, is there any way to convert the datagrid filter to T-SQL, so I can add it to my query

Hi @Maasaki,

Usually this is done by the query provider of the IQueryble. If your ORM mapper supports IQueryble like Entity Framework everything will work automatically. There is no built-in way to get the raw SQL from LoadData event argument since it is different for every database.

Hi @enchev

It can be a point of improvement, an option to pass a literal.