Is it possible to set the value of an auto-increment field? If a record is deleted with primary key 5, but the current auto-increment count is 10, is there any way to re-insert that record with its primary key still remaining at 5 (instead of 11)? I am trying to do this with Entity Framework 4.1 in C#.