Oracle.ManagedDataAccess - Steps to get it working

Posts   
 
    
gummidrum
User
Posts: 11
Joined: 13-Dec-2013
# Posted on: 29-Jan-2014 18:29:55   

What do I need to do to have my generated code use Oracle.ManagedDataAccess?

I am using LLBLGen pro 4.1. Relational Model Data uses Oracle (ODP.NET) I am using the Adapter template group.

I have been trying to follow the steps indicated in this thread:

http://llblgen.com/tinyforum/Messages.aspx?ThreadID=22160

But I can't seem to get it work. I have the same version of Oracle.ManagedDataAccess.dll (4.121.1.0) as described in the thread. My understanding is that what is needed is this:

  1. The Oracle.ManagedDataAccess.dll should exist in the same directory as the code is executed from.
  2. TnsName.ora should also be in this folder.
  3. I added this to my config file as this thread indicades:

<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.1.0, Culture=neutral, PublicKeyToken=89b483f429c47342" />
</DbProviderFactories>
</system.data>
Walaa avatar
Walaa
Support Team
Posts: 14995
Joined: 21-Aug-2005
# Posted on: 29-Jan-2014 21:01:34   

You have posted the same question here: https://www.llblgen.com/tinyforum/Messages.aspx?ThreadID=22508

I'll close this thread, so we can follow up in one place.