Oracle ODP.NET Data Provider v6.0

This version of the Enterprise Library Oracle Data Provider was tested against the Oracle Database 11g Express Edition (XE)
and the ODP.NET 11g client from Oracle v11.2.0.3.20 downloaded separately.

Oracle XE can be downloaded from http://www.oracle.com/technology/products/database/xe/index.html and is licence free.

ODP.NET can be downloaded from http://www.oracle.com/technetwork/database/windows/downloads/index-101290.html
Once this is installed you will need to copy the TNSNAMES.ORA and SQLNET.ORA files from your Oracle XE 11g server home Network\Admin folder over
to your new 11g client home Network/Admin folder.
Note: Oracle XE typically installs its server home folder into C:\oraclexe\app\oracle\product\11.2.0\server.

To run the unit tests included in the source code zip file available under the Downloads section, we will first need to run the Oracle Northwind database script (oracle-instnwind.sql) included in the \EntLibContrib6Src\Blocks\Data\Tests\Data.OdpNet.Tests folder. By default, the unit tests are configured to connect to the Northwind database using the 'system' user id (password 'admin').

The following is an example of a configuration file using an Oracle ODP.NET Data Provider:

[XML]
<configuration>
    <configSections>
        <section name="dataConfiguration" type="Microsoft.Practices.EnterpriseLibrary.Data.Configuration.DatabaseSettings, Microsoft.Practices.EnterpriseLibrary.Data, 

Version=6.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" requirePermission="true" />
        <section name="oracleConnectionSettings" type="Microsoft.Practices.EnterpriseLibrary.Data.Oracle.Configuration.OracleConnectionSettings, 

Microsoft.Practices.EnterpriseLibrary.Data, Version=6.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" requirePermission="true" />
    </configSections>
    <dataConfiguration defaultDatabase="OracleTest">
        <providerMappings>
            <add databaseType="EntLibContrib.Data.OdpNet.OracleDatabase, EntLibContrib.Data.OdpNet, Version=6.0.0.0, Culture=neutral, PublicKeyToken=null"
                name="Oracle.DataAccess.Client" />
        </providerMappings>
    </dataConfiguration>
    <oracleConnectionSettings>
        <add name="OracleTest">
            <packages>
                <add prefix="PKGNORTHWIND" name="NWND_" />
            </packages>
        </add>
    </oracleConnectionSettings>
    <connectionStrings>
        <add name="OracleTest" connectionString="Data Source=XE;User id=system;Password=admin"
            providerName="Oracle.DataAccess.Client" />
    </connectionStrings>
</configuration>

Last edited Sep 13, 2013 at 2:47 AM by jbourgault, version 1

Comments

kiquenet Mar 24, 2014 at 9:40 PM 
ODP.NET fully Managed provider supports ?

joshisi Oct 29, 2013 at 10:27 PM 
Can you use the managed ODP.NET provider?