Pagination for huge amount of data and best practiced in .NET core
1) Why keyset/seek (a.k.a. cursor) beats OFFSET/FETCH
How to implement pagination and filtering by stable ordering, keyset/seek pagination for large data; exposing pageToken or continuationToken and v