title: Update thousands of records in a DataSet to SQL Server
body: <p>I have half a million records in a data set of which 50,000 are updated. Now I need to commit the updated records back to the SQL Server 2005 Database.</p>
  
  <p>What is the best and efficient way to do this considering the fact that such updates could be frequent (though concurrency is not an issue but performance is)</p>