title: Insert entire DataTable into database at once instead of row by row?
body: <p>I have a DataTable and need the entire thing pushed to a Database table.</p>
  
  <p>I can get it all in there with a foreach and inserting each row at a time. This goes very slow though since there are a few thousand rows.</p>
  
  <p>Is there any way to do the entire datatable at once that might be faster?</p>
  
  <p>The DataTable has less columns than the SQL table. the rest of them should be left NULL.</p>