[Bug] Cannot insert the displayed value for an identity column in table "XX" when IDENTITY_INSERT is set to OFF

Write in front

When you design a database table, the primary key is set to self-increment. This error occurs when you are using LINQ to SQL, adding data.

Solution Solutions

Locate the **.dbml file generated by LINQ to SQL and right-click on the corresponding table to modify its properties. When inserting data, you should also be aware of the primary key settings.

Set auto-generated values to true.

[Bug] Cannot insert the displayed value for an identity column in table "XX" when IDENTITY_INSERT is set to OFF