Pagination for EF queries

Paginate.cs

const int batchSize = 50;

async Task Paginate<TEntity>(DbSet<TEntity> dbSet,
                             Func<int, CancellationToken, Task> action,
                             CancellationToken cancellationToken = default) where TEntity : class {
    var count = await dbSet.CountAsync(cancellationToken);
    var remain = count;
    while(remain > 0) {
        logger.LogInformation($"Processing {batchSize} of {remain} items...");
        await action(skip: count - remain, cancellationToken);
        remain -= batchSize;
    }
}