title: Best way to Bulk Insert from a C# DataTable
body: <p>I have a <code>DataTable</code> that I want to push to the DB. I want to be able to say like </p>
  
  <pre><code>myDataTable.update();
  </code></pre>
  
  <p>But after reading the MSDN <a href="http://msdn.microsoft.com/en-us/library/xkdwwdkf(v=VS.80).aspx" rel="noreferrer">docs</a>, apparently this does inserts row by row. </p>
  
  <blockquote>
    <p>It should be noted that these statements are not performed as a batch process; each row is updated individually.</p>
  </blockquote>
  
  <p>What are my alternatives?</p>
  
  <p>Edit: I am using SQL Server 2005</p>