[IBATISNET-165] Getting return value generatedKeys from stored procedures in inserts

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: DataAccess 1.5
• Fix Version/s: DataMapper 1.5
• Component/s: DataMapper
• Environment: .net framework 2.0
• Assignee: Unassigned
• Reporter: Oddur Magnusson
• Created: 26/Jun/06 23:57
• Updated: 28/Jun/06 02:02
• Resolved: 28/Jun/06 02:02

Description

When calling a stored procedure that does a insert and returns the row idendity in a return statement, like

CREATE PROCEDURE [dbo].[DoFoo] @foo int AS
INSERT INTO Foos (foo) VALUES (@foo)
RETURN @@IDENTITY

there is no way of accessing the return value and returning it as the generatedKey