Xamarin Android how to retrieve device database

Question

I have created Sqlite database using

var documents = Environment.GetFolderPath (Environment.SpecialFolder.MyDocuments);
pathToDatabase = Path.Combine(documents, databaseName);

using (var conn= new SQLite.SQLiteConnection(pathToDatabase))
{
            conn.CreateTable<SETTINGS> ();
            conn.CreateTable<USER> (); 
}

I want to see(using Sqlite Browser) the database created. How to access the database? I have tried through Xamarin Studio -> Tools -> Android Device Monitor. There is nothing like /data/data/app/databases/test.db

data folder doesn't show any contents. However, i am sure that the database is created as i can query and retrieve the data.

On actual device. When i expand data folder from Android Device Monitor, there is nothing in. — User382
– User382, Commented Oct 19, 2015 at 13:52

Jared · Accepted Answer · 2015-10-19 15:37:49Z

3

You can't access the database file on an actual device unless it's rooted. That file system access is restricted to prevent people from easily gaining access to the data of your application.

The examples you're seeing that are explaining how to access your database on the file system are assuming you're using an emulator.

answered Oct 19, 2015 at 15:37

Jared

7021 gold badge5 silver badges12 bronze badges

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

2 Comments

User382 Over a year ago

How to validate the database then. Is there a way on android to copy the database to desktop and access it.

Jared Over a year ago

The way to validate it is to use an emulator. There are emulators included in the SDK, or you can use third-party options, like Genymotion (genymotion.com/#!).

Community · Accepted Answer · 2017-05-23 11:50:42Z

0

Your database is located at files folder from your app directory (e.g. "/data/data/ProjectName.ProjectName/files")

I suggest you take a look at the following link where you'll find the Monodroid environment variables

edited May 23, 2017 at 11:50

CommunityBot

11 silver badge

answered Oct 19, 2015 at 6:18

daniherculano

3831 gold badge9 silver badges26 bronze badges

2 Comments

User382 Over a year ago

Yes thats what is the correct path i have. When i expand data folder from Android Device Monitor, there is nothing in. it doesn't show data/ProjectName.ProjectName/files

daniherculano Over a year ago

As Jared told you, if you are trying on device it must be rooted

Suchith · Accepted Answer · 2017-07-17 08:15:38Z

0

You can copy the DB file programmatically from device internal path to device Download folder and from there you can access it. For more details you can check by blog post here: http://www.appliedcodelog.com/2017/07/how-to-fetch-android-sqlite-db-file.html

answered Jul 17, 2017 at 8:15

Suchith

1,5571 gold badge20 silver badges44 bronze badges

Collectives™ on Stack Overflow

Xamarin Android how to retrieve device database

3 Answers 3

2 Comments

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related