title: How to update table with SqlAdapter.Update which doesn't have primary key
body: <p>I am having <code>SqlDataAdapter</code> in which I am updating <code>DataRow</code>.</p>
  
  <p>I got exception</p>
  
  <blockquote>
    <p>Dynamic SQL generation for the UpdateCommand is not supported against a SelectCommand that does not return any key column information</p>
  </blockquote>
  
  <p>The error goes if I put primary key in table.</p>
  
  <p>But I don't want to put primary key in it.</p>
  
  <pre><code>var dataAdapter = new SqlDataAdapter();
  var updatedRows = Getting some row ...
  dataAdapter.Update(updatedRows);
  </code></pre>