Server implementation of kendo grid server paging, filtering and sorting

4 posts, 0 answers
  1. Alex
    Alex avatar
    1 posts
    Member since:
    Sep 2008

    Posted 12 May 2015 Link to this post


    I'm building SPA using kendo ui and angularjs for client-side and 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, so I should generate sql queries on the fly.

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

  2. Boyan Dimitrov
    Boyan Dimitrov avatar
    2062 posts

    Posted 14 May 2015 Link to this post

    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

    Boyan Dimitrov
    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
  3. Antony
    Antony avatar
    15 posts
    Member since:
    Jan 2012

    Posted 07 May 2017 in reply to Alex Link to this post

    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.

  4. Boyan Dimitrov
    Boyan Dimitrov avatar
    2062 posts

    Posted 09 May 2017 Link to this post

    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. 

    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.
Back to Top