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 this query: "SELECT IDENT_CURRENT ('alpa_Animais') AS AnimalID" directly, using the SQL Server Management Studio I get this value.
Does anyone know if there is a way to get this from a method inside a web app using Linq?
Thank you
Josi

Hi Josi,

If you want to use LINQ to execute that query, I would put it in a stored procedure and execute that proc via LINQ. Should be very easy to do. There are examples of executing procs in the book.

I hope this helps. Let me know if you need any other info.

Scott

__________________
========================
Scott Klein
Author of:
Professional SQL Server 2005 XML
Professional WCF Programming: .NET Development with the Windows Communication Foundation
Professional LINQ
========================

Hello,
am asking...
is there any way I can retrieve the identity value, of a column after inserting a new database record using linq
i could i achieve this like this using stored procedure:

//insert statement
return @@identity.
how do I achieve thesame with linq

thanks