This occurs when you have a (Primary key) column that is not set to Is Identity to true in SQL and you don't pass explicit value thereof during insert. It will take the first row, then you wont be able to insert the second row, the error will pop up. This can be corrected by adding this line of code [DatabaseGenerated(DatabaseGeneratedOption.Identity)] in your PrimaryKey column and make sure its set to a data type int. If the column is the primary key and is set to IsIDentity to true in SQL there is no need for this line of code [DatabaseGenerated(DatabaseGeneratedOption.Identity)] this also occurs when u have a column that is not the primary key, in SQL that is set to Is Identity to true, and in your EF you did not add this line of code [DatabaseGenerated(DatabaseGeneratedOption.Identity)]

首先转到所需的表名

步骤2 ->右击表名

选择设计

单击列名

步骤5)进入列属性，然后将No设置为Identity Specification

[注意:插入到显式值后，如果你想，你可以恢复到标识规范为true，然后它会再次生成值]

如果你使用SQL server管理studio你可以使用下面的方法

步骤1) 步骤2)

如果您使用Interface并以通用方式实现savechanges方法，则会出现使用非类型化DBContext或DBSet的问题

如果这是您的情况，我建议使用强类型的dbcontext

MyDBContext.MyEntity.Add(mynewObject)

那么，保存更改就可以了

您正在为OperationId插入值，这是一个标识列。

您可以像这样在表上打开标识插入，以便您可以指定自己的标识值。

SET IDENTITY_INSERT Table1 ON

INSERT INTO Table1
/*Note the column list is REQUIRED here, not optional*/
            (OperationID,
             OpDescription,
             FilterID)
VALUES      (20,
             'Hierachy Update',
             1)

SET IDENTITY_INSERT Table1 OFF 

设置该字段的身份增量时，不能在“OperationID”列中插入数据。

不要在该字段中输入值，它将自动设置。

Insert table(OpDescription,FilterID)
values ('Hierachy Update',1)

我使用asp.net core 5.0，我得到这个错误。我得到这个错误，因为我添加了另一个数据并触发了另一个.SaveChanges()方法，如下所示:

 _unitOfWorkVval.RepositoryVariantValue.Create(variantValue);
 int request = HttpContext.Response.StatusCode;
 if (request == 200)
 {
     int tryCatch = _unitOfWorkCVar.Complete();
     if (tryCatch != 0)
     {
         productVariant.CategoryVariantID = variantValue.CategoryVariantID;
         productVariant.ProductID = variantValue.ProductID;
         productVariant.CreatedDate = DateTime.Now;
         _unitOfWorkProductVariant.RepositoryProductVariant.Create(productVariant);
         _unitOfWorkVval.RepositoryVariantValue.Create(variantValue);
         int request2 = HttpContext.Response.StatusCode;
         if(request==200)
         {
             int tryCatch2=_unitOfWorkProductVariant.Complete();//The point where i get that error
         }///.......