private void InitializeTables(SQLiteDatabase db)
{
db.ExecuteNonQuery("BEGIN EXCLUSIVE");
for (int i = 0; i < CREATE_Commands.Length; i++)
{
db.ExecuteNonQuery(CREATE_Commands[i]);
}
}
private SQLiteDatabase OpenDB(string fileName)
{
if (File.Exists(fileName))
File.Delete(fileName);
var db = new SQLiteDatabase(fileName);
for (int i = 0; i < PRAGMA_Commands.Length; i++)
{
db.ExecuteNonQuery(PRAGMA_Commands[i]);
}
return db;
}