How can I create an in memory sqlite database?

Solution 1:

try

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

Solution 2:

I'm using this:

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

Solution 3:

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

It's knowledge from forum question