Issue with Dapper: Intermittent '@ParameterNames1 is not a parameter for procedure...' Error

Hello,

I'm encountering an intermittent issue with Dapper. Occasionally, I receive the error message '@ParameterNames1 is not a parameter for procedure....' When I stop and restart the application using 'dotnet run', the error disappears, and everything works fine. However, after a while, the error reappears.

I've thoroughly checked the parameters I'm passing, and they are correct because the application runs without issues after restarting.

Could you please help me troubleshoot this issue?

Thank you.

P/s: Dapper 2.1.44 and .Net 8.0

``

        using var con = new SqlConnection(_connectionString);
        const string sql = "TestStore";
        DynamicParameters para = new();
        para.Add("@type", 1);
        para.Add("@employeeID", employeeID);

        var result = await con.QueryAsync<object>(sql, para, commandType: CommandType.StoredProcedure);

Start by reproducing the intermittent call in the provided C# snippet and inspect the SQL Server stored procedure named TestStore alongside its parameter definitions. Compare the failing and post-restart behavior, including the @type and @employeeID values; done means identifying why @ParameterNames1 is sent and documenting a reliable fix or reproduction.