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...