即使一切正确，如果Identity列的数据类型不是int或long，也会出现此错误。我有单位列为十进制，虽然我只保存int值(我的坏)。更改数据库和底层模型中的数据类型为我解决了这个问题。

如果你在使用带有sequize -typescript npm的sql-server时遇到这个问题，请确保将@AutoIncrement添加到ID列:

  @PrimaryKey
  @AutoIncrement
  @Column
  id!: number;

只需删除拖放到.dbml文件中的表，然后重新拖动它们。清洁方案>重建方案>重建方案。

这对我很管用。

我没有做我自己的表格，我是用VS和SSMS，我遵循这个链接为ASP。净身份:https://learn.microsoft.com/en-us/aspnet/identity/overview/getting-started/adding-aspnet-identity-to-an-empty-or-existing-web-forms-project

即使一切正确，如果Identity列的数据类型不是int或long，也会出现此错误。我有单位列为十进制，虽然我只保存int值(我的坏)。更改数据库和底层模型中的数据类型为我解决了这个问题。

在我的情况下，我插入了比表中定义的更多的字符。

在我的表列用nvarchar(3)定义，我传递了超过3个字符，同样的错误消息来了。

这不是答案，但在某些情况下可能是类似的问题

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