Can I copy from one SQLite database to another when using C# Xamarin.Forms?

Question

My application creates tables like this:

    public DataAccess()
    {
        dbcon = DependencyService.Get<ISQLite>().GetConnection();
        // create the tables
        dbcon.CreateTable<Category>();
        dbcon.CreateTable<Settings>();

What I would like to do is to have two databases. One that holds all the user data and one that is refreshed when the application is updated.

As part of the update process I would like to add data from the new database to the existing user database.

Is it possible to open two connections to different databases and also how can I get data from one database and add it to the other? Could I for example do a SQL Select that sp[ans two databases?

Kai Brummund · Accepted Answer · 2016-10-16 10:05:43Z

2

The DependencyService is a simple IOC Container. It only supports getting either a new or a global instance for one interface.

One options here are to have different interfaces for your UpdateDatabase and your UserDatabase, so you could retrieve them (it could be an inherited inferface, or your db-class just implements them both):

var db1 = DependencyService.Get<ISQLite>().GetConnection();
var db2 = DependencyService.Get<ISQLiteUpdateDb>().GetConnection();

To copy over, you still have retrieve all data an then just insert into the second one:

var data = db1.Table<YourModel>().ToList();
db2.InsertAll(data);

(Assuming, you are using sqlite-net-pcl.)

answered Oct 16, 2016 at 10:05

Kai Brummund

3,5683 gold badges26 silver badges34 bronze badges

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

Collectives™ on Stack Overflow

Can I copy from one SQLite database to another when using C# Xamarin.Forms?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest