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();
}
}
}
