Dapper Tutorial - Knowledge Base (KB)

How to use Dapper to insert data into a PostgreSQL jsonb column?

I'm trying to insert JSON data into a JSONB PostgreSQL column using Dapper.Net....The ...NPGSQL Documentation for JSONB... gives specific instructions to use the ...NpgsqlDbType.Jsonb... datatype....With Dapper, I'm trying to add this as a custom paramete...

Why I get the following error Npgsql.PostgresException: '42601: syntax error at or near "$1"' with Dapper?

Having the following query:...select count(t.*) from template t where t.available = true and exists (select * from tag join template_tag on template_tag.tag_id = tag.id where template_tag.template_id = t...

How to use Dapper to execute a Postgre function?

I get an error when I try to call a postgre function using dapper. Where did i do wrong? I'll be glad if you can help me....Error Message: ... availability_list(facilityId => integer, startDate => timestamp without time zone, endDate => timestamp without ...