Entity Framework and SCOPE_IDENTITY

Entity Framework and SCOPE_IDENTITY

I have a stored procedure that inserts into a table then executes this line
SET @returnVal = SCOPE_IDENTITY();
and after that I've tried both:
SELECT @returnVal
and
return @returnVal
When I execute the stored procedure from Microsoft SQL Server Management
Studio, I get the expected result with "SELECT @returnVal" - the identity
column for the inserted data is selected.
However when I add the stored procedure to my ADO.Net Entity Data Model /
EntityFramework class / .edmx class and execute the stored procedure in my
C# code, I get the value -1 returned without fail.
Is it possible to get the value that I want, the new identity value,
returned?
I realize that I could manually bind the stored procedure to the insert
action of the table in my model - but this is not an option. There are far
too many insert procedures to do this manual work every time I regenerate
my model class(es).
Thanks for your time, Mark



Adding an output parameter worked (answer marked below).
The stored procedure signature looks like this now:
My stored procedure signature now looks like this:
CREATE PROCEDURE SP_MyStoreProc ([Multiple Parameters], @returnVal int
output)
The last line of the stored procedure is:
return @returnVal
My C# code looks like this now: (db is an instance of my dbContext class)
System.Data.Objects.ObjectParameter identityParameter =
new System.Data.Objects.ObjectParameter("returnVal", 0);
db.SP_MyStoredProc([Multiple Parameters], identityParameter);
int myNewIdentity = Convert.ToInt32(identityParameter.Value);