Cannot insert explicit value for identity column in table 'File' when IDENTITY_INSERT is set to off. In order to allow insert to identity field we need to set IDENTITY_INSERT on as below: ...

The primary key column is often set to auto-increment when constructing a SQL Server database. To achieve this, the IDENTITY property is enabled on the primary key column. The starting value and ...