Path to store SQLite database in Xamarin Android

Question

I'm trying to store a local SQLite database in the internal storage of the device. When I was using an emulator , this:

static string dbName = "totems.sqlite";
string dbPath = Path.Combine (Android.OS.Environment.ExternalStorageDirectory.ToString (), dbName);

worked fine. But when I tried to debug on my Nexus 5, it didn't work, because it doesn't have external storage. I searched where to store it so it could run on my Nexus as well. I replaced it with:

static string dbName = "totems.sqlite";
string dbPath = Path.Combine ("/data/data/com.companyname.totem/databases/", dbName);

But now it doesn't work on my Nexus 5 and it doesn't work on my emulator. It says it can't find the path.

What am I doing wrong?

Thanks in advance.

Coder Absolute · Accepted Answer · 2016-10-06 12:50:00Z

4

I know this is an old thread, but the old answer has a typo. The working syntax should be :

string path = Path.Combine(System.Environment.GetFolderPath(System.Environment.SpecialFolder.Personal), "DatabaseName.txt");

answered Oct 6, 2016 at 12:50

Coder Absolute

6,4775 gold badges31 silver badges41 bronze badges

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

Comments

Michiluki · Accepted Answer · 2015-11-24 17:36:20Z

1

Im using the following code:

string path = Path.Combine(System.Enviroment.GetFolderPath(System.Enviroment.SpecialFolder.Personal), "data.txt");

I think that should write into the internal storage like you want

answered Nov 24, 2015 at 17:36

Michiluki

5053 silver badges17 bronze badges

1 Comment

tequila slammer Over a year ago

This is the way to go.

Rauland · Accepted Answer · 2020-02-08 06:00:36Z

From docs.com

LocalApplicationData: The directory that serves as a common repository for application-specific data that is used by the current, non-roaming user.

Personal: The directory that serves as a common repository for documents. This member is equivalent to MyDocuments.

From this I use:

var db_directory = Path.Combine(System.Environment.GetFolderPath(System.Environment.SpecialFolder.LocalApplicationData),"databases"))

var db_path = Path.Combine(db_directory,"data.db");

Also from this sample (XF)
docs.com xamarin tutorial

public static Database Database
        {
            get
            {
                if (database == null)
                {
                    database = new Database(Path.Combine(Environment.GetFolderPath(Environment.SpecialFolder.LocalApplicationData), "people.db3"));
                }
                return database;
            }
        }

Collectives™ on Stack Overflow

Path to store SQLite database in Xamarin Android

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related