สอบถามการ Query ข้อมูล 5 แสน record ออกมาเป็น Excel

int CurrentPagenumber = 1;
int Checkloop = 50000;
int temp = (CurrentPagenumber - 1) * Checkloopa;
var query = db.page.OrderBy(o => o.datetime).Skip(temp).Take(Checkloop).ToArray();

var fileInfo = new FileInfo(Path.GetTempPath() + "\\" + DateTime.Now.ToString("yyyyMMdd") + ".xlsx");  
while(true)
{
if (query.Count() > 0)
{
     break;
}

using (var excel = new ExcelPackage(fileInfo))
{
     excel.Workbook.Properties.Author = "Report"; 
     excel.Workbook.Properties.Title = "Export Realtime";
     var sheet = excel.Workbook.Worksheets.Add("page"+i);
     sheet.Cells[1, 1].LoadFromCollection(query, true);
     workSheet.Cells["A:A"].Style.Numberformat.Format = "yyyy-mm-dd HH:mm:ss";
     workSheet.Cells["A:F"].AutoFitColumns();
     excel.Save();
}

i++;
}