Top "System.data.sqlite" questions

System.

System.Data.SQLite parameterized queries with multiple values?

I am trying to do run a bulk deletion using parameterized queries. Currently, I have the following code: pendingDeletions = new …

c# parameters system.data.sqlite
Multiple access to a single SQLite database file via System.Data.SQLite and c#

As I can read from SQLite FAQ it supports multiple processes reading (SELECT) and only one process writing (INSERT, UPDATE, …

c# database sqlite locking system.data.sqlite
SQLite with Entity Framework

I'm having a problem with primary keys in Entity Framework when using SQLite. SQLite wants an explicit NULL in the …

entity-framework system.data.sqlite
What is a mixed mode assembly?

I am looking at the System.Data.SQLite download page, and it lists mixed mode assembly for .NET 4 and a …

sqlite .net-4.0 assemblies system.data.sqlite
What does "Data Source cannot be empty. Use :memory: to open an in-memory database" mean?

I recently converted my SQL Server database into SQLite DB. But when I try to open my SQLite using .Open() …

c# system.data.sqlite
C# SQLite Parameterized Select Using LIKE

I am trying to do an SQL query such as SELECT * FROM [TABLE] WHERE hostname LIKE '%myhostname%'; This …

c# sqlite system.data.sqlite
With System.Data.SQLite how do you specify a database file in the connect string using a relative path

Wanting to deploy my project on different servers I would prefer to be able to specify a connect string using …

c# sqlite connection-string system.data.sqlite
How to Close Sqlite Connection without explicitly calling Close Method using .NET

I am creating desktop application in winform that will use Sqlite Database. So I created Sqlite Helper class that uses …

c# .net sqlite database-connection system.data.sqlite
How do I create and persist a SQLite DB from scratch in code using System.Data.SQLite and C#?

I have a database creation tool and am creating a database from scratch. This is done the same way as …

c# sqlite system.data.sqlite
System.Data.SQLite vs Microsoft.Data.Sqlite

What are the differences between System.Data.SQLite and Microsoft.Data.Sqlite? I understand that System.Data.SQLite is older …

.net sqlite system.data.sqlite