Dapper Postgresql not in

NOT IN等价于<> ALL。

var sql = "SELECT * FROM Invoice WHERE Kind <> ALL(@Kind);";

using (var connection = My.ConnectionFactory())
{
    connection.Open();

    var invoices = connection.Query<Invoice>(sql, new {Kind = new[] {InvoiceKind.StoreInvoice, InvoiceKind.WebInvoice}}).ToList();
}

参考官网9.22.5. ALL