title: How to get all entries from the database table using Take and Skip methods?
body: <p>In our current application we have following functionality in Data layer:</p>
  <pre><code>public IEnumerable&lt;User&gt; GetUsers(IPagedAndFilteredAndSortedRequest request)
  {
      var users = dbContext.Users;
      //1) &quot;filteredAndSorted&quot; is a result of applying filters and sorts on users
      //2) &quot;filteredAndSorted&quot; is OrderedQueriable
      //3) &quot;rows&quot; is number of rows to skip based on request.PageSize and request.PageNumber
      var result = filteredAndSorted.Skip(rows).Take(request.PageSize);
      return result.ToArray();
  }
  </code></pre>
  <p>And we need to get <strong>all</strong> users from the database using <strong>this method</strong>. So, the questions are:</p>
  <ol>
  <li>Is it a good idea to pass 1 as <strong>pageNumber</strong> and Int32.MaxValue as <strong>pageSize</strong>?</li>
  <li>What is the maximum number of rows in MSSQL database table?</li>
  </ol>