After save the entity doesn't contain the autogenerated identity?

Reply

kparker Posted: 11-19-2009 8:35 AM

rated by 0 users

I just upgraded to the latest version (2009.2.1012.0).

Previously, after I saved an entity my primary key column (ID, int, Identity=Yes)  would contain the value of the autogenerated identity after the save was executed.  Now, it's not working the same.

I'm sure this is something easy, but I'm not finding a solution on the forums.

thanks!

Reply

kparker replied on 11-19-2009 8:55 AM

rated by 0 users

Out of habbit, I usually set the ID to -1 for new records.  If I do this, then save, it's not returning the updated autogenerated identity value.

Dim newBusinessInfo As New DAL.BusinessInfo
With newBusinessInfo
 .Id = -1
 .BusinessName = "some business name"
End With
newBusinessInfo.Save()

If I don't set the ID and then save, it does return the updated autogenerated identity value.

Dim newBusinessInfo As New DAL.BusinessInfo
With newBusinessInfo
 .BusinessName = "some business name"
End With
newBusinessInfo.Save()  

Reply

Mike.Griffin replied on 11-22-2009 6:19 AM

rated by 0 users

This has been fixed and is available in our latest Trial, it wont be in the developer release until our next build. However, to be honest, I'd stop setting it to -1, it just doesn't make sense to do so as a habit?