tagged [sqlite]
In C#, is there any way to have an in-memory file linked as an in-memory SQLite database with System.Data.SQLite?
In C#, is there any way to have an in-memory file linked as an in-memory SQLite database with System.Data.SQLite? What I want to do is something along the lines of the following: ``` using System.Data...
- Modified
- 31 May at 17:22
SQLite string contains other string query
SQLite string contains other string query How do I do this? For example, if my column is "cats,dogs,birds" and I want to get any rows where column contains cats?
How can one see the structure of a table in SQLite?
How can one see the structure of a table in SQLite? How can I see the structure of table in [SQLite](http://en.wikipedia.org/wiki/SQLite) as `desc` was in Oracle?
- Modified
- 26 May at 20:30
how to drop database in sqlite?
how to drop database in sqlite? I'm using SQLite in android. I want to drop the database. For example: `mysql- drop database dbname` How do I implement this code in SQLite?
SQLite.Net Issue With BeginTransaction
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 code directly out of the documentatio...
- Modified
- 15 Mar at 12:58
What is the best way to connect and use a sqlite database from C#
What is the best way to connect and use a sqlite database from C# I've done this before in C++ by including sqlite.h but is there a similarly easy way in C#?
Difference between 2 dates in SQLite
Difference between 2 dates in SQLite How do I get the difference in days between 2 dates in SQLite? I have already tried something like this: It returns 0 every time.
- Modified
- 23 Oct at 21:29
What is the difference between connection.Close() and connection.Dispose()?
What is the difference between connection.Close() and connection.Dispose()? I noticed that the `SQLiteConnection` object in `System.Data.SQLite` owns two similar methods : - `Close()`- `Dispose()` Sam...
- Modified
- 18 Jun at 12:26
SQLite.net SQLiteFunction not working in Linq to SQL
SQLite.net SQLiteFunction not working in Linq to SQL I've created a handful of custom SQLite functions in C# using System.Data.SQLite.SQLiteFunction. It works great when using SQLiteDataAdapter to exe...
- Modified
- 16 Nov at 17:30
SQL escape with sqlite in C#
SQL escape with sqlite in C# I have a text field and its breaking my sql statement. How do i escape all the chars in that field? I am using sqlite with [http://sqlite.phxsoftware.com/](http://sqlite.p...
ServiceStack SQLITE_LOCKED
ServiceStack SQLITE_LOCKED I get some troubles with my sqlite database, I get SQLITE_LOCKED and SQLITE_BUSY when I try to insert data, but not every time it's quite random. Shall I close my connection...
- Modified
- 29 Jan at 17:8
How to delete or add column in SQLITE?
How to delete or add column in SQLITE? I want to delete or add column in sqlite database I am using following query to delete column. But it gives error
- Modified
- 7 Jul at 02:24
Change SQLite database mode to read-write
Change SQLite database mode to read-write How can I change an SQLite database from read-only to read-write? When I executed the update statement, I always got: > SQL error: attempt to write a readonly...
- Modified
- 31 Jan at 18:48
How to open SQLite connection in WAL mode
How to open SQLite connection in WAL mode In C#, how to open an SQLite connection [in WAL mode](http://www.sqlite.org/wal.html)? Here is how I open in normal mode:
Execute SQLite script
Execute SQLite script I start up sqlite3 version 3.7.7, unix 11.4.2 using this command: where auction.db has not already been created. ``` sqlite> auction.db
- Modified
- 25 Jul at 06:3
ServiceStack Ormlite issuing Sqlite specific command
ServiceStack Ormlite issuing Sqlite specific command I am running Ormlite against a sqlite database. Love it. I am adding and deleting lots of records and find that the database does well with an occa...
- Modified
- 23 Aug at 15:5
Any way to enforce numeric primary key size limit in sql?
Any way to enforce numeric primary key size limit in sql? I'd like to create a table which has an integer primary key limited between 000 and 999. Is there any way to enforce this 3 digit limit within...
Is there a .NET/C# wrapper for SQLite?
Is there a .NET/C# wrapper for SQLite? I'd sort of like to use SQLite from within C#.Net, but I can't seem to find an appropriate library. Is there one? An official one? Are there other ways to use SQ...
How to set Sqlite3 to be case insensitive when string comparing?
How to set Sqlite3 to be case insensitive when string comparing? I want to select records from sqlite3 database by string matching. But if I use '=' in the where clause, I found that sqlite3 is case s...
- Modified
- 17 Dec at 10:53
How to disable conventions in Microsoft.EntityFrameworkCore?
How to disable conventions in Microsoft.EntityFrameworkCore? I'm using SQLite with EFCore, but I got a problem... how can I disable Conventions like Pluralize? Is it possible? My ModelBuilder has not ...
- Modified
- 20 Apr at 18:22
Is it possible to access an SQLite database from JavaScript?
Is it possible to access an SQLite database from JavaScript? I have a set of HTML files and a SQLite database, which I would like to access from the browser, using the file:// scheme. Is it possible t...
- Modified
- 25 Jun at 17:33
How do I view the SQLite database on an Android device?
How do I view the SQLite database on an Android device? I have a set of data in an SQLite database. I need to view the database on a device. How do I do that? I have checked in ddms mode. The data in ...
How to find SQLITE database file version
How to find SQLITE database file version I have few sqlite database files. I want to know the database file version i.e if the database was created with sqlite2 or sqlite3 or any other main/sub versio...
HOWTO: SQLite with EntityFramework and Code-First
HOWTO: SQLite with EntityFramework and Code-First I am trying to create an embedded SQLite database on the fly with the EF however, I can't get it to work, the database file is never getting created. ...
- Modified
- 23 Jul at 20:1