Modern C# and .NET Tutorial: Cross-Platform Basics/

...

/

Paging with LINQ

Paging with LINQ

Learn about implementing paging in LINQ using the extension methods with ordered data, and displaying a specific page of results from a dataset interactively.

We'll cover the following...

Implement paging using Skip and Take methods

Let’s see how we could implement paging using the Skip and Take extension methods:

Step 1: In Program.Functions.cs, add a method to output to the console a table of products passed as an array, as shown in the following code:

Press + to interact
static void OutputTableOfProducts(Product[] products,
 int currentPage, int totalPages)
{
  string line = new('-', count: 73);
  string lineHalf = new('-', count: 30);
  WriteLine(line);
  WriteLine("{0,4} {1,-40} {2,12} {3,-15}",
  "ID", "Product Name", "Unit Price", "Discontinued");
  WriteLine(line);
  foreach (Product p in products)
  {
    WriteLine("{0,4} {1,-40} {2,12:C} {3,-15}",
    p.ProductId, p.ProductName, p.UnitPrice, p.Discontinued);
  }
  WriteLine("{0} Page {1} of {2} {3}",
  lineHalf, currentPage + 1, totalPages + 1, lineHalf);
}

Note: As usual in computing, our code we will start counting from zero, so we need to add one to both the currentPage count and totalPages count before ...