public static void PopulateDBVersionTable()
{
using SQLiteConnection sqliteConn = CreateConnection();
sqliteConn.Open();
using DbTransaction dbTrans = sqliteConn.BeginTransaction();
try
{
string sql = "Insert Into tblDBVersion (dbVersion, dbBuild) values (0,100)";
using (var command = new SQLiteCommand(sql, sqliteConn))
{
command.ExecuteNonQuery();
}
dbTrans.Commit();
}
catch (Exception ex)
{
dbTrans.Rollback();
MessageBox.Show(ex.Message, "Error Encountered", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
finally
{
if (sqliteConn.State == ConnectionState.Open)
{
sqliteConn.Close();
}
}
}
public static void PopulateDBVersionTable()
{
using SQLiteConnection sqliteConn = CreateConnection();
sqliteConn.Open();
using DbTransaction dbTrans = sqliteConn.BeginTransaction();
try
{
string sql = "Insert Into tblDBVersion (dbVersion, dbBuild) values (0,100)";
using (var command = new SQLiteCommand(sql, sqliteConn))
{
command.ExecuteNonQuery();
}
dbTrans.Commit();
}
catch (Exception ex)
{
dbTrans.Rollback();
MessageBox.Show(ex.Message, "Error Encountered", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
finally
{
if (sqliteConn.State == ConnectionState.Open)
{
sqliteConn.Close();
}
}
}