title: RawSQL and auto-generated keys in EF Core 3.1
body: <p>I have a Model with a Guid primary key. I want the Database to generate a key on insert so I added the following annotations:</p>
  <pre><code>    public class Employee
      {
          [Key]
          [DatabaseGenerated(DatabaseGeneratedOption.Identity)]
          public Guid employee_id { get; set; }
  
          [Required]
          public int employee_number { get; set; }
  
          //more props...
      }
  </code></pre>
  <p>Now I expected that inserts with RawSQL wouldn't expect a primary key, however the folllowing statement doesn't work when executred through <code>ExecuteSqlRaw</code>:</p>
  <pre><code>INSERT INTO employees (employee_number/**, more props*/) 
  VALUES (123 /**,more props*/)
  </code></pre>
  <p>An error is caused by the DB about a non-nullable primary key. Explicitly inserting some random Guid works, but i figured the DB would take care of this.</p>
  <p>Is the Identity annotation wrong?</p>