Mid LINQ

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.

More from LINQ Tutorial

All questions for this course