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)

41 results for: in tag: sqlite

How can i use dapper to connect to a sqlite database?

How can I use dapper to connect and get data from a sqlite database?
dapper sqlite
asked by David

Dapper micro ORM, database agnostic and MySql Guid type

I am experimenting ...Dapper... on a pet project. I am using ...SQLite... to run all the tests and MySql for "production". However I am not sure how to best use Dapper to handle database agnostic situation....The particular problem I am having is with MyS...
c# dapper mysql orm sqlite
asked by Jeff

Improve performance of SQLite bulk inserts using Dapper ORM

I am working on a desktop application which uses SQLite to bulk insert tens of thousands of rows into a SQLite database. I would like help optimizing the bulk insert performance. It currently takes up to 50 seconds to insert 60 megs worth of data into the...
.net dapper sqlite
asked by BrokeMyLegBiking

Change Dapper so that it maps a database null value to double.NaN

I have a nullable double column in my SQLite database....When reading from the database (for columns of type double) I would like to convert nulls into "double.NaN"....Currently dapper sets null values to 0, which I do not want....What are my options?...M...
.net ado.net dapper sqlite
asked by BrokeMyLegBiking

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...
dapper mono sqlite
asked by Chirdeep Tomar

I thought Dapper could merge multiple queries like this

I'm using the Dapper micro ORM. I thought it could handle enumerables like this:...string sql = @"SELECT * FROM Events WHERE TimestampTicks <= @TimestampTicks AND TelemetryId = @TelemetryId ORDER BY TimestampTicks DESC LIMIT 1"; var events = _connection.Q...
c# dapper sqlite
asked by Brannon

How do I get Dapper.Rainbow to insert to a table with AutoIncrement on SQLite?

I created a sample table on SQLite that has an Id column that is auto increment....CREATE TABLE "ESVLIntegration" ("Id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL UNIQUE , "ProcessId" TEXT NOT NULL , "UserId" INTEGER NOT NULL , "Status" TEXT NOT NULL ,...
c# dapper dapper-rainbow sqlite
asked by Alvaro Oliveira

Dapper ORM and SQLite perform query

I've got a simple table in my SQLite database:...CREATE TABLE ProductCategories ( Id INTEGER PRIMARY KEY AUTOINCREMENT, Name NVARCHAR(128) NOT NULL UNIQUE, ImageUrl NVARCHAR(256), ParentCategoryId INTEGER, FOREIGN KEY (ParentCategoryId...
dapper mapping orm sqlite
asked by shadeglare

insert conditionally get row id?

I want to create a thread but only if the subject is unique in that section. Then I want to get the row id of the thread. How do I write it safely? My thoughts were something like...connection.Query<long>(@"insert into thread(section, subject, body) ...
.net dapper sql sqlite
asked by user34537

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)
.net dapper sqlite
asked by user34537

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

SQLite and "Database is Locked"

Using SQLite, System.Data.SQLite and Dapper (in a Console Application; later Windows Service; high throughput); why "database is locked" is there anyway?...I even abstracted all calling to SQLite db in this method:...public static void LocalDbScope(Action...
c# dapper sqlite
asked by Kaveh Shahbazian

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 ...
dapper datetime sqlite
asked by Mauro Destro

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

How to use Dapper.QueryMultiple with Sqlite

The Dapper ...documentation... states you can send off multiple queries at once and iterate over the results using the QueryMultiple method like so:...var sql = @" select * from foo where id = @paramname select * from bar where id = @paramname"; conn.Que...
.net c# dapper sqlite
asked by user3791372

Utc Date saving as Local date in Sqlite

I have an Sql database which contains a date field....I use Dapper to update the database as follows:...const string sql = "UPDATE AdminDb.Users " + "SET IsLoggedOn = 1, LastLoggedOn = @LastLoggedOn " + "WHERE Usernam...
c# dapper datetime sql sqlite
asked by Steven Wood

SQLite In Clause not working in trigger

i have two tables Table1 and Table2. Table1 have columns ID,stringIDs and Table2 Columns ID,data...i have created a trigger to delete rows based on table1. it doesn't works if comma Seperated stringIDs are more than one. it works if stringID...
ado.net c# dapper sqlite
asked by Meer

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 throws exception second time you run a query if different results schema

I'm using Dapper, Sqlite on c# coreclr....public async Task<UserPoco> GetFromEmail(string email) { email = email.ToLower(); using (var connection = new SqliteConnection(_configSettings.ConnectionString)) { connecti...
c# coreclr dapper sqlite
asked by mgimeno

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!")...
bytearray dapper insert sqlite vb.net
asked by Charles Okwuagwu

Page 1 of 3
  • 1
  • 2
  • 3
  • ยป

Prime Library

Performance

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

Expression Evaluator

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