title: Setting custom value for auto-increment column in EF4
body: <p>I am using EF4 with ASP.NET. The entity <code>Subject</code> has a field <code>Id</code> which is set to auto-increment in MySql. This normally works great, but on one occasion I need to set a custom value for <code>Id</code>.</p>
  
  <pre><code>Subject sNone = new Subject { Id = 0, Title = "None", Code = "00" };
  ctx.Subjects.AddObject(sNone);
  </code></pre>
  
  <p>This indeed creates a new subject in the database. However, its <code>Id</code> is not set to <code>0</code> - it is set to an auto-increment value.</p>
  
  <p>Any idea how I can get around this?</p>