.Net直连oracle数据库及连接池的配置

OS：64位win10。 VS：2017。 .NET:4.0。 Oracle 的dll文件版本为12.2.0.1。 经过测试发现，需要将以下文件拷贝到可执行文件所在的目录，或者可执行文件能找到的目录下即可：Oracle.DataAccess.dll、oci.dll、oracore12.dll、oraociei12.dll、oraons.dll、OraOps12.dll。 测试代码如下： string connectionString = "Data Source=(DESCRIPTION=(ADDRESS_LIST=" + "(ADDRESS=(PROTOCOL=TCP)(HOST=host)(PORT=1521)))" + "(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=orcl)));" + "User Id=user;Password=pwd;Pooling = True;Max Pool Size = 10;Min Pool Size = 10;"; string queryString = "INSERT INTO GIS_GPS_RY(TERMINALID, LONGITUDE, LATITUDE,GPSTIME) values (:V_TERMINALID, :V_LONGITUDE, :V_LATITUDE,:V_GPSTIME)"; using (OracleConnection connection = new OracleConnection(connectionString)) { connection.Open(); try { OracleCommand cmd = connection.CreateCommand(); cmd.CommandText = queryString; OracleParameter[] paras = { new OracleParameter { ParameterName = "V_TERMINALID",Value=utils.GenerateTimeStamp(System.DateTime.Now),OracleDbType = OracleDbType.Varchar2}, new OracleParameter { ParameterName = "V_LONGITUDE",Value=utils.GenerateTimeStamp(System.DateTime.Now),OracleDbType = OracleDbType.Varchar2}, new OracleParameter { ParameterName = "V_LATITUDE",Value=utils.GenerateTimeStamp(System.DateTime.Now),OracleDbType = OracleDbType.Varchar2}, new OracleParameter { ParameterName = "V_GPSTIME",Value=System.DateTime.Now } }; if (paras != null) { cmd.Parameters.AddRange(paras); } //System.DateTime.Now.ToString(); //cmd.Parameters.Add("V_TERMINALID", OracleDbType.Varchar2, ParameterDirection.Input).Value = utils.GenerateTimeStamp(System.DateTime.Now); //cmd.Parameters.Add("V_LONGITUDE", OracleDbType.Varchar2, ParameterDirection.Input).Value = utils.GenerateTimeStamp(System.DateTime.Now); //cmd.Parameters.Add("V_LATITUDE", OracleDbType.Varchar2, ParameterDirection.Input).Value = utils.GenerateTimeStamp(System.DateTime.Now); //cmd.Parameters.Add("V_GPSTIME", OracleDbType.Date, ParameterDirection.Input).Value = System.DateTime.Now; cmd.ExecuteNonQuery(); cmd.Parameters.Clear(); } catch (Exception ex) { MessageBox.Show(ex.StackTrace); MessageBox.Show(ex.Message); } finally { connection.Close(); } } 连接字符串后加“Pooling = True;Max Pool Size = 10;Min Pool Size = 1;”这三个参数即可实现应用连接池。 Pooling：是否启用连接池，True为启用 Max Pool Size：连接池最大连接数 Min Pool Size：连接池最小连接数