title: How can I get the next Primary Key for SQL 2008 in Entity Framework 4
body: <p>I am using an Entity Framework 4 connection to connect to a SQL 2008 server to do database handling for my application.</p>
  
  <p>I am using C# in Visual Studio 2010 and my question is regarding Primary Key fields that are incremented by the SQL itself, is it possible at all for me to be able to find the ID that will be used next by the database.</p>
  
  <p>The reason why I cannot just find the last item and +1 is because if my table contains items 1,2,3,4 and 5, removing item 5 then adding another will make the next item become item 6, rather than 5 again (As I use the Identity Specification in SQL, but this must be used).</p>
  
  <p>I cannot find any method such as Item.ID.GetNextIdentity() or something like that and have looked through as many similar questions like this but to no avail.</p>
  
  <p>Any help would be appreciated</p>