In-memory database possible?

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for SQLite
Post Reply
Marc V
Posts: 6
Joined: Wed 30 Mar 2011 07:46

In-memory database possible?

Post by Marc V » Thu 09 Feb 2012 08:21

I'm looking for a way to use in-memory temp databases. So I don't want it to write to disk.

Is this possible?

Pinturiccio
Devart Team
Posts: 2420
Joined: Wed 02 Nov 2011 09:44

Post by Pinturiccio » Thu 09 Feb 2012 09:37

Yes, in-memory database is supported by dotConnect for SQLite. To use an in-memory database, set DataSource to :memory:

Code: Select all

SQLiteConnection conn = new SQLiteConnection("DataSource=:memory:");

Marc V
Posts: 6
Joined: Wed 30 Mar 2011 07:46

Post by Marc V » Thu 09 Feb 2012 10:56

Aaah, couldn't be simpler :). Thanks.

Post Reply