How to implement pagination with total count using LINQ?
How to implement pagination with total count using LINQ?
int pageNumber = 1;
Follow :
int pageSize = 3;
var totalCount = employees.Count();
var pageData = employees
.OrderBy(e => e.Id)
.Skip((pageNumber - 1) * pageSize)
.Take(pageSize)
.ToList();
Console.WriteLine($"Total Employees: {totalCount}");
foreach(var emp in pageData)
Console.WriteLine($"{emp.Name} - {emp.Department}");
Explanation:
You get total count separately and then take the required page using Skip and Take.