public void BeginTransTest() { SQLServer objDB = null; try { objDB = TestEnvJudge(); if (objDB != null) { if (objDB.Connect()) { Assert.AreEqual(true, objDB.BeginTrans()); objDB.RollBack(); } } } finally { if (objDB.Connect()) { objDB.Disconnect(); } objDB = null; } }
public void GetTableLockInfoTest() { SQLServer objDB = null; try { objDB = TestEnvJudge(); if (objDB != null) { if (objDB.Connect()) { objDB.BeginTrans(); objDB.ExecuteNonQuery("insert into get_test values (NEXT VALUE FOR get_test_sequence,'','',SYSDATETIME(),SYSDATETIMEOFFSET())"); Assert.AreNotEqual(true, objDB.GetTableLockInfo("get_test")); objDB.RollBack(); } } } finally { if (objDB.Connect()) { objDB.Disconnect(); } objDB = null; } }
public void BeginTransAndRollBackTest() { try { if (objDB != null) { if (objDB.Connect()) { Assert.AreEqual(true, objDB.BeginTrans()); Assert.AreEqual(true, objDB.RollBack()); } } } finally { if (objDB.Conn.State == ConnectionState.Open) { objDB.Disconnect(); } } }