Paging library for . Net Core

Question

I’ve worked on some frameworks like Spring and Nestjs, and there I worked with a library that listed a query page.

Here at . Net Core, I have to create a method to work with it. For example:

public PagedSearchDTO<PersonVO> FindWithPagedSearch(string name, string sortDirection, int pageSize, int page)
        {

            page = page > 0 ? page - 1 : 0;
            string query = @"select * from persons p where 1 = 1 ";
            if (!string.IsNullOrEmpty(name)) query = query + $"and p.firstname like '%{name}%' ";

            query = query + $" order by p.firstname {sortDirection} limit {pageSize} offset {page}";

            string countQuery = @"select count(*) from persons p where 1 = 1 ";
            if (!string.IsNullOrEmpty(name)) countQuery = countQuery + $" and p.name like '%{name}%' ";

            var persons = _repository.FindWithPagedSearch(query);

            int totalResults = _repository.GetCount(countQuery);

            return new PagedSearchDTO<PersonVO>
            {
                CurrentPage = page + 1,
                List = _converter.ParseList(persons),
                PageSize = pageSize,
                SortDirections = sortDirection,
                TotalResults = totalResults
            };
        }

I would like to know if there is already a library, preferably official language, that works with this paging logic?

Answer 1

There is no no official library making pagination.

There are Nuget packages that do this like the AspNetCore.Mvc.Paging You can search for other packages on the site https://www.nuget.org/

In the official documentation there is a tutorial on paging if you want to do it yourself.