Entity Framework/Linq to SQL: Skip & Take

by

The following works and accomplishes the simplicity I was looking for:

public IEnumerable<Store> ListStores(Expression<Func<Store, string>> sort, bool desc, int page, int pageSize, out int totalRecords)
{
    List<Store> stores = new List<Store>();
    using (var context = new TectonicEntities())
    {
        totalRecords = context.Stores.Count();
        int skipRows = (page - 1) * pageSize;
        if (desc)
            stores = context.Stores.OrderByDescending(sort).Skip(skipRows).Take(pageSize).ToList();
        else
            stores = context.Stores.OrderBy(sort).Skip(skipRows).Take(pageSize).ToList();
    }
    return stores;
}

The main thing that fixed it for me was changing the Func sort parameter to:

Expression<Func<Store, string>> sort

More Related Contents:

  1. Entity Framework/SQL2008 – How to Automatically Update LastModified fields for Entities?
  2. A dependent property in a ReferentialConstraint is mapped to a store-generated column
  3. What is the syntax for an inner join in LINQ to SQL?
  4. Random row from Linq to Sql
  5. LINQ to Entities case sensitive comparison
  6. To return IQueryable or not return IQueryable [closed]
  7. How to compare only Date without Time in DateTime types in Linq to SQL with Entity Framework?
  8. Updating an ObservableCollection in a separate thread
  9. Metadata were not loaded using MetadataType
  10. Am I misunderstanding LINQ to SQL .AsEnumerable()?
  11. LINQ Where Ignore Accentuation and Case
  12. DISTINCT() and ORDERBY issue
  13. Why re-initiate the DbContext when using the Entity Framework?
  14. Exclude a field/property from the database with Entity Framework 4 & Code-First
  15. Internal .NET Framework Data Provider error 1025
  16. Syncing SQL Server 2008 Databases over HTTP using WCF & Sync Framework
  17. Polymorphism: Is ORM entity a Domain Entity or Data Entity?
  18. Entity Framework Code Only error: the model backing the context has changed since the database was created
  19. Max or Default?
  20. How do I do a left outer join with Dynamic Linq?
  21. Best way to update LINQ to SQL classes after database schema change
  22. Entity Framework Code First AddOrUpdate method insert Duplicate values
  23. Last and LastOrDefault not supported
  24. Passing datatable to a stored procedure
  25. Change db table name in EF4 (entity framework 4)
  26. Entity Framework Multiple Object Contexts
  27. 3 Digit currency code to currency symbol
  28. The principal end of this association must be explicitly configured using either the relationship fluent API or data annotations
  29. Repository Pattern, POCO, and Business Entities
  30. IDENTITY INSERT and LINQ to SQL

Leave a Comment