This is a migrated thread and some comments may be shown as answers.

Server implementation of kendo grid server paging, filtering and sorting

3 Answers 285 Views
Grid
This is a migrated thread and some comments may be shown as answers.
Alex
Top achievements
Rank 1
Alex asked on 12 May 2015, 06:47 AM

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?

3 Answers, 1 is accepted

Sort by
0
Boyan Dimitrov
Telerik team
answered on 14 May 2015, 06:27 AM

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
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
0
Antony
Top achievements
Rank 1
Iron
answered on 07 May 2017, 12:21 PM

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.

0
Boyan Dimitrov
Telerik team
answered on 09 May 2017, 04:27 PM

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
Try our brand new, jQuery-free Angular 2 components built from ground-up which deliver the business app essential building blocks - a grid component, data visualization (charts) and form elements.
Tags
Grid
Asked by
Alex
Top achievements
Rank 1
Answers by
Boyan Dimitrov
Telerik team
Antony
Top achievements
Rank 1
Iron
Share this question
or