c#oracle连接

    /// <summary>
    /// EflowOracleAccess
    /// </summary>
    public class EflowOracleAccess
    {
        /// <summary>
        /// コネクション
        /// </summary>
        private OracleConnection _oraConn = null;

        /// <summary>
        /// トランザクション
        /// </summary>
        private OracleTransaction _oraTrans = null;

        /// <summary>
        /// コネクション
        /// </summary>
        public OracleConnection OraConnection
        {
            get { return _oraConn; }
            set { _oraConn = value; }
        }

        /// <summary>
        /// トランザクション
        /// </summary>
        public OracleTransaction OraTransaction
        {
            get { return _oraTrans; }
            set { _oraTrans = value; }
        }

        /// <summary>
        /// EflowOracleAccess
        /// </summary>
        public EflowOracleAccess()
        {
            this.OraConnection = new OracleConnection(Constant.DBConnection);
        }

        #region SELECT用のSQLメソッド

        /// <summary>
        /// SELECT用のSQLメソッド
        /// </summary>
        /// <param name="strSql">SELECT用のSQL</param>
        /// <returns>取得結果</returns>
        public DataTable ExecuteQuery(string strSql)
        {
            OracleDataReader Ora;
            try
            {
                this.OpenOraConnection();

                strSql = strSql.Replace(char.ConvertFromUtf32(2), "{");
                strSql = strSql.Replace(char.ConvertFromUtf32(3), "}");

                OracleCommand command = new OracleCommand(strSql, this.OraConnection);
                command.CommandType = System.Data.CommandType.Text;
                Ora = command.ExecuteReader();

                DataTable dtt = new DataTable();
                dtt.Load(Ora, LoadOption.OverwriteChanges);

                return dtt;
            }
            catch (OracleException oe)
            {
                throw oe;
            }
            catch (Exception ee)
            {
                throw ee;
            }
            finally
            {
                this.OraConnection.Dispose();
                GC.Collect();
            }
        }

        /// <summary>
        /// SELECT用のSQLメソッド
        /// </summary>
        /// <param name="strSql">SELECT用のSQL</param>
        /// <returns>取得結果</returns>
        public object ExecuteScalar(string strSql)
        {
            try
            {
                this.OpenOraConnection();

                strSql = strSql.Replace(char.ConvertFromUtf32(2), "{");
                strSql = strSql.Replace(char.ConvertFromUtf32(3), "}");

                OracleCommand command = new OracleCommand(strSql, this.OraConnection);
                command.CommandType = System.Data.CommandType.Text;

                return command.ExecuteScalar();
            }
            catch (OracleException oe)
            {
                throw oe;
            }
            catch (Exception ee)
            {
                throw ee;
            }
            finally
            {
                this.OraConnection.Dispose();
                GC.Collect();
            }
        }

        #endregion


        #region 更新系SQLメソッド
        /// <summary>
        /// 更新系(Update/Insert/Delete文)SQL発行用のSQL
        /// </summary>
        /// <param name="strSql">発行用のSQL</param>
        /// <returns>更新されたレコード数</returns>
        public int ExecuteNonQuery(string strSql)
        {
            try
            {
                this.OpenOraConnection();

                strSql = strSql.Replace(char.ConvertFromUtf32(2), "{");
                strSql = strSql.Replace(char.ConvertFromUtf32(3), "}");

                OracleCommand command = new OracleCommand(strSql, this.OraConnection);
                int intCount = command.ExecuteNonQuery();

                return intCount;
            }
            catch (OracleException oe)
            {
                throw oe;
            }
            catch (Exception ee)
            {
                throw ee;
            }
            finally
            {
                this.OraConnection.Dispose();
                GC.Collect();
            }
        }

        /// <summary>
        /// 複数件のSQLを実行する
        /// </summary>
        /// <param name="strSql">発行用のSQL</param>
        /// <returns>更新されたレコード数</returns>
        public int ExecuteNonQuery(string[] strSql)
        {
            int intCount = 0;

            try
            {
                this.OpenOraConnection();

                for (int i = 0; i < strSql.Length; i++)
                {
                    string sql = strSql[i];

                    sql = sql.Replace(char.ConvertFromUtf32(2), "{");
                    sql = sql.Replace(char.ConvertFromUtf32(3), "}");

                    OracleCommand command = new OracleCommand(sql, this.OraConnection);
                    int j = command.ExecuteNonQuery();
                    //更新対象がなかった場合
                    if (j != 0)
                    {
                        intCount++;
                    }
                }

                return intCount;
            }
            catch (OracleException oe)
            {
                throw oe;
            }
            catch (Exception ee)
            {
                throw ee;
            }
            finally
            {
                this.OraConnection.Dispose();
                GC.Collect();
            }
        }

        #endregion

        #region Transaction

        /// <summary>
        /// トランザクション開始
        /// </summary>
        public void BeginTrans()
        {
            try
            {
                //CheckConState
                this.OraTransaction = this.OraConnection.BeginTransaction(System.Data.IsolationLevel.ReadCommitted);
            }
            catch (OracleException ex)
            {
                throw ex;
            }
        }

        /// <summary>
        /// OraConnection
        /// </summary>
        private void OpenOraConnection()
        {
            if (String.IsNullOrEmpty(this.OraConnection.ConnectionString))
            {
                this.OraConnection = new OracleConnection(Constant.DBConnection);
            }

            this.OraConnection.Open();
        }

        /// <summary>
        /// コミット
        /// </summary>
        public void Commit()
        {
            try
            {
                this.OraTransaction.Commit();
                this.OraTransaction = this.OraConnection.BeginTransaction();
            }
            catch (OracleException ex)
            {
                throw ex;
            }
        }

        /// <summary>
        /// ロールバック
        /// </summary>
        public void RollBack()
        {
            try
            {
                if (this.OraTransaction != null && this.OraConnection != null)
                {
                    this.OraTransaction.Rollback();
                    this.OraTransaction = this.OraConnection.BeginTransaction();
                }
            }
            catch (OracleException ex)
            {
                throw ex;
            }
        }

        /// <summary>
        /// コネクションの状態を確認する
        /// </summary>
        private void CheckConState()
        {
            try
            {
                if (this.OraConnection == null)
                {
                    this.OraConnection = new OracleConnection(Constant.DBConnection);
                }

                if (this.OraConnection.State == ConnectionState.Closed)
                {
                    this.OraConnection.Open();
                }
            }
            catch (OracleException oe)
            {
                throw oe;
            }
            catch (Exception ee)
            {
                throw ee;
            }
        }

        #endregion
    }