Copy sqlite database from file to: memory using c #

Question

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

I am currently using:

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

To get the whole table schema out of the file database, however, I'm not quite sure how to start creating these tables in a new memory database and copying all the relevant data.

---

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

Answer 1

. 1: API SQLite Online.