Using Row_Number in Linq where clause

Question

how can i simulate the following sql query using linq. I just want to have a Row_Number column and use it in the linq where expression.

With t As (
    Select Row_Number() over ( Order by Id ) as 'RowId', * From Orders
) 
Select * From t Where RowId between 1 and 10

+1

Vahid ghadiri Jul 13 '11 at 6:59

1 answer

Phill · Accepted Answer · 2011-07-13T07:02:25+0000

I think that you are trying to do this simply by Skip / Take, for paging.

So basically:

var result = dataContext.Products.Skip(0).Take(10).ToList();

(The code is untested, decommissioned from my head)