Does C#-Sqlite support in-memory databases?

536 views
Skip to first unread message

swquinn

unread,
Jan 19, 2012, 12:22:37 AM1/19/12
to C#-SQLite
I'm relatively new to SQLite, but it is pertinent to my interests, and
I'm trying to proof of concept out a few things, among them I was
starting with an evaluation of NHibernate and C#-SQLite.

However, as far as I can tell, the connection string for an in-memory
database, "Data Source=:memory:" does not appear to be supported with
the most recent code available on Google Code. Supplying a value
of :memory: results in an "Invalid URI" exception, and looking at the
source for the Community.CsharpSqlite.SQLiteClient.SqliteConnection
there appears to be no support for in-memory databases.

Are in-memory databases supported? What would the connection string be
if I wanted to use one?

Thanks!

Noah

unread,
Jan 20, 2012, 3:36:44 PM1/20/12
to C#-SQLite
file::memory: should work just fine

Noah

swquinn

unread,
Jan 20, 2012, 10:57:37 PM1/20/12
to C#-SQLite
Thanks!

I had originally tried that, but was getting a different error (though
I got further along). I think I finally figured out that I was trying
to use a semi-colon (;) as a delimiter when the CsharpSqliteClient
appears to want a comma (,).

I'll fix my connection string and try again with "file::memory".
Reply all
Reply to author
Forward
0 new messages