Server implementation of kendo grid server paging, filtering and sorting

[Alex]

Hi,

I'm building SPA using kendo ui and angularjs for client-side and asp.net web api for server-side. Customer wants server paging, filtering and sorting in grids. I know, how to configure kendo grid, so I only need to implement it on my server.

I found solution to use .ToDataSourceResult() with the DataSourceRequest parameter, but the problem is that I'm not using entity framework for all db stuff - the requirement is to use dapper https://github.com/StackExchange/dapper-dot-net, so I should generate sql queries on the fly.

Are there some code samples or even already written components for this scenario?

[Boyan Dimitrov]

Hello Alex,

Please note that the .ToDataSourceResult() will not work only with ORM ( Entity Framework for example) but it works with any IQueryable or IEnumerable so LINQ, List, Dictionary, etc…

Please refer to this blog post that demonstrates an example with a sample List. 

Regards,
Boyan Dimitrov
Telerik

[Antony]

Hi Alex

I'm having success with my move from WebForms to MVC/Kendo by using the KISS approach - using Dapper and SQL rather than the more complex Entity Framework and LINQ. I've posted more details here about using Dapper with the MVC Kendo grid.

[Boyan Dimitrov]

Hello Anthony,

Thank you for sharing your solution with the community. I am sure that someone will find it useful and use it during the migration process. 

Regards,
Boyan Dimitrov
Telerik by Progress