LINQ and pagination [duplicate]

by

I always use the following code:

public static class PagingExtensions
{
    //used by LINQ to SQL
    public static IQueryable<TSource> Page<TSource>(this IQueryable<TSource> source, int page, int pageSize)
    {
        return source.Skip((page - 1) * pageSize).Take(pageSize);
    }

    //used by LINQ
    public static IEnumerable<TSource> Page<TSource>(this IEnumerable<TSource> source, int page, int pageSize)
    {
        return source.Skip((page - 1) * pageSize).Take(pageSize);
    }

}

That is a static class, which you can include in your sources.
After adding this class you can do the following:

MyQuery.Page(pageNumber, pageSize)

More Related Contents:

  1. Returning IEnumerable vs. IQueryable
  2. What is the syntax for an inner join in LINQ to SQL?
  3. Difference Between Select and SelectMany
  4. Random row from Linq to Sql
  5. LINQ to SQL: Multiple joins ON multiple Columns. Is this possible?
  6. Linq – left join on multiple (OR) conditions
  7. LINQ to SQL and a running total on ordered results
  8. Understanding .AsEnumerable() in LINQ to SQL
  9. How to compare only Date without Time in DateTime types in Linq to SQL with Entity Framework?
  10. LINQ Left Join And Right Join
  11. How to return anonymous type from c# method that uses LINQ to SQL [duplicate]
  12. Compare nullable types in Linq to Sql
  13. Updating an ObservableCollection in a separate thread
  14. Convert Linq Query Result to Dictionary
  15. Am I misunderstanding LINQ to SQL .AsEnumerable()?
  16. LINQ Where Ignore Accentuation and Case
  17. Get table-data from table-name in LINQ DataContext
  18. DISTINCT() and ORDERBY issue
  19. Linq query with nullable sum
  20. C# LINQ to SQL: Refactoring this Generic GetByID method
  21. LINQ to SQL using GROUP BY and COUNT(DISTINCT)
  22. How to make LINQ execute a (SQL) LIKE range search
  23. Will using LINQ to SQL help prevent SQL injection
  24. Last and LastOrDefault not supported
  25. Multiple/single instance of Linq to SQL DataContext
  26. Linq “Could not translate expression… into SQL and could not treat it as a local expression.”
  27. Is it possible to use SqlGeography with Linq to Sql?
  28. Attribute.IsDefined doesn’t see attributes applied with MetadataType class
  29. LINQ to SQL Where Clause Optional Criteria
  30. Linq where column == (null reference) not the same as column == null

Leave a Comment