C# Parsing large flatfile data and inserting to database
<p>I have a Flat file size >1GB. I need to parse the file and insert into DB.</p>

<p><strong>Method 1:</strong>
   Parsing and convert the flatfile to csv. 
  and then use a bulk insert in sql. </p>

<p><strong>Problem:</strong> </p>

<p>Using <a href="http://blogs.msdn.com/b/csharpfaq/archive/2012/01/23/using-async-for-file-access-alan-berman.aspx" rel="nofollow">async</a> for file read, I am thrown System.OutOfMemoryException</p>

<p>It takes nearly 30 minutes (depends of the size) to do so.</p>

<p>Do I need to use efficient use of data structures to reduce the time or any other efficient methodologies  ?</p>
