事务的应用

在同时删除多个表时建议应用事务来处理，防止产生数据不一致。
public int delete(int id)
  {
   string strConnectionString =Beyondbit.Data.DbConn.Sql_ConnectionString;
 
   int i=0;
   using (SqlConnection cn = new SqlConnection(strConnectionString))
   {
    cn.Open();
    using (SqlTransaction trans = cn.BeginTransaction())
    {
     try
     {
      string strSqlString="delete from userList where id='"+id+"'";
      SqlHelper.ExecuteNonQuery(trans,CommandType.Text, strSqlString);

      strSqlString="delete from taskcenter where id='"+id+"'";
      SqlHelper.ExecuteNonQuery(trans, CommandType.Text, strSqlString);

      strSqlString="delete from form_document where DocID='"+id+"'";
      SqlHelper.ExecuteNonQuery(trans, CommandType.Text, strSqlString);

      trans.Commit();
     }
     catch (Exception ex)
     {
      trans.Rollback();
      i = -1;
      throw ex;
     }
     finally
     {
      cn.Close();
     }
    }
   }
   return i;
  }

转载于:https://www.cnblogs.com/isMe/archive/2005/11/03/267847.html