SQLite: How to connect to a database with a shared data warehouse?

Question

I am trying to use the shared cache function in SQLite 3.7.13 memory through the ADO.NET provider. The following connection string works, but gives a non-shared db cache:

Data Source=:memory: 

When I try any of them:

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

When opening a connection, I get the following ArgumentException :

 Invalid ConnectionString format for parameter "Data Source" 

What should be the connection string for SQLite in the cache sharing database?

Answer 1

It appears that although the shared caching feature was in SQLite, the latest version of System.Data.SQLite (1.0.81.0) at that time did not yet support the FullUri function. It seems that version 1.0.82.0 is working, and the connection string should be:

 FullUri=file::memory:?cache=shared