SqlException: Cannot insert explicit value for identity column in table 'Genres' when IDENTITY_INSERT is set to OFF. code example
Example: Cannot insert explicit value for identity column in table 'Tbl_Increment_File' when IDENTITY_INSERT is set to OFF.
SET IDENTITY_INSERT MyTable ON
-- INSERT INTO MyTable...
SET IDENTITY_INSERT MyTable OFF