Paging with LINQ for objects

by

You’re looking for the Skip and Take extension methods. Skip moves past the first N elements in the result, returning the remainder; Take returns the first N elements in the result, dropping any remaining elements.

See MSDN for more information on how to use these methods: http://msdn.microsoft.com/en-us/library/bb386988.aspx

Assuming you are already taking into account that the pageNumber should start at 0 (decrease per 1 as suggested in the comments) You could do it like this:

int numberOfObjectsPerPage = 10;
var queryResultPage = queryResult
  .Skip(numberOfObjectsPerPage * pageNumber)
  .Take(numberOfObjectsPerPage);

Otherwise if pageNumber is 1-based (as suggested by @Alvin)

int numberOfObjectsPerPage = 10;
var queryResultPage = queryResult
  .Skip(numberOfObjectsPerPage * (pageNumber - 1))
  .Take(numberOfObjectsPerPage);

More Related Contents:

  1. Linq: help me to make this work
  2. Get all checked nodes of a treeview
  3. How to flatten tree via LINQ?
  4. When to use .First and when to use .FirstOrDefault with LINQ?
  5. Using LINQ to remove elements from a List
  6. printing all contents of array in C#
  7. What guarantees are there on the run-time complexity (Big-O) of LINQ methods?
  8. Convert string[] to int[] in one line of code using LINQ
  9. LINQ – Left Join, Group By, and Count
  10. Func with out parameter
  11. How to get the index of an element in an IEnumerable?
  12. LINQ: Not Any vs All Don’t
  13. How to check if IEnumerable is null or empty?
  14. What is the Efficiency and Performance of LINQ and Lambda Expression in .Net?
  15. LINQ Inner-Join vs Left-Join
  16. DISTINCT() and ORDERBY issue
  17. High memory consumption with Enumerable.Range?
  18. How to Get XML Node from XDocument
  19. Can I LINQ a JSON?
  20. Use linq to generate direct update without select
  21. Find substring in a list of strings
  22. Get List element position in c# using LINQ
  23. Linq – What is the quickest way to find out deferred execution or not?
  24. Linq style “For Each” [duplicate]
  25. How to sort a dictionary by key
  26. Issues Doing a String Comparison in LINQ
  27. Expressing recursion in LINQ
  28. C# Searching for files and folders except in certain folders
  29. Linq where column == (null reference) not the same as column == null
  30. Does “foreach” cause repeated Linq execution?

Leave a Comment