在不改变现有代码的基础上增加事务
缺点 消耗系统资源比较大,响应比较慢.
static public void testTran()
{
ServiceConfig sc = new ServiceConfig();
sc.Transaction = TransactionOption.Required;
sc.TrackingEnabled = true;
ServiceDomain.Enter(sc);
try
{
Insert("1");
Insert("a");
ContextUtil.SetComplete();
}
catch (System.Exception except)
{
HttpContext.Current.Response.Write(except.ToString());
ContextUtil.SetAbort();
}
finally
{
ServiceDomain.Leave();
}
}
static public void Insert(string val)
{
string sql="insert into test1 (number) values ('"+ val +"') ";
DBClass.SqlHelper.ExecuteDataset(DBClass.SqlHelper.CONNSTR,CommandType.Text,sql);
}