How to reference SQLite database that already exists in Xamarin.Android?

Question

I have created SQLite database and have copied it in the root of the project like that:

The database is called MobileSell.db It appears in Visual Studio like that:

My question is how can I reference it so afterwards I can say connection.InsertIntoTableArticles(value)(this is pseudo code)

Please refer to this

Robbit
– Robbit

2018-01-15 02:59:29 +00:00
Commented Jan 15, 2018 at 2:59 — Robbit
– Robbit, Commented Jan 15, 2018 at 2:59
Have you solved your problem?

Robbit
– Robbit

2018-01-15 09:53:59 +00:00
Commented Jan 15, 2018 at 9:53 — Robbit
– Robbit, Commented Jan 15, 2018 at 9:53

Robbit · Accepted Answer · 2018-01-15 09:53:44Z

1

You can refer to this.

There only three steps to achieve it:

1) Create Assets folder which is parallel with Resources folder in your project, put your .db file into it.

2) Copy the .db file to SDCard when first open the app;

3) Use SQLite.SQLiteConnection(path) to open your .db and query it.

answered Jan 15, 2018 at 9:53

Robbit

4,3581 gold badge16 silver badges29 bronze badges

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

4 Comments

Profile2ForStack Over a year ago

Could you give more details on point 2) Copy the .db file to SDCard when first open the app?

Robbit Over a year ago

Please use BinaryReader to read from your .db file and use BinaryWriter to write to you sdcard. In Android, you can't open .db from Assets or raw directly, so you need copy it to other folder, and this SQLite.SQLiteConnection(path) can open any folder.

Profile2ForStack Over a year ago

Instead of copying .db to SDCard, could I copy the .db file into the apk folder of the app and then reference it from there like that: SQLite.SQLiteConnection(path-to-apk-folder)?

Robbit Over a year ago

Yes, like /data/data/package name/test.db

Collectives™ on Stack Overflow

How to reference SQLite database that already exists in Xamarin.Android?

1 Answer 1

4 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related