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.
Shareable in-memory databases
In-memory databases can be shared between multiple connections by using
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.
Submit and view feedback for