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