使用C#访问Oracle,使用连接池,代码如何写,数据库端要不要做配置

默认分类 未结 1 1172
0兜里有鸟0
0兜里有鸟0 2023-03-21 09:32
相关标签:
1条回答
  • 2023-03-21 10:15

    string my="data source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP) (HOST=localhost)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=cjsorcl)));User ID=cjsdog;Password=cjsmap;Pooling = True;Max Pool Size = 10;Min Pool Size = 1;"OracleConnection conn = new OracleConnection(my);***.Open();... ...... ...conn.Close();连接字符串后加“Pooling = True;Max Pool Size = 10;Min Pool Size = 1;”这三个参数即可实现应用连接池。Pooling:是否启用连接池,True为启用Max Pool Size:连接池最大连接数Min Pool Size:连接池最小连接数

    0 讨论(0)
提交回复