EntityFramework-Reverse-POCO-Code-First-Generator
EntityFramework-Reverse-POCO-Code-First-Generator copied to clipboard
Using stored procedure OUT parameters with multiple result sets
CREATE PROCEDURE CheckIfApplicationIsComplete
@ApplicationId INT, @IsApplicationComplete BIT OUTPUT
AS
BEGIN
SET NOCOUNT ON;
IF (@ApplicationId < 10)
BEGIN
SET @IsApplicationComplete = 0;
SELECT 'Application' [Key], 'Not complete' [Value];
END
ELSE
BEGIN
SET @IsApplicationComplete = 1;
SELECT 'Application' [Key], 'Complete' [Value];
END
END;