KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
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?
Tags (comma-separated)
Save Edits
Cancel