title: Fastest way of performing Bulk Update in C# / .NET
body: <p>I'm trying to figure out whats the best possible way to perform a bulk update via my mini console application in SQL server. I have written my own way of bulk update like following:</p>
  
  <pre><code>  SqlCommand command = new SqlCommand();
    command.Connection = new SqlConnection("Data Source=.;Initial Catalog=mydb;Integrated Security=SSPI");
    command.Connection.Open();
  
    for (int i = 0; i &lt; items.Count; i = i + 1000)
    {
       var batchList = items.Skip(i).Take(1000).ToList();
       for (int j = 0; j &lt; batchList.Count(); j++)
       {
         command.CommandText += string.Format("update Items set QuantitySold=@s_id{0} where ItemID = @id{0};", j);
         command.Parameters.AddWithValue("@s_id" + j, batchList[j].QuantitySold);
         command.Parameters.AddWithValue("@id" + j, batchList[j].ItemID);
        }
       command.ExecuteNonQuery();
       command = new SqlCommand();
       command.Connection = new SqlConnection("Data Source=.;Initial Catalog=mydb;Integrated Security=SSPI");
       command.Connection.Open();
              }
       command.Connection.Close();
  </code></pre>
  
  <p>But I'm not so happy with the performance of this one, updating 50000-100000 records in my DB gets quite slow when doing it like this, even tho it does them in batches of 1000....</p>
  
  <p>Is there any library/solution out there that could "speed things up"?</p>
  
  <p>Can someone help me out ?</p>