Maars.Pagination 1.0.3

Pagination

Pagination package for .net core application to do auto pagintation on SQL/Any Queriers from Entity framework

Pagination

Defult Pagination page->1 perPage->25

format query string in the format of

http://localhost/products?perpage=10& page=2

Setup in .net core Starupt

services.AddMvc(config =>
{
    config.Filters.Add(typeof(PaginationFilter));
})          

Usage on entity framework Decorate controller

[HttpGet]
[SwaggerResponse((int)HttpStatusCode.OK, Type = typeof(IList<Standard>))]
public IActionResult GetStandards([FromQuery] PaginationParams paginationParams,
    SortingInfo sortingInfo)
{
    var list = Service.GetList(paginationParams, sortingInfo);
    return Ok(list);
}

Decorate in Service Ensure Extensions included : using Maars.Pagination.Extensions;

public override IEnumerable<Standard> GetList(PaginationParams paginationParams, SortingInfo sortingInfo)
{
	var query = Context.Standard.GetList(paginationParams).IncludeOrderBy(sortingInfo)
		.AsNoTracking();
	return query;
}

Result in headers

Link →<http://localhost:3991/standards?perpage=10&page=1&per_page=10>; rel="first",<http://localhost:3991/standards?perpage=10&page=1&per_page=10>; rel="prev",<http://localhost:3991/standards?perpage=10&page=1&per_page=10>; rel="last"
X-Page →2        : Current page
X-Per-Page →10   : Per page displayed 10 records
X-Total-Count →7 : Total records in table for the query
X-Total-Pages →1 : Total Pages (TotalRecords/PerPage)