using System.Transactions;



            using (TransactionScope scope =
                new TransactionScope(TransactionScopeOption.Required,
                   new TransactionOptions
                   {
                       IsolationLevel = System.Transactions.IsolationLevel.ReadCommitted,
                       Timeout = new TimeSpan(0, 0, 120)
                   })
               )
            {

              try

              {

                  ExecuteSql(

                      "INSERT INTO [user]([id], [name], [age], [password]) VALUES (5, N'zhaoliu', 17, '789');");

                  ExecuteSql(

                      "INSERT INTO [user]([id], [name], [age], [password]) VALUES (5, N'zhaoliu', 17, '789');");

                  ExecuteSql(

                      "INSERT INTO [user]([id], [name], [age], [password]) VALUES (5, N'zhaoliu', 17, '789');");

                  ExecuteSql(

                      "INSERT INTO [user]([id], [name], [age], [password]) VALUES (5, N'zhaoliu', 17, '789');");

                  ExecuteSql(

                      "INSERT INTO [user]([id], [name], [age], [password]) VALUES (5, N'zhaoliu', 17, '789');");

                  ExecuteSql("delete from  [user] where id=5;");

                  ExecuteSql(

                      "INSERT INTO [user]([id], [name], [age], [password]) VALUES (5, N'zhaoliu', 17, '789',123);");

                  scope.Complete();

              }

              catch (Exception ex)

              {

                  Console.WriteLine(ex);

              }

            }