CODEWITHSUNDEEP
linq
Vahid Ghadiri
Vahid Ghadiri

Reputation: 4076

Using Row_Number in Linq where clause

how can I simulate the following sql query using linq. I just want to have a Row_Number column and use it's values in linq where clause. 

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

Upvotes: 1

Views: 685

Answers (1)

Phill
Phill

Reputation: 18796

I think what you're trying to do is just Skip/Take, for paging.

So basically:

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

(Code is untested, written off the top of my head)

Upvotes: 1

Related Questions