Update stored procedure templates to support returning the Identity Column value via a select statement.

[GoogleCodeExporter]

CREATE PROCEDURE [dbo].InsertNewHire
 @EmployeeId int,
 @FirstName varchar(50),
 @LastName varchar(50),
 @NewHireId int OUTPUT
AS

INSERT INTO [dbo].[NewHire] (
 [EmployeeId],
 [FirstName],
 [LastName]
) VALUES (
 @EmployeeId,
 @FirstName,
 @LastName
)

SET @NewHireId = @@IDENTITY

how it needs to be for entity framework:

CREATE PROC dbo.Account_Insert
(
    @customerId INT
)
AS
BEGIN
    INSERT INTO Account (customerId)
    VALUES (@customerId)

    SELECT SCOPE_IDENTITY() as accountId
END
GO

Original issue reported on code.google.com by bniemyjski on 13 Feb 2012 at 6:42