title: Set a custom identity value on a auto increment field
body: <p>I have in my DB (Sql server 2008) a id column with auto numeric set on.
  I'm using EF and linq2entities</p>
  
  <p>In some specific scenario I would like to be able to set a custom Id number (obviously I'm totally sure this value is not repeated), for example I would use it to "fill" missing Id numbers caused by deletions.  I want to keep the auto increment prop in database, the problem is that when I do the linq sentence, the database assign the next Id number, not the one that I like.</p>
  
  <p>Maybe it's a little weird but is it possible to do using linq2entities ? </p>
  
  <p>Thanks in advance!</p>