Multiple Update Statements Throw "cannot Open"

I am getting a 'cannot open' exception when I try to do multiple updates on the same table in the same transaction on SQLite in WinRT. I have created a sample application for this

Solution 1:

You've probably stumbled across the same bug in sqlite-net that I have. I've created a fix which has already been pulled back into the main fork but there hasn't been a new release on NuGet since then. You could download the latest sources directly and check if it fixes your problem.

Solution 2:

Adding this code right after opening the database will solve the problem ( both when sideloaded as well when the app gets downloaded through store)

verifySQLResult(SQLite3.Execute(_db, "PRAGMA temp_store = memory;", 0, 0, 0));

source:

https://github.com/praeclarum/sqlite-net/issues/78