In-memory databases

SQLite in-memory databases are databases stored entirely in memory, not on disk. Use the special data source filename :memory: to create an in-memory database. When the connection is closed, the database is deleted. When using :memory:, each connection creates its own database.

Data Source=:memory:

Shareable in-memory databases

In-memory databases can be shared between multiple connections by using Mode=Memory and Cache=Shared in the connection string. The Data Source keyword is used to give the in-memory database a name. Connection strings using the same name will access the same in-memory database. The database persists as long as at least one connection to it remains open. A sample demonstrating this is available on GitHub.

Data Source=InMemorySample;Mode=Memory;Cache=Shared