title: How to avoid a "Nested transactions are not supported." error?
body: <p>I am using <code>EF6</code> to do some pretty simple integration with a <code>MySql</code> database.</p>
  
  <p>The <code>Nested transactions are not supported.</code> error occurs after I do the following:</p>
  
  <ol>
  <li>Attempt to add a <code>key</code> that already exists... Which leads to the error: <code>Duplicate entry 'asdf' for key 'UserName_UNIQUE'</code></li>
  <li>Attempt to add anything afterwards... Which leads to the error: <code>Nested transactions are not supported.</code></li>
  </ol>
  
  <p>I guess I'm not sure what would be <code>Nested</code> about these two queries...  What am I doing wrong:</p>
  
  <p><strong>And for some code</strong></p>
  
  <pre><code>using (var db = C2SCore.BuildDatabaseContext())
  {
    db.Users.Add(new UserProfile { UserName = UserName, Password = Password });
    db.SaveChanges(); // &lt;- Errors occur here...
  }
  </code></pre>
  
  <p>This snippet runs (as my the flow described above implies) for every <code>UserProfile</code> I add.</p>