Dapper Tutorial - Knowledge Base (KB)

Dapper AddDynamicParams for IN query with IEnumerable parameter in Postgres

To start, I am having the same problem that was discussed, and allegedly fixed about two years ago. See the following question for that issue:...Dapper AddDynamicParams for IN statement with "dynamic" parameter name...The problem that I am experiencing i...

Unpredictable Npgsql Exception During Transaction Dispose

I am attempting to run some commands in a transaction using Npgsql 2.1.3 (Postgres v9.3) and Dapper 1.29, but am occasionally getting some unexpected exceptions. Sometimes, the code works just fine. Other times, I am getting the following exception:...N...

Dapper Bulk Insert Returning Serial IDs

I am attempting to perform a bulk-insert using Dapper over Npgsql, that returns the ids of the newly inserted rows. The following insert statement is used in both of my examples:...var query = "INSERT INTO \"MyTable\" (\"Value\") VALUES (@Value) RETURNIN...