A Simple Pagination Helper With Metadata

Create a PagedResult class

public class PagedResult<T>
{
   public IEnumerable<T> Items { get; set; } = [];
   public string? SearchTerm { get; set; }
   public int TotalCount { get; set; }
   public int StartRecord => (CurrentPage - 1) * PageSize + 1;
   public int EndRecord => Math.Min(StartRecord + PageSize - 1, TotalCount);
   public int CurrentPage { get; set; }
   public int PageSize { get; set; }
   public int TotalPages => (int)Math.Ceiling((double)TotalCount / PageSize);
   public bool HasPreviousPage => CurrentPage > 1;
   public bool HasNextPage => CurrentPage < TotalPages;
}

Create the pagination helper class with the pagination method

public static class Pagination
{
   public static async Task<PagedResult<T>> PaginateAsync<T>(
       this IQueryable<T> query,
       int pageNumber = 1,
       int pageSize = 10)
       where T : class
   {
       var result = new PagedResult<T>
       {
           CurrentPage = pageNumber,
           PageSize = pageSize,
           TotalCount = await query.CountAsync(),
           Items = await query
           .Skip((pageNumber - 1) * pageSize)
           .Take(pageSize)
           .ToListAsync()
       };
       return result;
   }
}

Then you use it as such (assuming you've already filtered and sorted your data)

var response = await query.PaginateAsync(pageNumber, pageSize);

Easy peasy.