比如说下面的代码,两个事务嵌套在一起,请问结果是怎么样的,谢谢
using (SQLiteTransaction dbTrans1 = _cnn.BeginTransaction())
{
using (SQLiteCommand cmd1 = _cnn.CreateCommand())
{
cmd1.CommandText = 。。。
cmd1.ExecuteNonQuery();
}
using (SQLiteTransaction dbTrans2 = _cnn.BeginTransaction())
{
using (SQLiteCommand cmd2 = _cnn.CreateCommand())
{
cmd2.CommandText = 。。。
cmd2.ExecuteNonQuery();
}
dbTrans2.Commit();
}
dbTrans1.Commit();
}
------解决方案--------------------------------------------------------
http://blog.csdn.net/xiaoyong322/article/details/5684381