How do I connect to an in-memory, shared cache database?

Question

I'm trying out the in-memory shared cache feature of SQLite 3.7.13, via the ADO.NET provider. The following connect string works, but yields a non-shared-cache db:

Data Source=:memory:

When I try any of these:

Data Source=:memory:?cache=shared
Data Source=file::memory:?cache=shared
Data Source=file:x?mode=memory&cache=shared

I get the following ArgumentException when opening a connection:

Invalid ConnectionString format for parameter "Data Source"

What should the connect string look like for SQLite in-memory shared-cache databases?

lesscode · Accepted Answer · 2016-04-07 16:40:21Z

21

It looks like although the shared cache feature was in SQLite, the latest (1.0.81.0) version of System.Data.SQLite at the time didn't yet support the FullUri feature. Looks like the 1.0.82.0 version works, and the connection string should be:

FullUri=file::memory:?cache=shared

edited Apr 7, 2016 at 16:40

answered Sep 7, 2012 at 20:04

lesscode

6,3811 gold badge33 silver badges60 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

xmedeko Over a year ago

I have the version 1.0.99 and it must be with ToFullPath: FullUri=file::memory:?cache=shared;ToFullPath=false.

emilast Over a year ago

We could not get "FullUri" to work with Sqlite but found the solution here: forums.devart.com/viewtopic.php?t=26312#p119530: "DataSource=file:memdb1?mode=memory&cache=shared"

Butterfly Over a year ago

Thank you very much! This helped a lot! I modified your solution a little, and used the following, that additionally provides a name for a database: FullUri=file:memdb_name?mode=memory&cache=shared . This can be then attached by ATTACH DATABASE 'file:memdb_name?mode=memory&cache=shared' as sharedInMemoryDB;

Collectives™ on Stack Overflow

How do I connect to an in-memory, shared cache database?

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related