title: LINQ Inserts without IDENTITY column
body: <p>I'm using LINQ, but my database tables do not have an IDENTITY column (although they are using a surrogate Primary Key ID column)</p>
  
  <p>Can this work?  </p>
  
  <p>To get the identity values for a table, there is a stored procedure called GetIDValueForOrangeTable(), which looks at a SystemValues table and increments the ID therein.
  Is there any way I can get LINQ to get the ID value from this SystemValues table on an insert, rather than the built in IDENTITY?</p>
  
  <p>As an aside, I don't think this is a very good idea, especially not for a web application.  I imagine there will be a lot of concurrency conflicts because of this SystemValues lookup.  Am I justified in my concern?</p>
  
  <p>Cheers
  Duncan</p>