Dapper Tutorial - Knowledge Base (KB)

sqlite and sqlserver with dapper

I'm using dapper with SQL Server, but using Sqlite for some in memory tests for my unit tests....I have a class as follows...public class Test { public int ID {get;set;} public string Name } ...If I query using dapper with a SQL Server connection, it...

Dapper and Downward Integer Conversion

I am checking out v1.25 of Dapper with Sqlite via System.Data.Sqlite. If I run this query:...var rowCount = dbc.Query<int>("SELECT COUNT(*) AS RowCount FROM Data").Single(); ...I get the following error: ...System.InvalidCastException: Specified cast is n...

Mapping TimeSpan in SQLite and Dapper

I'm attempting to use Dapper to interface to an existing database format that has a table with a duration encoded as ticks in a BIGINT column. How do I tell Dapper to map my POCO's ...TimeSpan...-typed property to ticks when inserting into and reading fr...

Nuget SQLite to use with Dapper without loading Entity Framework dependencies

In my ...c#... application, I would like to use ...SQLite... with ...Dapper... (on ...SqliteConnection...)....The problem with current ...nuget...System.Data.SQLite... version is that ...EntityFramework...-related dependencies are also loaded, but they a...

Dapper with SQLite and C# Error "Insufficient parameters supplied to the command"

New Information since the original post. This code successfully retrieves an entity, which makes me think QueryMultiple maps differently than Query. Is that true?... using (var multi = sqlConn.QueryMultiple(sqlStmt, new { MytableId = mytableinstance.Mytab...