My table consists of three columns (sno,name,age). I am retrieving this table from the database with extra column (row number) and I used the following code:
select * from (
select ROW_NUMBER() over (order by SNo asc)as rowindex,SNo,Name,Age
from tblExample)
as example where rowindex between ((pageindex*10)+1) and ((pageindex+1)*10)
Note, pageindex is the variable that takes some integer value which is passed by the user.
My database is Sql Server 2008. I want to write the same query using Linq. How do I do that?
See Question&Answers more detail:
os 与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…