title: What's the most efficient way to update thousands of records
body: <p>We have a C# application which parses data from text files.  We then have to update records in our sql database based on the information in the text files.  What's the most efficient way for passing the data from application to SQL server?</p>
  
  <p>We currently use a delimited string and then loop through the string in a stored procedure to update the records.  I am also testing using TVP (table valued parameter).  Are there any other options out there?</p>
  
  <p>Our files contain thousands of records and we would like a solution that takes the least amount of time.</p>