title: How do I translate a query that uses ROW_NUMBER() into linq?
body: <p>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:</p>
  
  <pre class="lang-sql prettyprint-override"><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)
  </code></pre>
  
  <p>Note, pageindex is the variable that takes some integer value which is passed by the user.</p>
  
  <p>My database is Sql Server 2008. I want to write the same query using Linq. How do I do that?</p>