How do I add ROW_NUMBER to a LINQ query or Entity?

by

Use the indexed overload of Select:

var start = page * rowsPerPage;
Products.OrderByDescending(u => u.Sales.Count())
    .Skip(start)
    .Take(rowsPerPage)
    .AsEnumerable()
    .Select((u, index) => new { Product = u, Index = index + start });

More Related Contents:

  1. thread messaging system database schema design
  2. How to click in imagelink in gridview and go to another gridview
  3. MVC3 and Entity Framework
  4. ASP.NET Identity DbContext confusion
  5. How can I force entity framework to insert identity columns?
  6. How to “warm-up” Entity Framework? When does it get “cold”?
  7. How and where to call Database.EnsureCreated and Database.Migrate?
  8. The result of a query cannot be enumerated more than once
  9. Entity Framework: how to solve “FOREIGN KEY constraint may cause cycles or multiple cascade paths”?
  10. How to warm up an ASP.NET MVC application on IIS 7.5?
  11. “The LINQ expression node type ‘Invoke’ is not supported in LINQ to Entities” – stumped!
  12. The type initializer for ‘System.Data.Entity.Internal.AppConfig’ threw an exception
  13. It has a DefiningQuery but no InsertFunction element… err
  14. Linq Orderby random ThreadSafe for use in ASP.NET
  15. Entity Framework 4 – Update database schema from model. Without wiping the table data
  16. Entity framework context as static
  17. Unable to Retrieve Metadata
  18. Difference between DropDownlist or DropDownListFor Html helper
  19. Unit-testing .ToListAsync() using an in-memory
  20. Unable to create an object of type ‘[DBContext’s Name]’. For the different patterns supported at design time [closed]
  21. Entity Framework v2 doesn’t support sql 2000?
  22. LINQ to SQL Web Application Best Practices
  23. Can some hacker steal a web browser cookie from a user and login with that name on a web site?
  24. Is trying to develop for Medium Trust a lost cause?
  25. jqGrid: using multiple methods to filter data
  26. Does ASP.NET Web Forms prevent a double click submission?
  27. Elmah not working with asp.net site
  28. How to access your website through LAN in ASP.NET [closed]
  29. ASP.NET Image uploading with Resizing
  30. Is there an #IF DEBUG for Asp.net markup?

Leave a Comment