代码之家 › 专栏 › 技术社区 › IngoB

Oracle 18c&.net 4.7.2:“无法加载Oracle.ManagedDataAccess.Client”

entity-framework-6 oracle .net

IngoB · 技术社区 · 7 年前

在我的.NET 4.7.2类库项目中,我添加了“oracle.managedataaccess.entityframework”nuget包。访问dbContext时

using (var ctx = new BdeDbContext())

我正在获取“实体框架提供程序类型”oracle.managedataaccess.entity framework.eforacleproviderservices,oracle.managedataaccess.entity framework,version=6.122.18.3,culture=neutral,publickeytoken=89b483f429c47342“已在ADO.NET提供程序的应用程序配置文件中注册,其固定名称为”oracle.managedataaccess.client“。无法加载。请确保使用了程序集限定名,并且程序集可用于正在运行的应用程序。“

在查看了类似的文章之后,我还添加了“ODAC for Visual Studio 2017”和“ODP.NET.x64”,但这没有帮助。有人有类似的问题吗?

我的app.config如下所示。

<?xml version="1.0" encoding="utf-8"?>
<configuration>
    <configSections>
        <!-- For more information on Entity Framework configuration, visit http://go.microsoft.com/fwlink/?LinkID=237468 -->
        <section name="entityFramework" type="System.Data.Entity.Internal.ConfigFile.EntityFrameworkSection, EntityFramework, Version=6.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" requirePermission="false" />
        <section name="oracle.manageddataaccess.client" type="OracleInternal.Common.ODPMSectionHandler, Oracle.ManagedDataAccess, Version=4.122.18.3, Culture=neutral, PublicKeyToken=89b483f429c47342" />
    </configSections>
    <startup>
        <supportedRuntime version="v4.0" sku=".NETFramework,Version=v4.7.2" />
    </startup>
    <entityFramework>
        <defaultConnectionFactory type="System.Data.Entity.Infrastructure.LocalDbConnectionFactory, EntityFramework">
            <parameters>
                <parameter value="v13.0" />
            </parameters>
        </defaultConnectionFactory>
        <providers>
            <provider invariantName="System.Data.SqlClient" type="System.Data.Entity.SqlServer.SqlProviderServices, EntityFramework.SqlServer" />
            <provider invariantName="Oracle.ManagedDataAccess.Client" type="Oracle.ManagedDataAccess.EntityFramework.EFOracleProviderServices, Oracle.ManagedDataAccess.EntityFramework, Version=6.122.18.3, Culture=neutral, PublicKeyToken=89b483f429c47342" />
        </providers>
    </entityFramework>
    <system.data>
        <DbProviderFactories>
            <remove invariant="Oracle.ManagedDataAccess.Client" />
            <add name="ODP.NET, Managed Driver" invariant="Oracle.ManagedDataAccess.Client" description="Oracle Data Provider for .NET, Managed Driver" type="Oracle.ManagedDataAccess.Client.OracleClientFactory, Oracle.ManagedDataAccess, Version=4.122.18.3, Culture=neutral, PublicKeyToken=89b483f429c47342" />
        </DbProviderFactories>
    </system.data>
    <runtime>
        <assemblyBinding xmlns="urn:schemas-microsoft-com:asm.v1">
            <dependentAssembly>
                <publisherPolicy apply="no" />
                <assemblyIdentity name="Oracle.ManagedDataAccess" publicKeyToken="89b483f429c47342" culture="neutral" />
                <bindingRedirect oldVersion="4.122.0.0 - 4.65535.65535.65535" newVersion="4.122.18.3" />
            </dependentAssembly>
            <dependentAssembly>
                <assemblyIdentity name="CommonServiceLocator" publicKeyToken="489b6accfaf20ef0" culture="neutral" />
                <bindingRedirect oldVersion="0.0.0.0-2.0.4.0" newVersion="2.0.4.0" />
            </dependentAssembly>
        </assemblyBinding>
    </runtime>
    <oracle.manageddataaccess.client>
        <version number="*">
            <dataSources>
                <dataSource alias="SampleDataSource" descriptor="(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=ORCL.MYCOMPANY.COM))) " />
            </dataSources>
        </version>
    </oracle.manageddataaccess.client>
    <connectionStrings>
        <add name="BdeDb" providerName="Oracle.ManagedDataAccess.Client" connectionString="User Id=sys;Password=0r@cl3;Data Source=orcl.mycompany.com" />
    </connectionStrings>
</configuration>