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'

Yahia · Accepted Answer · 2012-02-07 09:11:54Z

95

try

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

edited Feb 7, 2012 at 9:11

answered Feb 7, 2012 at 9:05

Yahia

70.5k9 gold badges117 silver badges147 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Steztric Over a year ago

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

AZ_ Over a year ago

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

Skorunka František Over a year ago

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

everydayXpert · Accepted Answer · 2017-10-16 09:07:26Z

7

I'm using this:

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

answered Oct 16, 2017 at 9:07

everydayXpert

8572 gold badges13 silver badges29 bronze badges

Comments

murzagurskiy · Accepted Answer · 2017-02-21 07:20:17Z

4

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

It's knowledge from forum question

answered Feb 21, 2017 at 7:20

murzagurskiy

1,3431 gold badge21 silver badges51 bronze badges

2 Comments

Andez Over a year ago

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

ghord Over a year ago

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

Collectives™ on Stack Overflow

How can I create an in memory sqlite database?

3 Answers 3

3 Comments

Comments

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

3 Comments

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related