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

前端之家收集整理的这篇文章主要介绍了.Net直连oracle数据库及连接池的配置前端之家小编觉得挺不错的,现在分享给大家,也给大家做个参考。
  1. OS64win10
  2. VS2017
  3. .NET:4.0
  4. Oracle dll文件版本为12.2.0.1
  5. 经过测试发现,需要将以下文件拷贝到可执行文件所在的目录,或者可执行文件能找到的目录下即可:Oracle.DataAccess.dlloci.dlloracore12.dlloraociei12.dlloraons.dllOraOps12.dll
  6. 测试代码如下:
  1. string connectionString = "Data Source=(DESCRIPTION=(ADDRESS_LIST=" +
  2. "(ADDRESS=(PROTOCOL=TCP)(HOST=host)(PORT=1521)))" +
  3. "(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=orcl)));" +
  4. "User Id=user;Password=pwd;Pooling = True;Max Pool Size = 10;Min Pool Size = 10;";
  5.  
  6. string queryString = "INSERT INTO GIS_GPS_RY(TERMINALID,LONGITUDE,LATITUDE,GPSTIME) values (:V_TERMINALID,:V_LONGITUDE,:V_LATITUDE,:V_GPSTIME)";
  7. using (OracleConnection connection = new OracleConnection(connectionString))
  8. {
  9. connection.Open();
  10. try
  11. {
  12. OracleCommand cmd = connection.CreateCommand();
  13. cmd.CommandText = queryString;
  14.  
  15.  
  16. OracleParameter[] paras =
  17. {
  18. new OracleParameter { ParameterName = "V_TERMINALID",Value=utils.GenerateTimeStamp(System.DateTime.Now),OracleDbType = OracleDbType.Varchar2},new OracleParameter { ParameterName = "V_LONGITUDE",new OracleParameter { ParameterName = "V_LATITUDE",new OracleParameter { ParameterName = "V_GPSTIME",Value=System.DateTime.Now }
  19. };
  20.  
  21. if (paras != null)
  22. {
  23. cmd.Parameters.AddRange(paras);
  24. }
  25. //System.DateTime.Now.ToString();
  26. //cmd.Parameters.Add("V_TERMINALID",OracleDbType.Varchar2,ParameterDirection.Input).Value = utils.GenerateTimeStamp(System.DateTime.Now);
  27. //cmd.Parameters.Add("V_LONGITUDE",ParameterDirection.Input).Value = utils.GenerateTimeStamp(System.DateTime.Now);
  28. //cmd.Parameters.Add("V_LATITUDE",ParameterDirection.Input).Value = utils.GenerateTimeStamp(System.DateTime.Now);
  29. //cmd.Parameters.Add("V_GPSTIME",OracleDbType.Date,ParameterDirection.Input).Value = System.DateTime.Now;
  30. cmd.ExecuteNonQuery();
  31. cmd.Parameters.Clear();
  32. }
  33. catch (Exception ex)
  34. {
  35. MessageBox.Show(ex.StackTrace);
  36. MessageBox.Show(ex.Message);
  37. }
  38. finally
  39. {
  40. connection.Close();
  41. }
  42. }
  1. 连接字符串后加“Pooling = True;Max Pool Size = 10;Min Pool Size = 1;”这三个参数即可实现应用连接池。
  2. Pooling:是否启用连接池,True为启用
  3. Max Pool Size:连接池最大连接数
  4. Min Pool Size:连接池最小连接数

猜你在找的Oracle相关文章