Identifier is Null or empty, entity framework, Update data base

1k Views Asked by At

I'm trying to update my model to add a new stored proc. However, I get the following error message when I try to.

enter image description here

This is the stored proc I'm trying to add

    BEGIN

        SET @result = 1;

        /* Execute first-pass validation rules. */
        EXECUTE [RulesEngine].[LGC_Validate_Rules] @passLevel = '1', @currentUserID = @current_user_id;

        /* Execute transformation rules. */
        -- None

        /* Execute second-pass validation rules. */
        EXECUTE [RulesEngine].[LGC_Validate_Rules] @passLevel = '2', @currentUserID = @current_user_id;

        RETURN
    END

GO

Any clues?

1

There are 1 best solutions below

0
Trevy Burgess On

According to https://stackoverflow.com/a/41506386/3538246

"The problem is probably that your procedure performs SELECTs without naming all the columns."

The same thing happened to me.