ODP.NET Managed web.config 配置

  <connectionStrings>
    <add name="OracleConnectionString" providerName="Oracle.ManagedDataAccess.Client" connectionString="User Id=scott;Password=tiger;Data Source= MyDataSource;PERSIST SECURITY INFO=True" />

  </connectionStrings>

  <oracle.manageddataaccess.client>
    <version number="*">
      <dataSources>
        <dataSource alias="SampleDataSource"
            descriptor="(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=ORCL))) "/>
        <dataSource alias="MyDataSource"
             descriptor="(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = tcp)(HOST = 192.168.0.1)(PORT = 1521))  (ADDRESS = (PROTOCOL = tcp)(HOST = 192.168.0.2)(PORT = 1521))  (LOAD_BALANCE = ON) (FAILOVER = ON) ) (CONNECT_DATA =(SERVICE_NAME = oradb)(GLOBAL_NAME = oradb)(FAILOVER_MODE = (TYPE = SELECT) (METHOD = BASIC)))) " />
      </dataSources>
      <settings>
        <setting name="TNS_ADMIN" value="C:\oracle\product\10.2.0\client_1\NETWORK\ADMIN\"/>
      </settings>


    </version>
  </oracle.manageddataaccess.client>

c#

        public static string connectionString = ConfigurationManager.ConnectionStrings["OracleConnectionString"].ConnectionString;// "连接字符串";