Top "System.data.sqlite" questions

System.

SQLite.Net Issue With BeginTransaction

I'm trying to use System.Data.Sqlite library, and I'm following the documentation about optimizing inserts so I copied this …

c# sqlite system.data.sqlite
When i select from sqlite column of type 'int' I can cast to .net int but when I select from 'integer' column I cannot

I'm using System.Data.SQLite, selecting from a sqlite database table where a column has type 'integer', and when I …

c# system.data.sqlite
System.Data.SQLite Not Supporting Multiple Transactions

So I am having an interesting issue with System.Data.SQLite and using multiple transactions. Basically I have the following …

c# sql sqlite system.data.sqlite
SQLite .NET Insert ExecuteNonQuery Returns 1

SQL: CREATE TABLE main.LogRecord ( Id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL , TimeStamp DATETIME NOT NULL , Type TEXT NOT NULL , …

c# .net sql sqlite system.data.sqlite
Improve large data import performance into SQLite with C#

I am using C# to import a CSV with 6-8million rows. My table looks like this: CREATE TABLE [Data] ([…

c# .net sqlite system.data.sqlite
'The database file is locked' with System.Data.SQLite

I am suddenly getting the following errors from SQLite after adding a new transaction: The database file is locked database …

c# sqlite system.data.sqlite
DB connection fails (System.Data.Sqlclient.SqlException)

I am programming a Weatherstation which gets the data from an API. This works fine, but I want to store …

c# sql-server ado.net system.data.sqlite sqlclient
Store NaN values in SQLite database

I'd like to insert NaN values into SQLite database. I have Ent table with Id, StringColumn and DoubleColumn (not nullable) …

sqlite system.data.sqlite
Sqlite Online Backup Using System.Data.Sqlite

How can a sqlite database be backed up in native C# code while the database is still online? All of …

c# sqlite system.data.sqlite
System.Data.Sqlite not being recognized by Visual Studio 2010 on Win 2K8 Server machine

I have a Windows Server 2008 (64-bit) box that I am doing development on. I've installed Visual Studio 2010 and System.Data.…

visual-studio-2010 windows-server-2008-r2 system.data.sqlite