Parameters missing?

[julioffigueiredo]

Check your library version, and try updating
Dapper V 2.1.72
Microsoft.Data.SqlClient 7.0.1

Describe the bug

            var parameters = new DynamicParameters();
            parameters.Add("APP_COD", newData.CodAplicativo, DbType.Int64);

            var appExiste = await dbConnection.QueryFirstOrDefaultAsync<int>(
                sql: "select count(*) from CAD.TBL_APLICACAO APP where (APP.APP_COD = @APP_COD)",
                param: parameters);

Give me the warning:

Parameters are being supplied, but no parameters were detected in the command

or in others like this

Parameters are being supplied, but no parameters were detected in the command (https://aot.dapperlib.dev/rules/DAP018)

[mgravell]

Well that's odd. Will try to look, thanks for the report. BTW, DynamicParameters are always the fallback option; I suspect it'll get things more correct if you use new { APP_COD = newData.CodAplicativo } directly

[julioffigueiredo]

Well that's odd. Will try to look, thanks for the report. BTW, DynamicParameters are always the fallback option; I suspect it'll get things more correct if you use new { APP_COD = newData.CodAplicativo } directly

I used anonymous before, but i had some troble with some types to pass, then I changed to this DynamicParameters() that solved all my problems.
Currently I use version 2.1.66 and works perfect.

And I think the problem isnt the param, the problem is that @APP_COD is not recognized as a parameter in the sql text.