I'm trying to use Dapper to call a PostreSQL function declared as the following:
CREATE OR REPLACE FUNCTION public.test(param1 integer, param2 character varying, param3 character varying)
I'm using Dapper-Async to call this function like this:
cnx.QueryAsync($@"SELECT * FROM public.test(@Param1, @Param2, @Param3);", new { Param1 = 12, Param2 = mylongstring1, Param3 = mylongstring2});
This call fails with the following error:
Npgsql.PostgresException (0x80004005): 42883: function public.test(integer, text, text) does not exist
As you can see, the DbString matches text parameter types. How can I match character varying instead ?