title: How to efficiently stream millions of records from .NET to SQL Server
body: <p>I have a C# .NET program that processes millions of records a few at a time and then stores them either in a flat file or a SQL Server database.</p>
  
  <p>Currently, to store them in the SQL Server database the program writes all the records to a flat file and then uses bcp to import into SQL Server.</p>
  
  <p>Is there a more efficient method that bypasses the need to write every record to the hard disk before importing into SQL?</p>