Implement the PaginateViaPrimaryKey and SortByPrimaryKey methods analogous to DevExtreme’s implementation.

[ycherkes]

Details

DevExpress can paginate and sort results by primary key, transforming the typical two-step process (count + page retrieval) into a three-step one (count + ID retrieval + page retrieval). By first fetching only the primary-key IDs and then loading the actual records for the requested page, it can significantly reduce the workload on complex or resource-intensive queries.