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?

had you able to fulfill your need?? I am also looking for the same apis in C# program. if yes please help me on this as well. — Mubashar
– Mubashar, Commented Jan 18, 2011 at 5:57

Doug Currie · Accepted Answer · 2010-03-14 22:59:03Z

0

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

answered Mar 14, 2010 at 22:59

Doug Currie

41.4k1 gold badge103 silver badges121 bronze badges

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

2 Comments

davidb Over a year ago

That is fairly helpful, however, I am not sure how to use those functions when using the ADO style of System.Data.SQLite

davidb Over a year ago

Further research suggests that these functions are not yet available in System.Data.SQLite, but the developer states that they are "coming soon"

Collectives™ on Stack Overflow

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

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related