Example #1
0
        public void TestCommit()
        {
            TraceHelper.TraceTestName();
            var db = OpenDatabase();

            int oldNumOrders = db.Orders.All().ToList().Count;
            int oldNumItems  = db.Items.All().ToList().Count;

            using (var tx = db.BeginTransaction()) {
                try
                {
                    var order = tx.Orders.Insert(CustomerNum: 122, OrderDate: DateTime.Today);
                    tx.Items.Insert(OrderNum: order.OrderNum, ItemNum: 1, StockNum: 204, ManuCode: "KAR", Quantity: 3, TotalPrice: 33.30);
                    tx.Commit();
                }
                catch {
                    tx.Rollback();
                    throw;
                }
            }

            Assert.AreEqual(oldNumOrders + 1, db.Orders.All().ToList().Count);
            Assert.AreEqual(oldNumItems + 1, db.Items.All().ToList().Count);
        }
 public void TestFixtureTearDown()
 {
     TraceHelper.EndTrace();
 }
 public void TestFixtureSetUp()
 {
     TraceHelper.BeginTrace();
     DatabaseHelper.Reset(_connectionString);
 }
 public static void TestFixtureSetUp()
 {
     TraceHelper.BeginTrace();
     DatabaseHelper.Reset(Simple.Data.Informix.Tests.Properties.Settings.Default.ConnectionString_V7);
 }
 public void TestFixtureSetUp()
 {
     TraceHelper.BeginTrace();
 }