Is there a way to get the row count of a complex Linq query and millions of records ...without... hitting the db twice or writing 2 separate queries??...I might have my own suggestion. Write a stored procedure, but I'm good with MySQL not MSSQL. ...Any be...