title: C# Execute SQL SP using multithreaded or parallel execution
body: <p>I have a SQL Server SP and would like to execute that for around 10 million user record sets to process the user info and update DB. Currently its taking few millisecond for 1 user to update in DB. Since, it has to process million records what are the best ways to do it?</p>
  
  <p>I am thinking do it from the C# application using multithreaded or parallel foreach. Below is the basic code to run the SP, how can I use it to run it in multithreaded mode to do the processing job faster?</p>
  
  <pre><code> string connString = "data source=.\SQLEXPRESS;initial catalog=Test;integrated security=True;";
              SqlConnection conn = new SqlConnection(connString);
              conn.Open();
              SqlCommand cmd = new SqlCommand("ETL_TEST", conn);
              cmd.CommandType = CommandType.StoredProcedure;
  
              cmd.Parameters.Add(new SqlParameter("@user_id", '12345'));
              cmd.ExecuteReader();
              conn.Close();
  </code></pre>