LINQ: Add RowNumber Column

by

Use the method-syntax where Enumerable.Select has an overload with the index:

var myResult = someTable.Select((r, i) => new { Row = r, Index = i })
    .Where(x => x.Row.someCategory == someCategoryValue)
    .OrderByDescending(x => x.Row.createdDate);

Note that this approach presumes that you want the original index of the row in the table and not in the filtered result since i select the index before i filter with Where.

EDIT: I’m looking for the results to be {idx, col1, col2…col-n} not
{idx, row}. The row number should correspond to result rows not
the table rows.

Then select the anonymous type with all columns you need:

var myResult = someTable.Where(r => r.someCategory == someCategoryValue)
        .OrderByDescending(r => r.createdDate)
        .Select((r, i) => new { idx = i, col1 = r.col1, col2 = r.col2, ...col-n = r.ColN });

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. Extension methods must be defined in a non-generic static class
  11. Func with out parameter
  12. LINQ: Not Any vs All Don’t
  13. How to check if IEnumerable is null or empty?
  14. C# – code to order by a property using the property name as a string [duplicate]
  15. Can I specify my explicit type comparator inline?
  16. What is the Efficiency and Performance of LINQ and Lambda Expression in .Net?
  17. LINQ Inner-Join vs Left-Join
  18. DISTINCT() and ORDERBY issue
  19. Can I split an IEnumerable into two by a boolean criteria without two queries?
  20. Can I LINQ a JSON?
  21. Find substring in a list of strings
  22. Remove Item in Dictionary based on Value
  23. How to sort a dictionary by key
  24. How does PredicateBuilder work
  25. Issues Doing a String Comparison in LINQ
  26. Keep Getting ‘The LINQ expression node type ‘Invoke’ is not supported in LINQ to Entities’ Exception
  27. LINQ Using Max() to select a single row
  28. Should the order of LINQ query clauses affect Entity Framework performance?
  29. Map two lists into a dictionary in C#
  30. Can I use Linq’s Except() with a lambda expression comparer?

Leave a Comment