title: C# , SQL update multiple rows
body: <p>i have a question regarding an efficient way to update multiple rows via SQL.</p>
  
  <p>Basiclly i have a query i need to run on different RowIDs:</p>
  
  <pre><code>UPDATE TableName SET Column = (some number) WHERE RowID = (some number)
  </code></pre>
  
  <p>if to be more specific this is a better example:</p>
  
  <pre><code>UPDATE TableName SET Column = 5 WHERE RowID = 1000
  UPDATE TableName SET Column = 10 WHERE RowID = 1001
  UPDATE TableName SET Column = 30 WHERE RowID = 1002
  ..
  </code></pre>
  
  <p>I'd like to know how should i build the update query command on C# (or just give me an example of the resulted query i should get to) so once i use ExecuteQuery it will run all of these commands at one piece and not by executing each command.</p>
  
  <p><em><strong>edited:</em></strong>
  I have another problem, can you also explain what about dynamic situation in which not necessarly the row i want to update exist already, in that case i need to insert instead of update. to explain better, back to my example lets say i want to do</p>
  
  <pre><code>UPDATE TableName SET Column = 5 WHERE RowID = 1000
  INSERT INTO TableName [RowID, Column] VALUES (1001, 20)
  UPDATE TableName SET Column = 30 WHERE RowID = 1002
  ..
  </code></pre>
  
  <p>The meaning of this is that i need to check if the row exist, if so i'd use update otherwise i'll have to insert it.</p>
  
  <p>Thank you!</p>