title: UpdateOnSubmit from dbml?
body: <p>I have some generated classes representing a table from a dbml file</p>
  
  <p>inserting a record in the table works fine with Name as a primary key</p>
  
  <pre><code>  dbDataContext nc = new dbDataContext(connectionstring);
  
    Action action = new Action();
    action.Name = "1234"; // primary key
  
    nc.Actions.InsertOnSubmit(action);
    nc.SubmitChanges();
  </code></pre>
  
  <p>But how to update a record when Name already exists? There seems to be no UpdateOnSubmit or anything. There doesnt seem to be a clear answer on this.</p>