protected void CommitTransaction()
{
using (var cmdUpdateVersion = new DbCommandRedundant($"UPDATE params SET value = \"{Version}\" WHERE SECTION=\"DATABASE\" AND `key`=\"VERSION\"", Connection))
cmdUpdateVersion.ExecuteNonQuery();
_transaction.Commit();
_transaction = null;
}
public int GetCurrentVersion()
{
using (var command = new DbCommandRedundant("select value from params where SECTION=\"DATABASE\" and `key`=\"VERSION\"", _connection))
{
var dbVersionNr = 0;
try
{
string dbVersionStr;
lock (_connection)
dbVersionStr = (string)command.ExecuteScalar();
if (dbVersionStr != null)
{
int.TryParse(dbVersionStr, out dbVersionNr);
}
}
catch
{
// ignored
}
return(dbVersionNr);
}
}