如果您使用Oracle SQL Developer进行连接，请记住添加/sqldev:stmt/

/sqldev:stmt/ set identity_insert TABLE on

把断点放在你的[HttpPost]方法上，检查什么值被传递给Id属性。如果它不为零，则会发生此错误。

首先转到所需的表名

步骤2 ->右击表名

选择设计

单击列名

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

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

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

步骤1) 步骤2)

最好的解决方案是使用GeneratedValue(strategy =…)注释，即。

@Id
@GeneratedValue(strategy = GenerationType.IDENTITY)
@Column ...
private int OperationID;

它说，这个列是由数据库使用IDENTITY策略生成的，你不需要关心-数据库会做的。

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)]

请注意，如果您用;结束每一行，SET IDENTITY_INSERT mytable ON命令将不适用于以下行。

即。 像这样的查询

SET IDENTITY_INSERT mytable ON;
INSERT INTO mytable (VoucherID, name) VALUES (1, 'Cole');

给出错误 当IDENTITY_INSERT设置为OFF时，无法为表'mytable'中的身份列插入显式值。

但是像这样的查询是可以的:

SET IDENTITY_INSERT mytable ON
INSERT INTO mytable (VoucherID, name) VALUES (1, 'Cole')
SET IDENTITY_INSERT mytable OFF;

SET IDENTITY_INSERT命令似乎只适用于事务，而;将表示事务的结束。