Dapper Tutorial - Knowledge Base (KB)

Mono + SQLite + Dapper SQLite Exception during Insert

I am using Mono, SQLite, Dapper & Dapper Extensions. I can read from the database but Insert is not working. I am using Mono Driver for sqlite. ...Error is not very informative, atleast to me. Any help will be much appreciated....Error: ...SQLite error ne...

bulk insert using sqlite and dapper

I am using dapper.net and sqlite. When I do this query only the first id is insert, the rest are ignored. How do I bulk insert?...insert or ignore into pair(key, value) select @key, (select value from list where id in @id_list)

Correctly convert DateTime property with Dapper on SQLite

I'm using Dapper to insert and get objects to/from SQLite: one object have a property of type DateTime (and DateTimeOffset) that I have to persist and retrieve with milliseconds precision. I can't find a way to correctly retrieve the value because Dapper ...

how to save byte-array with Dapper and sqlite insert statement

I have the following code:...Shared Sub ExecSQL(ByVal connection As SQLiteConnection, ByVal commandText As String, Optional ByVal param As Object = Nothing) If connection Is Nothing Then Throw New NullReferenceException("Connection required!")...

SQLite .net provider & "prepare statement" functionality

PREFACE...One can find a description of the SQLite's ..."Prepared Statement"... functionality ...here.... ...SQLite command ...(SQLite provider for .NET)... has a method "Prepare" with the following description: ...Summary: Does nothing. Commands...

SQLite in memory with dapper generates non-existent table error

I have the following code for creating the table:...string query = @"CREATE TABLE GVP_USERS_TAGS( ID integer NOT NULL PRIMARY KEY AUTOINCREMENT, DATEINS datetime NOT NULL DEFAULT DATETIME('now'), ...