How to implement pagination with total count using LINQ?

Short answer: .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. int pageNumber = 1;

Example code

int pageSize = 3;
var totalCount = employees.Count();
var pageData = employees

Real-world example (ShopNest)

ShopNest uses LINQ to query orders: filter by date, project to a summary DTO, and order by total—readable C# that becomes SQL under EF Core.

Say this in the interview

1. Define — one clear sentence (the short answer above).
2. Example — relate it to a project like ShopNest or your real work.
3. Trade-off — when you would not use it.