title: Select 'N' rows and get number of rows using Entity Framework
body: <p>Currently we have a page where we need pagination so for that i need 2 info <br>
      1. Get total number of rows <BR>
      2. Fetch 'N' number of rows<br></p>
  
  <p>Currently i am doing it with 2 query, for step 1 something like <br></p>
  
  <pre><code> count = db.Transactions
             .AsNoTracking()
             .Where(whereClause
             .Count();
  </code></pre>
  
  <p>And then <br></p>
  
  <pre><code>db.Transactions
             .AsNoTracking()
             .Where(whereClause
             .Skip(skipRows)
             .Take(pagesize)
             .ToList();
  </code></pre>
  
  <p>Is there is any way to optimize it?</p>