private static void CrudOperationTest()
{
var db = CreateDatabase();
var deleted = db.ExecuteCommand("Delete From AllDataTypeTable");
OutputTestResult("Query: Delete AllDataTypeTable", true);
using (DatabaseContext dc = new DatabaseContext(CreateDatabase()))
{
dc.BeginTransaction(IsolationLevel.ReadCommitted);
for (int i = 0; i < 3; i++)
{
var inserted = InsertRecord(i);
OutputTestResult("AllDataTypeTableInsert with transaction", inserted == 1);
}
dc.CommitTransaction();
}
var t = new alldatatypetable();
var r = t.SelectByPrimaryKey(1);
r.PrimaryKeyColumn = 11;
var x1 = t.Insert(r);
OutputTestResult("AllDataTypeTable.Insert", x1 == 1);
r = t.SelectByPrimaryKey(11);
r.PrimaryKeyColumn = 12;
var x2 = t.Update(r);
OutputTestResult("AllDataTypeTable.Update", x2 == 1);
var x3 = t.Delete(12, r.TimestampColumn);
OutputTestResult("AllDataTypeTable.Delete", x3 == 1);
}
/// <summary>
///
/// </summary>
/// <param name="transactionKey"></param>
/// <param name="database"></param>
private static void SetDatabaseContext(String transactionKey, DatabaseContext database)
{
var dcs = DatabaseContext.Contexts;
if (dcs.ContainsKey(transactionKey) == true) throw new TransactionKeyAlreadyUsedException();
dcs[transactionKey] = database;
}
