How to implement service to apply pagination ?

See more:

ASP.NET5

C#7.0

ASP.NET-Core

, +

I work on blazor web application with .Net core 7. i face issue when implement service for get all items using pagination .

so on service my issue is can't return ListQueryResult when apply pagination for get all items .

my issue exactly on the following line of code on service

IQueryable<trecord> query = _context.ServerNames;

What I have tried:

pagination modules

 public  record ListQueryRequest
    {
        public int StartIndex { get; init; } = 0;
        public int PageSize { get; init; } = 1000;  //set at some maximum epected count for no paging
        public CancellationToken Cancellation { get; set; } = new();
    }
  public  record ListQueryResult<TRecord>
    {
        public IEnumerable<TRecord> Items { get; init; } = Enumerable.Empty<TRecord>();
        public bool Successful { get; init; }
        public string Message { get; init; } = string.Empty;
        public int TotalCount { get; init; }

        private ListQueryResult() { }

        public static ListQueryResult<TRecord> Success(IEnumerable<TRecord> Items, int totalCount, string? message = null)
            => new ListQueryResult<TRecord> { Successful = true, Items = Items, TotalCount = totalCount, Message = message ?? string.Empty };

        public static ListQueryResult<TRecord> Failure(string message)
            => new ListQueryResult<TRecord> { Message = message };
    }
on generic repository i implement as below :

public interface IRepository<TEntity> where TEntity : class
{
public ListQueryResult<TEntity> GetItems(ListQueryRequest request);
}
public class BaseRepository<TEntity> : IRepository<TEntity> where TEntity : class
{
    internal AppsRepositoryDBContext _context;
    internal DbSet<TEntity> dbSet;

    public BaseRepository(AppsRepositoryDBContext context)
    {
        _context = context;
        this.dbSet = _context.Set<TEntity>();
    }

    public ListQueryResult<TEntity> GetItems(ListQueryRequest request)
    {
        _context.ChangeTracker.QueryTrackingBehavior = QueryTrackingBehavior.NoTracking;
        IQueryable<TEntity> query = _context.Set<TEntity>();
        var count = query.CountAsync(request.Cancellation);
        query = query
            .Skip(request.StartIndex)
            .Take(request.PageSize);
        var list = query.ToList();
        return ListQueryResult<TEntity>.Success(list,Convert.ToInt32(count));
    }

}
here is issue implementing service

public interface IserverNamesService : IRepository<ServerNames>
    {

        ListQueryResult<ServerNames> GetItems(ListQueryRequest request);
    }
Block of code below Have issue when return ListQueryResult on first line .

    public ListQueryResult<ServerNames> GetItems(ListQueryRequest request)
    {
    // here i face issue implementing  service
        IQueryable<TRecord> query = _context.ServerNames;
        query = query
            .Skip(request.StartIndex)
            .Take(request.PageSize);

        query = query
               .Join(_context.ServerTypes,
               sn => sn.ServerTypeId,
               st => st.ServerTypeId,
               (sn, st) => new ServerNames
               {
                   ServerID = sn.ServerID,
                   server_Name = sn.server_Name,
                   ServerType = st.ServerType
               });

    
        var list = query.ToList();
        return list;
       
    }