Database and LINQ - Handle Huge Volume Of Data

Question

Hi alll..

How to handle huge volume of data ( more than 10 lakhs records) ??

Requirement - In database (either Oracle or SQL Server ), I want a facility such that more than 5 lakhs records be inserted , and can be displayed in gridview.

Loading huge amount of records is causing SQL Server Error - "Time Expired".

One option is database-level paging using Row_number() function with page index and page size.

But, one more requirement is - on button click, I want all these records to be exported to excel..

How do I do this ?

Also, How do we handle this large volume of data in LINQ ??

PLease guide