EntityFramework-Reverse-POCO-Code-First-Generator icon indicating copy to clipboard operation
EntityFramework-Reverse-POCO-Code-First-Generator copied to clipboard

Using stored procedure OUT parameters with multiple result sets

Open sjh37 opened this issue 3 years ago • 0 comments

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;

sjh37 avatar Jul 27 '22 09:07 sjh37