private static void CrudOperationTest()
{
var db = CreateDatabase();
var deleted = db.ExecuteCommand("Delete 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);
}
private static void CrudOperationTest_SqlServer()
{
var db = DatabaseFactory.Current.CreateDatabase(DatabaseKey_SqlServer);
var deleted = db.ExecuteCommand("Delete AllDataTypeTable");
OutputTestResult("Query: Delete AllDataTypeTable", true);
using (TransactionContext tx = new TransactionContext(DatabaseFactory.Current.CreateDatabase(DatabaseKey_SqlServer)))
{
tx.BeginTransaction(IsolationLevel.ReadCommitted);
for (int i = 0; i < 3; i++)
{
var sp = InsertRecord_SqlServer(i);
var inserted = sp.ExecuteNonQuery(tx);
OutputTestResult("AllDataTypeTableInsert with transaction", inserted == 1);
}
tx.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);
_ = Usp_Structure().Result;
_ = Usp_OutputParameter().Result;
Usp_SelectMultiTable();
}
private static void CrudOperationTest_SqlServer()
{
var db = DatabaseFactory.Current.CreateDatabase(DatabaseKey_SqlServer);
var deleted = db.ExecuteCommand("Delete AllDataTypeTable");
OutputTestResult("Query: Delete AllDataTypeTable", true);
using (DatabaseContext dc = new DatabaseContext(DatabaseFactory.Current.CreateDatabase(DatabaseKey_SqlServer)))
{
dc.BeginTransaction(IsolationLevel.ReadCommitted);
for (int i = 0; i < 3; i++)
{
var inserted = InsertRecord_SqlServer(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);
}
