System.Data.SQLite

Hi,

Up until now I have been using the standard:

SQLiteConnection cnn = new SQLiteConnection("Data Source=" + fileName);
 

method to open a database.

Now i'd like to read the database from an existing C# Stream.

Any advice on if this is possible and if so how to go about it would be much appreciated.

Thanks in advance! 

This unfortunately is impossible.  A C# stream is a .NET construct that can be memory, file, or <insert implementation here> based, and SQLite is an unmanaged database engine.  SQLite requires a file, located on a filesystem that supports locking portions of the file ... alternatively it can be used in-memory, but there's no support for any other kind of underlying store.

Robert

Robert thanks, that all makes sense!

Is it possible to read a stream containing a database into some datastructure in memory and make a connection using that?