title: LINQ: Paging technique, using take and skip but need total records also - how to implement this?
body: <p>I have implemented a paging routine using skip and take. It works great, but I need the total number of records in the table prior to calling Take and Skip.</p>
  
  <p>I know I can submit 2 separate queries. </p>
  
  <ol>
  <li>Get Count </li>
  <li>Skip and Take</li>
  </ol>
  
  <p>But I would prefer not to issue 2 calls to LINQ.</p>
  
  <p>How can I return it in the same query (e.g. using a nested select statement)?</p>
  
  <p>Previously, I used a paging technique in a stored procedure. I returned the items by using a temporary table, and I passed the count to an output parameter.</p>