Enable DatabaseGeneratedOption.None to prevent Entity framework autogenerate values for primary key fields. Turn on Snapshot isolation for MSSQL server