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.
- 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)?