I cannot create SQLiteConnection in PCL version of Sqlite.net on WP8

Question

I'm using a PCL version of Sqlite.net from https://github.com/oysteinkrog/SQLite.Net-PCL This code below doesn't work for some reasons on WP8:

var sqliteFilename = Path.Combine(ApplicationData.Current.LocalFolder.Path, "MyDB.db3");
var db = new SQLiteConnection(new SQLitePlatformWP8CSharp(), sqliteFilename);

And I am receiving this error:

An exception of type 'SQLite.Net.SQLiteException' occurred in SQLite.Net.DLL but was not handled in user code

Additional information: Could not open database file: C:\Data\Users\DefApps\AppData\{149B7F85-2C71-4BEF-984F-903BA7DB80DA}\Local\MyDB.db3 (CannotOpen)

What I am doing wrong? Thank you!!!

Sergey · Accepted Answer · 2014-01-08 16:09:17Z

1

@Sergey-Chesalin thank you for your answers. I checked and found that it should create DB when it's not available. After my research I found why it doesn't work as it should.

For some reasons they add additional symbol to the connection string, see Line 121 in SQLiteConnection.cs and Line 196 in SQLiteConnection.cs. Maybe it works as expected in iOS/Android/WinRT versions of ISQLiteApi implementations, but it doesn't work as it should for Windows Phone.

So in order to fix it I have changed this line:

string dbFileName = Encoding.UTF8.GetString(filename, 0, filename.Length);

To this:

string dbFileName = Encoding.UTF8.GetString(filename, 0, filename.Length - 1);

in the SQLite.Net-PCL/blob/master/src/SQLite.Net.Platform.WindowsPhone8.CSharpSqlite/SQLiteApiWP8.cs line 12

edited Jan 8, 2014 at 16:09

answered Jan 4, 2014 at 16:56

Sergey

1,24316 silver badges21 bronze badges

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

Comments

wolfen · Accepted Answer · 2014-01-02 08:59:13Z

0

Have you marked your database file file as content in project? And you can explore deployed project with ISETool or something with GUI like this to check for file existence by this path.

answered Jan 2, 2014 at 8:59

wolfen

814 bronze badges

3 Comments

Sergey Over a year ago

I think that new DB must be created if it doesn't exists. Am I right?

wolfen Over a year ago

@Sergey Original SQLite.net creates database when it's not available, but this fork uses different implementation, so you can check yourself and add source code of this library to your project and check what is happening in debugger. I have used different SQLite implementation. But SQLite is pretty slow if you need store big amounts of data. During optimization i found that reflection operations are abnormally slow on WP.

wolfen Over a year ago

@Sergey maybe you can try different naming scheme for accessing isolated storage, because library uses Silverlight underneath not WP8 libraries. Two variants are: "isostore:/MyDB.db3" and "ms-appdata:///local/MyDB.db3"

Collectives™ on Stack Overflow

I cannot create SQLiteConnection in PCL version of Sqlite.net on WP8

2 Answers 2

Comments

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related