Parameter for Stored Procedure not identified

Question

I’m having a problem, which would be a mistake saying that there is no parameter being passed to the Procedure.

It is running the following code:

cmdProcedure.Parameters.AddWithValue("@id", 0);

Command:

public List<Models.Admin> UpdateList()
{
    using (var context = new DbContext())
    {
        var cmdProcedure = new SqlCommand("GetAdmin");
        cmdProcedure.Parameters.AddWithValue("@id", 0);

        using (var data = context.ExecuteSelectProcedure(cmdProcedure))
        {
            return GetList(data);
        }
    }
}

public SqlDataReader ExecuteSelectProcedure(SqlCommand cmdProcedure)
{
    cmdProcedure.Connection = _connection;
    return cmdProcedure.ExecuteReader();
}

Here is my trial:

PROCEDURE [dbo].[GetAdmin]      
(
    @id int
)
AS
    BEGIN
        SET NOCOUNT ON;

        if (@id > 0)    
            SELECT * FROM Admin WHERE idAdmin = @id
        else
            SELECT * FROM Admin
    END

Error image:

Answer 1

Fixed issue! Just after completion of adding parameters the following line was missing:

cmdProcedure.CommandType = CommandType.StoredProcedure;

problem solved.