Copying an sqlite database from file to :memory using C#

Question

I have a small database with tables containing a small amount of data which I need to copy into memory.

Currently I am using:

insertcommand.CommandText = "SELECT sql FROM sqlite_master WHERE sql NOT NULL;";

To pull all the table schema from the file database, however I'm not really sure how to proceed with creating these tables in the new memory database, and copying all the relevant data across.

---

In short, how do I copy an SQLite database from file to memory using C# and System.Data.SQLite?

Answer 1

See Example 1: Loading and Saving In-Memory Databases on the SQLite Online Backup API page.