How to call function postgresql? using Dapper

Question

Is this right wy to cll function in postgresl?
var procedure = "vamp.SearchQuestion";
using (var connection = new NpgsqlConnection(_connectionString))
{
result = await connection.QueryAsync (procedure, new { searchtext = searchText }, commandType: CommandType.StoredProcedure);
}

Sachin Singh · Answer

Yes, this should work, your approach is absolutely correct. You already know parameters can be passed in multiple ways like shown below, but every approach is correct. using  (IDbConnection connection=  new  NpgsqlConnection( "yourConnectionString" ))       {           var parameters =  new  DynamicParameters();           parameters.Add( " searchtext " , searchtext );                       return   connection .Query QuestionSearchModel >( " SearchQuestion " , parameters, commandType: CommandType.StoredProcedure);       }

Ck Nitin · Answer

testing

Sagar Lad · Answer

Hi Nitin,   You can check this for more information :  https://dapper-tutorial.net/knowledge-base/56685875/how-to-execute-postgres-function-using-dapper