Hi ,
I believe that the file sample will help you on this
http://code.msdn.microsoft.com/windowsapps/File-access-sample-d723e597
Since you are using Sqlite , getting the db and copying to the App's local folder all you have to do afterwards is to point to the new location.
Here's some code . I used it to keep a backup of my database
private StorageFolder m_downloadfolder;
public StorageFolder Download_Folder
{
get { return m_downloadfolder; }
set { m_downloadfolder = value; }
}
public async void KeepBackup()
{
await KeepTheBackup();
}
private async Task KeepTheBackup()
{
Boolean searchResult = false;
StorageFolder storageFolder = KnownFolders.MusicLibrary; //Let's say that you have in there the db
try
{
//Get your file
StorageFile sampleFile = await storageFolder.GetFileAsync("mydatabase.db");
searchResult = true;
}
catch (Exception)
{
searchResult = false;
}
if (searchResult == true)
{ //found the database so proceed with the copy --------
Download_Folder = ApplicationData.Current.LocalFolder // it returns your app's local folder.This is your destination folder
await sampleFile.CopyAsync(Download_Folder);
sampleFile = await Download_Folder.GetFileAsync("MyDatabase.db");
//check now if the sampleFile is not null and if the copy succeeded
}
}
now since that your app finishes the copy connect to the new path
//create a property and put it in your App.Xaml.cs . FYI whatever you put in there you can have globally in your app
private string m_dbpath;
public string dbpath
{
get { return m_dbpath; }
set { m_dbpath = value; }
}
public SQLite.SQLiteConnection MyConnection()
{
this.dbpath = Path.Combine(Windows.Storage.ApplicationData.Current.LocalFolder.Path, "MyDatabase.db");
var db = new SQLite.SQLiteConnection(this.dbpath);//the db path points now to your new local folder.
return db;
}
Now whenever you call the above it returns you the db connection
Hope I helped you
thank you
