koush/sqlite-net — Issue #2: pragma user_version = 1 not working
Author: klimaye
Created: 2012-01-14 17:13:40+00:00
State: open

I have been using the sqlite.net on monodroid.

I am unable to upgrade (using Execute) the user_version of the db using ]pragma user_version = 1'

_connection.Trace = true;
_connection.Execute(string.Format(@"pragma user_version={0}", version));
_connection.Trace = false;

I am suspecting that it might even be upgrading it but I always receive 0 if I do the following

_connection.Query("pragma user_version").FirstOrDefault()