pragma user_version = 1 not working

[klimaye]

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()