datatable - Store More than 100 Millions Records in memory C# -

this question has answer here:

• total rows can add datatable 2 answers

i using c# datatable store around 100 millions records. after storing 16 millions throws exception "out of memory"

so can store 100 milions record in c# datatable or have alternative that.

after storing data want perform linq queries on data.

please provide me solution

the maximum number of rows datatable can store 16,777,216.

found on http://msdn.microsoft.com/en-us/library/system.data.datatable.aspx

alternate is, use dataset. create databale after each 16 million record , add in dataset.