title: Not working IDENTITY_INSERT in SQL Server Compact with Entity Framework 6.4
body: <p>I want to add a record with a specific <code>ID</code> into the database, but when I write and run this code, the line created starts with the number one. My <code>ID</code> is identity and I disable identity insert with the following code:</p>
  
  <pre><code>Db = new Entitites();
  
  Db.Database.ExecuteSqlCommand(@"SET IDENTITY_INSERT CarName ON");
  
  Db.CarName.Add(new MrSanadBaseDb.CarName()
     {
          PK_Car = 120,
          Name = "",
          IsDeleted = false
     });
  
  Db.SaveChanges();
  Db.Database.ExecuteSqlCommand(@"SET IDENTITY_INSERT CarName OFF;");
  Db.Database.ExecuteSqlCommand(@"ALTER TABLE CarName ALTER COLUMN PK_Car IDENTITY (121,1);");
  </code></pre>
  
  <p>But the record is not saved with <code>ID = 120</code>, the record is saved with <code>ID = 1</code>.</p>
  
  <p>I work with SQL Server Compact Edition (SQL Server CE).</p>
  
  <p><a href="https://i.stack.imgur.com/6ZRvc.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/6ZRvc.png" alt="enter image description here"></a></p>