FileNotFoundException Error creating Database WP8 Sqlite

Question

I am following this tutorial to create an application with an SQLite database.

When I executed it, I got System.IO.FileNotFoundException pointing to the file SQLite.cs, the line where the error originated is shown in the screen shot below(in the SQLite.cs file)

error line

Below is the code snippet for creating a database

string dbPath = Path.Combine(Windows.Storage.ApplicationData.Current.LocalFolder.Path, "db.sqlite");
if (!FileExists(dbPath).Result)
{
   using (var db = new SQLiteConnection(dbPath))
   {
        db.CreateTable<Person>();
   }
}

and the method FileExists

        private async Task<bool> FileExists(string fileName)
        {
            var result = false;
            try
            {
                var store = await Windows.Storage.ApplicationData.Current.LocalFolder.GetFileAsync(fileName);
                result =true;
            }
            catch
            {
            }

            return result;

        }

I am wondering what went wrong. Any help?

Why do you use File.Exists without passing the path used to create the file? — Steve
– Steve, Commented Nov 26, 2014 at 16:03
@Steve I just corrected that now and the same error still persist — Sunday Okpokor
– Sunday Okpokor, Commented Nov 26, 2014 at 16:07
The ! operator will flip the result so if FileExists returns false then the code will run which is not what you want I think. — MisterXero
– MisterXero, Commented Nov 26, 2014 at 17:07

Alberto Solano · Accepted Answer · 2014-11-26 17:17:47Z

1

With the line if (!FileExists(dbPath).Result) you're saying that if the file doesn't exist, connect to the database and create a table. So your condition is wrong, because the line

Windows.Storage.ApplicationData.Current.LocalFolder.GetFileAsync(fileName)

wants an existing file to execute correctly. Correct then your if condition with:

if (FileExists(dbPath).Result)

answered Nov 26, 2014 at 17:17

Alberto Solano

8,2653 gold badges40 silver badges62 bronze badges

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

Collectives™ on Stack Overflow

FileNotFoundException Error creating Database WP8 Sqlite

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