asp.net – EF代码优先：当IDENTITY_INSERT设置为OFF时,无法在表

使用EF插入数据时,我收到错误

Cannot insert explicit value for identity column in table ‘myTable’
when IDENTITY_INSERT is set to OFF

使用这个特定实体,虽然我使用与其他实体相同的方法来插入数据并且不会出现错误.

public class MyTable 
    {
    [Key/*,DatabaseGenerated(DatabaseGeneratedOption.Identity)*/]
    public int ID{get;set;}
    public string name {get;set;}
    public string type {get;set;}
    public string status {get;set;}
    public int country {get;set;}
    public DateTime start_date {get;set;}
    public DateTime due_date {get;set;}
    }`

询问

MyTable check= new MyTable();
            check.name = checkName;
            check.type = "DB";
            check.status = "New";
            check.country = country;
            check.start_date = DateTime.Now;
            check.due_date = dueDate;
            db.myTables.Add(check);
            db.SaveChanges();

更新 ：

取消注释上述行后

(DatabaseGenerated(DatabaseGeneratedOption.Identity))

这是一个例外

A dependent property in a ReferentialConstraint is mapped to a
store-generated column. Column: ‘ID’