public void update()
{
ITransaction trx = Config.con.BeginTransaction();
Dictionary <string, object> fields = new Dictionary <string, object>();
fields.Add("customer_name", "alteredByUpdate");
trx.Update(
typeof(DM_Customer),
fields,
new CriterionEqual("customer_id", 1));
trx.Commit();
trx = Config.con.BeginTransaction();
DM_Customer cust = (DM_Customer)trx.Load(typeof(DM_Customer), 1);
Assert.AreEqual(cust.customer_name, "alteredByUpdate");
cust.customer_name = "Glaser Corp.";
trx.Save();
trx.Commit();
}
public void loadTest()
{
ITransaction trx = Config.con.BeginTransaction();
DM_Customer cust = (DM_Customer)trx.Load(
typeof(DM_Customer),
1);
trx.Commit();
Assert.AreEqual(cust.date_last_modified, new DateTime(2007, 8, 9, 10, 11, 12));
}
public void deleteByEntity()
{
ITransaction trx = Config.con.BeginTransaction();
DM_Customer cust = (DM_Customer)trx.Load(
typeof(DM_Customer),
100);
trx.Delete(cust);
trx.Commit();
isGone();
}
public void setup()
{
ITransaction trx = Config.con.BeginTransaction();
DM_Customer cust = (DM_Customer)trx.Load(
typeof(DM_Customer),
1);
cust.customer_name = "Glaser Corp.";
trx.Save();
trx.Delete(typeof(DM_Order), new CriterionEqual("order_id", 200));
trx.Commit();
}
public void checkUpdateMerge()
{
ITransaction trxA = Config.con.BeginTransaction();
ITransaction trxB = Config.con.BeginTransaction();
DM_Customer cA = (DM_Customer)trxA.Load(
typeof(DM_Customer),
1);
DM_Customer cB = (DM_Customer)trxB.Load(
typeof(DM_Customer),
1);
cA.customer_name = "Changed by A";
trxA.Save(cA);
trxA.Commit();
cB.customer_no = 4321;
trxB.Save(cB);
trxB.Commit();
trxA = Config.con.BeginTransaction();
cA = (DM_Customer)trxA.Load(
typeof(DM_Customer),
1);
cA.customer_name = "Glaser Corp.";
cA.customer_no = 4711;
trxA.Save();
trxA.Commit();
}
public void checkUpdateConflict()
{
ITransaction trxA = Config.con.BeginTransaction();
ITransaction trxB = Config.con.BeginTransaction();
DM_Customer cA = (DM_Customer)trxA.Load(
typeof(DM_Customer),
1);
DM_Customer cB = (DM_Customer)trxB.Load(
typeof(DM_Customer),
1);
cA.customer_name = "Changed by A";
trxA.Save(cA);
trxA.Commit();
cB.customer_name = "Changed by B";
Exception ex = null;
try
{
trxB.Save();
}
catch (Exception e)
{
ex = e;
}
Assert.IsNotNull(ex);
Assert.AreEqual(typeof(DBConcurrencyException).ToString(), ex.GetType().ToString());
setup();
}