Linq to Sql - Retrieving the value of an identity column
Posted: Fri 17 Jul 2009 19:34
Hello, I'm wondering if there is a way to retrieve the identity value from an identity column before saving a new register.
When I run the query directly, using the SQL Server Management Studio I get the value.
Does anyone know if there is a way to get this from a method inside a web app using Linq?
Thank you
Josi
When I run the query directly, using the SQL Server Management Studio I get the value.
Code: Select all
"SELECT IDENT_CURRENT ('alpa_Animais') AS AnimalID"Does anyone know if there is a way to get this from a method inside a web app using Linq?
Thank you
Josi