System.Data.SQLite
View Ticket
Not logged in
Ticket UUID: 0fced13729ff1c68cf5e2a21dbef936bbabe1e27
Title: SQLiteConnection constructed from a Stream object
Status: Closed Type: Feature_Request
Severity: Cosmetic Priority: Low
Subsystem: Integration_Via_PInvoke Resolution: Rejected
Last Modified: 2012-09-19 23:04:46
Version Found In: 1.0.79.0
Description:
If I'm creating an SQLiteConnection manually, it would be nice to be able to pass in a Stream object, rather than using a connection string.

Uses:

- Open read-only databases inside ZIP files without copying them to a temporary file.

- Do weird things with file handle (e.g. delete-on-close, sharing flags, control caching, memory-mapped file).

- http://stackoverflow.com/questions/6191155/in-c-is-there-any-way-to-have-an-in-memory-file-linked-as-an-in-memory-sqlite (20 upvotes)

<hr /><i>mistachkin added on 2012-03-12 03:15:30 UTC:</i><br />
Is there something wrong with using the in-memory support already provided by the native SQLite library and System.Data.SQLite (i.e. using "Data Source=:memory:" in the connection string)?