title: C#/SQL: Execute Multiple Insert/Update in ONE Transaction
body: <p>I have a customer entity with 10 Properties.</p>
  
  <ul>
  <li>7 of those properties are saved in the customer table.</li>
  <li>3 of those properties are saved in the test table.</li>
  </ul>
  
  <p>The 3 properties in test table are CustomerId, Label, Text.</p>
  
  <p>When I query these 3 properties I get 3 dataset like this:</p>
  
  <pre><code>CustomerId | Label  | Text
  1005       | blubb  | What a day
  1006       | hello  | Sun is shining
  0007       |        |
  </code></pre>
  
  <p>When I save them I have to call my stored procedure 3 times on the test table</p>
  
  <p>In my SP I check wether the dataset with the specific customerId AND Label already exists
  then I do an UPDATE else an INSERT.</p>
  
  <p>How would you call the stored procedure 3 times with all CommandText, CommandType, ExecuteNonQuery etc stuff ?</p>