使用Oracle.ManagedDataAccess.Client执行数据库操作

一.执行事务处理

        private static string connStr = System.Configuration.ConfigurationManager.ConnectionStrings["Conn"].ToString();
        private static OracleConnection conn = new OracleConnection(connStr);

  public static bool ExecuteTransactionBySqls(string[] sqlArray)
        {
            bool isSuccess = false;
            try
            {
                conn.Open();
                OracleTransaction transaction = conn.BeginTransaction();
                foreach (var itemSql in sqlArray)
                {
                    using (OracleCommand cmd = new OracleCommand())
                    {
                        cmd.Connection = conn;
                        cmd.CommandText = itemSql;
                        cmd.Transaction = transaction;
                        cmd.ExecuteNonQuery();
                    }
                }                             
                transaction.Commit();               
                conn.Close();
                isSuccess = true;
            }
            catch 
            {
                conn.Close();
            }
            return isSuccess;
        }