zzz projects Dapper Tutorial
Getting Started Documentation 3rd Party Libraries Knowledge Base Online Examples
  • Getting Started
  • Documentation
  • 3rd Party Libraries
  • Knowledge Base
  • Online Examples
  •   Download  

Dapper Tutorial - Knowledge Base (KB)

5 results for: in tag: system.data.sqlite

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 sql-server system.data.sqlite unit-testing
asked by Chris

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...
dapper sqlite system.data.sqlite
asked by John

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...
c# dapper orm sqlite system.data.sqlite
asked by Patrick Quirk

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...
c# dapper nuget-package sqlite system.data.sqlite
asked by Andrey K.

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...
c# dapper dapper-contrib sqlite system.data.sqlite
asked by Snowy

Page 1 of 1
  • 1

Prime Library

Performance

  • Entity Framework Extensions
  • Entity Framework Classic
  • Bulk Operations
  • Dapper Plus

Expression Evaluator

  • C# Eval Expression
  • SQL Eval Function
More Projects...