Error: pgsql.PostgresException : 42883: function DC_Test.fn_get_configuration(key := bigint) does not exist.
I am getting this error in npgsql version 9.0.2 but same is working fine in 6.0.12
.Net Core 8
`public async Task> ExecuteScalarAsync(string sql, List parameters)
{
IEnumerable result = null;
using (NpgsqlConnection connection = new NpgsqlConnection())
{
connection.ConnectionString = "ConnectionString";
using NpgsqlCommand cmd = new NpgsqlCommand();
cmd.Connection = connection;
DynamicParameters dynamicParameters = new DynamicParameters();
foreach (DbParameter parameter in parameters)
{
dynamicParameters.Add(parameter.ParameterName, parameter.Value);
}
await connection.OpenAsync();
result = await connection.QueryAsync<T>(sql, dynamicParameters, null, null, CommandType.StoredProcedure);
await connection.CloseAsync();
}
}
return result.AsList();
}`
Top comments (0)