Oracle ODP.NET Data Provider

This version of the Enterprise Library Oracle Data Provider was tested against the Oracle Database 10g Express Edition (XE)
and the ODP.NET 11g client from Oracle v11.1.0.7.10 downloaded separately. To use both on the same PC you will need to install the Microsoft Loopback Adapter.
Note: The installation order is significant. Install Oracle XE first and then the updated ODP.NET client second.

Oracle XE can be downloaded from http://www.oracle.com/technology/products/database/xe/index.html and is licence free.
The installation includes the server components and the older 10g ODP.NET provider. Newer providers are downloaded separately for interim upgrades.

ODP.NET can be downloaded from http://www.oracle.com/technology/tech/windows/odpnet/index.html
Once this is installed you will need to copy the TNSNAMES.ORA and SQLNET.ORA files from your Oracle XE 10g server home Network\Admin folder over
to your new 11g client home Network/Admin folder and install the Microsoft Loopback Adapter if you are running everything from the same PC.
Note: Oracle XE typically installs its server home folder into C:\oraclexe\app\oracle\product\10.2.0\server.

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

[XML]
<?xml version="1.0" encoding="utf-8"?>
<configuration>
	<configSections>
		<section name="dataConfiguration" type="Microsoft.Practices.EnterpriseLibrary.Data.Configuration.DatabaseSettings, Microsoft.Practices.EnterpriseLibrary.Data, Version=4.1.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" />
		<section name="oracleConnectionSettings" type="EntLibContrib.Data.OdpNet.Configuration.OracleConnectionSettings, EntLibContrib.Data.OdpNet" />
	</configSections>
	<dataConfiguration defaultDatabase="Service_Dflt">
		<providerMappings>
			<add databaseType="EntLibContrib.Data.OdpNet.OracleDatabase, EntLibContrib.Data.OdpNet, Version=4.1.0.0, Culture=neutral, PublicKeyToken=null" name="Oracle.DataAccess.Client" />
		</providerMappings>
	</dataConfiguration>
	<oracleConnectionSettings>
		<add name="OracleTest">
			<packages>
				<add name="PKGNORTHWIND" prefix="NWND_" />
				<add name="PKGENTLIB" prefix="RegionSelect" />
			</packages>
		</add>
	</oracleConnectionSettings>
	<connectionStrings>
		<add	name="Service_Dflt"
			providerName="Oracle.DataAccess.Client"
			connectionString="Data Source=XE;User id=Northwind;Password=Northwind;" />
		<add	name="NewDatabase"
			providerName="Oracle.DataAccess.Client"
			connectionString="Data Source=XE;User id=Northwind;Password=Northwind;" />
		<add	name="DbWithOracleAuthn"
			providerName="Oracle.DataAccess.Client"
			connectionString="Data Source=XE;User id=Northwind;Password=Northwind"/>
		<add	name="NwindPersistFalse"
			providerName="Oracle.DataAccess.Client"
			connectionString="Data Source=XE;User id=Northwind;Password=Northwind;Persist Security Info=false"/>
	</connectionStrings>
</configuration>

Last edited Dec 22, 2009 at 9:30 PM by ewdev, version 3

Comments

kiquenet Mar 24 at 10:39 PM 
Any sample configuration for Ent.Lib 5.0 ?

webhayxp Nov 21, 2012 at 6:40 PM 
If you guys need working sample with the correct configuration you can download it from this link
http://entlibcontrib.codeplex.com/SourceControl/changeset/view/69709
Click on Entlibcontrib-> quick start -> data.odpnet it helped me to get my configuration correct

foluis Feb 28, 2012 at 9:47 PM 
So the answer for all those questions is NO!!!

sun1991 Feb 6, 2012 at 4:14 PM 
Is there any detail information about "oracleConnectionSettings" section? I cannot understand what it doing here...

marian_zaki Jan 18, 2012 at 11:23 PM 
should we install ODP.NET or we can just add refernce to the Oracle.DataAccess.dll in the .NET Project
?

kiquenet Jan 13, 2012 at 7:51 AM 
Any sample for ODP.NET and EntLib 5.0 ? thanks

foluis Aug 9, 2011 at 6:42 PM 
Could you please post the OracleDatabase class? The one that is referred in the providerMappings mapping section

foluis Aug 8, 2011 at 10:27 PM 
Is there? (Sample)

RoelA May 22, 2010 at 12:33 AM 
Is there a sample that shows how to use this? thanks