access @@IDENTIY in LINQ?

[viepia]

Hi,
The ony unique identifier for each row of my table is an
auto-increment BigInt Identity column. After I do a InsertOnSubmit
and a SubmitChanges how do I find the Identity column value for the
row I just inserted? In general how does LINQ expose the SQL Server
global variables?
Thanks,
Viepia

 

[viepia]

I don't know if this is the best way, but for now this SPROC works for
me:

ALTER PROCEDURE getSysIdentity
@LastIdentity BIGINT OUTPUT
AS
BEGIN
SELECT @LastIdentity = @@IDENTITY
RETURN 0
END


long? identity = 0;
Trace.Assert( db.getSysIdentity(ref
identity)==0,"SPROC Error");