public void TestNoTransaction()
{
ISqlMapper sqlMapper = new DomSqlMapBuilder().Configure("IBatisNet.config");
TestObjectDao testObjectDao = new TestObjectDao(sqlMapper);
TestObject object1 = TestObject.NewRandom();
testObjectDao.Insert(object1);
Assert.Throws <SqlException>(() => testObjectDao.Insert(object1));
}
public void TestObjectCRUD()
{
TestObject object1 = TestObject.NewRandom();
_testObjectDao.Insert(object1);
TestObject object2 = _testObjectDao.SelectById(object1.Id);
AssertHelper.AreEqual(object1, object2);
_testObjectDao.DeleteById(object1.Id);
Assert.IsNull(_testObjectDao.SelectById(object1.Id));
}
public void TestTransaction2()
{
ISqlMapper sqlMapper = new DomSqlMapBuilder().Configure("IBatisNet.config");
TestObjectDao testObjectDao = new TestObjectDao(sqlMapper);
TestObject object1 = TestObject.NewRandom();
try
{
//using... syntax
using (IDalSession session = sqlMapper.BeginTransaction())
{
testObjectDao.Insert(object1);
testObjectDao.Insert(object1);
session.Complete();
}
}
catch { }
TestObject object2 = testObjectDao.SelectById(object1.Id);
Assert.IsNull(object2);
}
public void TestTransaction1()
{
ISqlMapper sqlMapper = new DomSqlMapBuilder().Configure("IBatisNet.config");
TestObjectDao testObjectDao = new TestObjectDao(sqlMapper);
TestObject object1 = TestObject.NewRandom();
//try...catch... syntax
try
{
sqlMapper.BeginTransaction();
testObjectDao.Insert(object1);
testObjectDao.Insert(object1);
sqlMapper.CommitTransaction();
}
catch
{
sqlMapper.RollBackTransaction();
}
TestObject object2 = testObjectDao.SelectById(object1.Id);
Assert.IsNull(object2);
}
public void InsertTwiceT(TestObject object1)
{
_testObjectDao.Insert(object1);
_testObjectDao.Insert(object1);
}
public virtual void InsertT(TestObject object1)
{
_testObjectDao.Insert(object1);
}
