Thank you for the provided screenshots.
Kendo offers a .ToDataSourceResult() extension that accepts IQueryable as an argument.
public ActionResult Read([DataSourceRequest] DataSourceRequest request)
DataTable dt = new DataTable();
Essentially what this would do is get the configurations applied to the DataSource such as PageSize, Groups, Filters and so on, and apply them to the DataTable View. It works in a similar way as to when you are using an IEnumerable for the data.
Let me know in case further assistance is required.
Virtual Classroom, the free self-paced technical training that gets you up to speed with Telerik and Kendo UI products quickly just got a fresh new look + new and improved content including a brand new Blazor course! Check it out at https://learn.telerik.com/.