public void SQLite3()
{
Debug.WriteLine("");
Debug.WriteLine("SQLite3 -----------------");
DataEngine db = GetDbContext("sqlite3", useConnectionPool: false);
using (DBTransactionController trans = db.BeginTrans())
{
bool success = ExecuteCreateTable(TestExecutePattern.InTransaction, db, table_categories, trans);
if (success)
{
success = ExecuteCreateTable(TestExecutePattern.InTransaction, db, table_products, trans);
}
if (success)
{
trans.Commit();
}
}
}
public void PostgreSQL()
{
Debug.WriteLine("");
Debug.WriteLine("PostgreSQL -----------------");
DataEngine db = GetDbContext("npgsql");
using (DBTransactionController trans = db.BeginTrans())
{
bool success = ExecuteCreateTable(TestExecutePattern.InTransaction, db, table_categories, trans);
if (success)
{
success = ExecuteCreateTable(TestExecutePattern.InTransaction, db, table_products, trans);
}
if (success)
{
trans.Commit();
}
}
ReleaseDb(db);
}