Installing new version of Sqlite looses the database

Question

Hi ,

I have built a metro UI c# app with sqlite database support.

Does anyone face the issue after installing the new sqlite version (any version) , looses the database data after the first connect ??? Is there any way to avoid this because users are going to loose their data.

Does anyone has an idea on how to resolve this ?

Appreciate any help you could give me on this.

thank you

Answer 1

You shouldn't have a problem with this. Make sure your app isn't overwriting the database when it updates and doesn't change its schema without conversion.

Without knowing how your app works it is difficult to provide more specific help.

--Rob

Answer 2

Hi Rob ,

I'm doing the below

var db = new SQLite.SQLiteConnection("my path");

db.RunInTransaction(() =>
                {

                    MySearchCompanies = db.Query<MyApp.App.tbSearchCompanies>("select * from tbSearchcompanies");

                });
                db.Dispose();

I believe the new Sqlite.SqliteConnection causes the issue.

I will take a closer look and revert Rob.

thank you

Answer 3

Hi Rob , 

No it is not the new sqlite connection.

When the App launches I'm running the below line of code

 this.dbpath = Path.Combine(Windows.Storage.ApplicationData.Current.LocalFolder.Path, "mydatabase.db");

And then 

  StorageFolder storageFolder = ApplicationData.Current.LocalFolder;

 StorageFile databaseFile = await storageFolder.GetFileAsync("mydatabase.db");

Does this Path.Combine causes the issue ??

Perhaps needs to check first if the database file exists ?????

thank you

Answer 4

You were right Rob. Found the bug just a few lines below. I'm sorry.

Thank you