Dapper Tutorial - Knowledge Base (KB)

Dapper dot net query in F#

I'm trying to use Dapper dot net in F# to perform a simple SQLite query. Dapper returns a collection of dynamic objects: using them in C# is straightforward, but from what I understood F# has no dynamic property lookup implementation out-of-the-box....Thi...

OleDbException on writing to MS Access using Dapper

I'm trying to do an insert with Dapper into my MS Access database, now querying the data works fine but when I do try an insert I get an ...System.Data.OleDb.OleDbException : Data type mismatch in criteria expression...The code is :...let conn = new OleDb...

Dapper column to F# option property

How do I get Dapper to convert data to an F# type with an ...option... property? Simple example:...type SomeType = { Count : int option } connection.QueryAsync<SomeType>(...) ...This throws:...System.InvalidOperationException A parameterless defa...

Dapper and Postgres - print queries

I'm using Dapper with Postgres and I would like to log some diagnostics, especially the actual query being run....If I was using SQL Server I'd be doing ...let connection = new SqlConnection(connectionString) connection.StatisticsEnabled = true // run qu...

Dapper generic typehandler for F# Union types

I'm using union types similar to enums on my dapper objects:...type Confidence = | Low | Medium | High type Goal = { Confidence: Confidence ... } ...I've created a custom type handler in order to make it work:...type UnionHandler<'T>...