title: Linq to Entities Skip() and Take()
body: <p>I am working on an ASP.NET application and I am creating a LINQ query which will select paginated records from db. on user interface I have a listbox where user can select multiple choices. I want to know:</p>
  
  <ul>
  <li><p>How can I increment Skip(), Take() parameters to view next results ?</p></li>
  <li><p>How can I use "IN" key word so that if user selects multiple options from listbox, query can check all values ?</p></li>
  </ul>
  
  <p>My query looks like this:</p>
  
  <pre><code>var searchResults = context.data_vault.Where(d =&gt; d.STATE == lstStates.SelectedItem.Text).OrderBy(d= &gt; d.dv_id).Take(10).Skip(2);    
  GridView1.DataSource = searchResults;
  GridView1.DataBind();
  </code></pre>