public void TransactionTest()
{
using (var db = new TestConnection())
{
var tran = db.BeginTransaction();
var obj = new Demo
{
Id = 1010082,
Name = "JerryDemo",
Age = 10,
Score = 56,
AddTime = DateTime.Now
};
try
{
var res = db.Insert(obj);
db.ExecuteSql("UPDATE DEMO SET Name='JerryDemo',Age=10,Score=56s,AddTime='2016/6/26 12:41:09',IsDel='True' WHERE ID = 1010000; SELECT @@ROWCOUNT;");
tran.Commit();
}
catch
{
tran.Rollback();
}
}
}
