Database File Location for SQLite within MonoDroid

Question

When using the following code to copy a SQLite database from an Assets folder , the output is being put in the following folder: "/data/data/AndroidTestDb.AndroidTestDb/files/AndroidTestDup.db"

Here is the code:

Stream myInput = Assets.Open(@"AndroidTest.db");

string outFileName=System.IO.Path.Combine(System.Environment.GetFolderPath 
(System.Environment.SpecialFolder.Personal), "AndroidTestDup.db");

Stream myOutput = new FileStream(outFileName, FileMode.OpenOrCreate);

And the desired folder +filename is :

"/data/data/AndroidTestDb.AndroidTestDb/databases/AndroidTestDup.db"

Thanks in Advance.

Ian · Accepted Answer · 2013-03-10 04:50:48Z

6

Use Context.GetDatabasePath to obtain the filesystem path for your database file:

// Assuming a Context subclass, e.g. an Activity
string dbPath = GetDatabasePath("AndroidTestDup.db").AbsolutePath;

edited Mar 10, 2013 at 4:50

Ian

5,75511 gold badges63 silver badges95 bronze badges

answered Jun 21, 2011 at 2:39

jonp

13.6k5 gold badges47 silver badges61 bronze badges

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

Comments

MByD · Accepted Answer · 2011-06-12 03:54:11Z

3

There is no direct way, the closest I can think of is:

// someContext may be the current activity
String outFileName = someContext.getFilesDir().getParent().getAbsolutePath() + "/databases/AndroidTestDup.db";

answered Jun 12, 2011 at 3:54

MByD

138k30 gold badges269 silver badges278 bronze badges

Comments

Venkadeshwaran · Accepted Answer · 2011-06-18 10:50:16Z

0

My idea to find out the sqlite database in monodroid is,

-First Install any android File Explorer application in your emulator.
-Then using the application just select any location you want to store your database.
-Then Use "adb push " command in adb. to copy your source
database to a mobile location that
you have selected.
-So now you know path of the database.
-Just use that path in your program.

Thank you...

answered Jun 18, 2011 at 10:50

Venkadeshwaran

261 silver badge6 bronze badges

Collectives™ on Stack Overflow

Database File Location for SQLite within MonoDroid

3 Answers 3

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related