How to load a disk-based database to in-memory database using Sqlite in Mono?

Question

Can I load a disk-database file (.db) to a in-memory database created by :memory: in Sqlite? I am using Mono, and Mono.Data.Sqlite is the library I am linking to. Does anyone know how to do that? or can anyone point me to a document for this library? Thanks!

-gb

Cesar A. Rivas · Accepted Answer · 2011-02-27 02:09:17Z

1

you should use the SQLite Backup API. here is a couple of links.

Using the SQLite Online Backup API

Online Backup API

answered Feb 27, 2011 at 2:09

Cesar A. Rivas

1,3551 gold badge10 silver badges13 bronze badges

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

6 Comments

gambellhq Over a year ago

Thanks for your reply! The problem is all those functions are C functions. But what I can use in Mono is an ADO.Net provider and has no functions as these...

Samuel Neff Over a year ago

@gambellhq, if you want to take advantage of SQLite specific features you'll need to use SQLite specific code, not just standard ADO.NET APIs. Even if Mono doesn't expose these functions, you can call them directly with the right pinvoke calls (we do this with SQLite on Windows in .NET, so I assume Mono would work the same).

gambellhq Over a year ago

@Samuel, thanks! I am new to Mono and Sqlite, can you give a brief example about how I can make pinvoke calls to its C function?

Samuel Neff Over a year ago

@gambellhq, your best bet is to look at the included SQLite wrapper source (not the core C code, the MONO code that calls into SQLite).

gambellhq Over a year ago

@Samuel, OK, will do that. Thanks!

|

Collectives™ on Stack Overflow

How to load a disk-based database to in-memory database using Sqlite in Mono?

1 Answer 1

6 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

6 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related