title: C# Entity Framework Pagination
body: <p>Is there a way to get the row count of a complex Linq query and millions of records <strong><em>without</em></strong> hitting the db twice or writing 2 separate queries??</p>
  
  <p>I might have my own suggestion. Write a stored procedure, but I'm good with MySQL not MSSQL. </p>
  
  <p>Any better suggestions would be great. Also, if anyone knows if Microsoft is working on adding this feature to the entity framework.</p>