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: 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

//db is context name..select table name and enter field names in the braces
var Test_Details = from p in db.Test_Details select new { p.Column_names };

And how would select an ID for a new entity? All it does is select a specific column for all entities.....

AFAIK, it can't be done. I usually work around it using a GUID as an identity which I can assign when I create a new instance.

Cheers,

Imar

__________________
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Follow me on Twitter

Author of Beginning ASP.NET 4.5 : in C# and VB, Beginning ASP.NET Web Pages with WebMatrix
and Beginning ASP.NET 4 : in C# and VB.
Did this post help you? Click the button below this post to show your appreciation!