Change the directory of DataContext database file in WP8

Question

I am trying to change the location of the database file in my Windows Phone 8 app.

The default constructor places it in the root isolated storage directory: /MyDbFile.sdf/

public MyDataContext() : base("Data Source=isostore:/MyDbFile.sdf") { }

My goal is to put it in /db/MyDbFile.sdf

What I have tried (yes, I know that some of them are silly):

public MyDataContext() : base("Data Source=isostore:/db/MyDbFile.sdf") { }
public MyDataContext() : base("Data Source=isostore:/db\\MyDbFile.sdf") { }
public MyDataContext() : base("Data Source=isostore:\\db/MyDbFile.sdf") { }
public MyDataContext() : base("Data Source=isostore:\\/db/MyDbFile.sdf") { }
public MyDataContext() : base("Data Source=isostore:/db//MyDbFile.sdf") { }
public MyDataContext() : base("Data Source=isostore:/db\\/MyDbFile.sdf") { }

What is the proper way to do this? Is it even possible?

Marcin Kunert · Accepted Answer · 2014-05-21 07:45:48Z

2

Figured it right after writing this question. You have to create the target directory first.

using (var iso = IsolatedStorageFile.GetUserStoreForApplication())
{
    if (!iso.DirectoryExists("db"))
    {
        iso.CreateDirectory("db");
    }
}
_MyDataContext = new MyDataContext();

After that it works with:

public MyDataContext() : base("Data Source=isostore:/db/MyDbFile.sdf") { }

answered May 21, 2014 at 7:45

Marcin Kunert

6,3655 gold badges31 silver badges54 bronze badges

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

Collectives™ on Stack Overflow

Change the directory of DataContext database file in WP8

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

Related