Entity Framework更新模型加存储过程遇Identifier为空错误求助

Hey there, let's work through this error you're hitting. The "Identifier is Null or empty" message almost always points to a missing, unrecognized, or improperly defined object name, variable, or parameter in your SQL code. Based on the snippet you shared, here are the most likely fixes to resolve this:

1. Declare All Variables Before Using Them #

Your code references @result and @current_user_id, but there’s no sign these variables were declared upfront. SQL Server requires explicit declaration of variables before you can assign or pass them. Add these declarations at the start of your stored procedure:

DECLARE @result INT; -- Adjust the data type if needed (e.g., VARCHAR, BIT)
DECLARE @current_user_id INT; -- Match the data type expected by [RulesEngine].[LGC_Validate_Rules]

Also, make sure to assign a valid value to @current_user_id before passing it to the validation procedure—leaving it NULL could trigger the same error in the called stored procedure.

2. Don’t Forget the Stored Procedure Name #

If you’re creating this as a new stored procedure, double-check that you included the procedure name in your CREATE PROCEDURE statement. A missing name will immediately cause SQL Server to throw this exact error. Here’s the correct structure to follow:

CREATE PROCEDURE [YourSchema].[YourNewProcedureName]
    -- Add input parameters here if required, e.g.:
    -- @current_user_id INT
AS
BEGIN
    -- Your existing logic starts here
    DECLARE @result INT;
    SET @result = 1;

    EXECUTE [RulesEngine].[LGC_Validate_Rules] @passLevel = '1', @currentUserID = @current_user_id;
    -- ... rest of your code
END

Replace [YourSchema].[YourNewProcedureName] with your actual schema and desired procedure name.

3. Validate the Called Procedure’s Parameters #

Check if [RulesEngine].[LGC_Validate_Rules] enforces a non-null constraint on the @currentUserID parameter. If @current_user_id is NULL when you execute your procedure, the validation procedure might be the source of the error. Ensure you populate @current_user_id with a valid value first—for example:

SET @current_user_id = SUSER_SNAME(); -- Gets the current SQL user's name
-- OR
SET @current_user_id = 123; -- Hardcode a valid user ID for testing

4. Check Object Permissions #

In rare cases, this error can occur if your SQL account lacks permission to access [RulesEngine].[LGC_Validate_Rules]. Try executing the validation procedure directly (outside your new procedure) to see if you get the same error. If so, reach out to your database admin to request the necessary permissions.

内容的提问来源于stack exchange，提问作者a ridi