Dapper Tutorial - Knowledge Base (KB)
31 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?
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...
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...
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...
asked by BrokeMyLegBiking
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...
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 ,...
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...
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) ...
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...
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...
asked by Kaveh Shahbazian
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...
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...
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...
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...
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...
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...
asked by mgimeno
SQLite as in-memory database for SQL Server
My setup is similar to this for testing dapper calls for SQL Server using in-memory SQLite (...http://mikhail.io/2016/02/unit-testing-dapper-repositories/...) using this lib: ...https://github.com/ServiceStack/ServiceStack.OrmLite...I'm using dapper with ...
asked by Justin Homes
Can you tell why DapperExtension''s Update method is failing to execute?
I'm using SQLite, Dapper and DapperExtensions, all the latest via NuGet....Here's my table's schema......CREATE TABLE `LibraryInfo` ( `Id` INTEGER NOT NULL, `Name` TEXT NOT NULL CHECK(length ( Name ) > 0), `Description` TEXT, `Versio...
asked by MarqueIV
How to use Dapper with IDataErrorInfo Interface validations?
I am new to ORM so please be calm to answer my question. I have built a POCO admin class with Dapper attributes and Implemented IDataErrorInfo for validations on my Model classes Here: ...public partial class Admin:IDataErrorInfo {... [Key] pub...
asked by Abdullah
Sqlite using Dapper. Error parsing column . Unable to cast object of type System.Int64 to type System.Double
I'm using fastcrud and dapper to map my query results to my custom type. I investigated the dapper library and i came to the conclusion that i think it's an issue with the Microsoft.Data.Sqlite package. Not sure if it must be fixed over there but this is ...
asked by mkeymolen
Page 1 of 2