DEV Community

Sunil Gohel
Sunil Gohel

Posted on

pgsql.PostgresException : 42883: function DC_Test.fn_get_configuration(key := bigint) does not exist in npgsql version 9.0.2

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();
Enter fullscreen mode Exit fullscreen mode

}`

Top comments (0)