How can I create an in memory sqlite database?

Question

I have tried SQLiteConnection(":memory:") and SQLiteConnection("sqlite::memory:") but both of these fail with 'Invalid ConnectionString format'

Nauplius

Answer 1

try

var connection = new SQLiteConnection("Data Source=:memory:");

Rhapsodize

This doesn't work for me. I get an exception 'The path is not of a legal form.' – Autonomic

@Autonomic try not putting a space between Data Source => new SqliteConnection("DataSource=:memory:") – Morganstein

var connection = new SqliteConnection("Filename=:memory:"); – Creosote

Answer 2

I'm using this:

var connectionStringBuilder = new SQLiteConnectionStringBuilder { DataSource = ":memory:" };
var connection = new SQLiteConnection(connectionStringBuilder.ToString());

Qualifier

Answer 3

Maybe it's too late, but FullUri=file::memory:?cache=shared; is working.

It's knowledge from forum question

Padegs

Any more info? I get System.ArgumentException : Keyword not supported: 'fulluri'. using var connection = new SqliteConnection("FullUri=file::memory:?cache=shared;"); – Architect

@Andrez Lowercase SqliteConneciton you are using is from different package Microsoft.Data.Sqlite which doesn't work with FullUri parameter. – Piano