Hello there,
I'm trying to migrate my web application to oracle's managed driver.
My setup:
LLBLGen 4.2
.NET Framework 4.5
Here is what I did:
- Downloaded the zip file
- Referenced Oracle.ManagedDataAccess.dll in my web app project. (dll gets copied to the bin folder)
- Added this to my web.config
<system.data>
<DbProviderFactories>
<!--Remove in case this is already defined in machine.config-->
<remove invariant="Oracle.DataAccess.Client" />
<add name="Oracle Data Provider for .NET"
invariant="Oracle.DataAccess.Client"
description="Oracle Data Provider for .NET, Managed Driver"
type="Oracle.ManagedDataAccess.Client.OracleClientFactory, Oracle.ManagedDataAccess, Version=4.121.2.0, Culture=neutral, PublicKeyToken=89b483f429c47342" />
</DbProviderFactories>
</system.data>
The version 4.121.2.0 matches.
- Copied the default tnsnames.ora into the bin directory.
After a rebuild I launch the app and it's giving me this error
Could not load type 'Oracle.DataAccess.Client.OracleDbType' from assembly 'Oracle.ManagedDataAccess, Version=4.121.2.0, Culture=neutral, PublicKeyToken=89b483f429c47342'.
Stacktrace
v System.Reflection.RuntimeAssembly.GetType(RuntimeAssembly assembly, String name, Boolean throwOnError, Boolean ignoreCase, ObjectHandleOnStack type)
v System.Reflection.RuntimeAssembly.GetType(String name, Boolean throwOnError, Boolean ignoreCase)
v System.Reflection.Assembly.GetType(String name, Boolean throwOnError)
v SD.LLBLGen.Pro.ORMSupportClasses.DbProviderFactoryInfo.InitializeEnumTypeCache()
v SD.LLBLGen.Pro.ORMSupportClasses.DbProviderFactoryInfo.SetDbProviderFactoryParameterData(List`1 dbProviderFactoryInvariantNamesWithEnumTypeNames, String dbProviderSpecificEnumTypePropertyName)
v SD.LLBLGen.Pro.DQE.Oracle.OracleSpecificCreator.SetDbProviderFactoryParameterData(List`1 dbProviderFactoryInvariantNamesWithEnumTypeNames, String dbProviderSpecificEnumTypePropertyName)
v SD.LLBLGen.Pro.DQE.Oracle.DynamicQueryEngine..cctor()
Am I Missing something here ?