EF Oracle TNS 连接

时间：2023-03-08 20:11:44
  <oracle.manageddataaccess.client>

    <version number="*">

      <settings>

        <setting name="TNS_ADMIN" value="D:\CPA\instantclient_11_2\"/>

      </settings>

      <dataSources>

        <dataSource alias="SampleDataSource" descriptor="(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=ORCL))) "/>

      </dataSources>

    </version>

  </oracle.manageddataaccess.client>

  <connectionStrings>

    <add name="OracleDbContext" providerName="Oracle.ManagedDataAccess.Client"

      connectionString="User Id=oracle_user;Password=oracle_user_password;Data Source=oracle"/>

    <add name="OracleModel" connectionString="DATA SOURCE=CPA_srv2;PASSWORD=*;USER ID=*;"

  providerName="Oracle.ManagedDataAccess.Client"/>

  </connectionStrings>

相关文章