title: DBConcurrencyException MySqlCommandBuilder
body: <p>When modifying data inside <code>DataGridView</code>, I get the exception:</p>
  
  <pre><code>DBConcurrencyException: Concurrency violation: the UpdateCommand affected 0 of the expected 1 records
  </code></pre>
  
  <p>When I do this:</p>
  
  <pre><code>// myTable is the DataSource of the datagridview.
  myAdapter.Update(myTable);
  </code></pre>
  
  <p>VS2010 Debugger tells me this is the <code>updateCommand</code> when trying to update:</p>
  
  <pre><code>UPDATE `MySchema`.`MyDatabase` 
  SET `EmployeeFirstName` = @p1 
  WHERE ((`ID` = @p2) AND (`EmployeePhoneNumber` = @p3) AND
         (`EmployeeFirstName` = @p4))
  
  @p1 is Joe (new value changed in the datagridview)
  @p4 is Sally (database value)
  </code></pre>
  
  <p><strong>Question:</strong></p>
  
  <p>Why am I getting a <code>DBConcurrencyException</code> if the <code>WHERE</code> clause exists in the database? (There is no actual change so there isn't any concurrency violation)</p>