odp.net – Tarik Billa

How to write a .Net application that works with both SqlServer and Oracle (now that System.Data.OracleClient is deprecated)

January 9, 2024 by Tarik

EDIT: The fully managed ODP.NET is now available in production. It is very small (less than 10MB) and is not dependent on other files. You can obtain it here: http://www.oracle.com/technetwork/topics/dotnet/downloads/index.html Original answer: One way to easily ensure that the required Oracle client side software (including ODP.NET) is always available on the deployment machine is to … Read more

Could not load file or assembly Oracle.DataAccess

January 2, 2024 by Tarik

In the IIS Manager select your server and select “Application Pools“. Select the application pool used by your Web App and click on “Advanced Settings” from the right hand menu. In the “General Section” of the advanced Settings click on the “Enable 32-bit Applications” and set it to True. This fix only applies to 64-bit … Read more

Deploying and Configuring ODP.NET to work without installation with Entity Framework

September 17, 2023 by Tarik

This answer summarizes (hopefully) all the steps required, many of which documented in various places online and might save someone hours of Googling. A. How to deploy and configure Oracle.DataAccess.Client. A.1. Download ODAC112030Xcopy_64bit.zip or ODAC112030Xcopy_32bit.zip. A.1.1. Extract the content of the following folders within the zip file into your application/host’s bin/setup folder: A.1.1.1. instantclient_11_2 A.1.1.2. … Read more

What is the minimal setup required to deploy a .NET application with Oracle client 11?

August 31, 2023 by Tarik

Josh- Thank you very much for taking the time to answer. Your instructions helped a whole lot, and are very close to what I have found on my own. Interestingly enough, I found it can be slimmed a little more. For those in my situation who Do not want their users to have to install … Read more

Oracle ODP.net Managed vs Unmanaged Driver

August 22, 2023 by Tarik

I would like to share some results. I think that the small lack of performance is worth compared to the easiness of deployment. Note: seg means seconds. Sorry about that. Of course that it is a simple test, and there are several topics that is not covered like connection pool, stability, reliability and so on… … Read more

Does ODP.NET require Oracle Client installation

August 21, 2023 by Tarik

Alex Keh from Oracle in aug 2013 says: Managed ODP.NET is released. It is currently part of the Oracle DB 12c client. To use managed ODP.NET, you have to download and install the DB client. From there, you can extract just the managed ODP.NET assembly and setup files. These files are less than 10 MB … Read more

Can you use Microsoft Entity Framework with Oracle? [closed]

January 14, 2023 by Tarik

Update: Oracle now fully supports the Entity Framework. Oracle Data Provider for .NET Release 11.2.0.3 (ODAC 11.2) Release Notes: http://docs.oracle.com/cd/E20434_01/doc/win.112/e23174/whatsnew.htm#BGGJIEIC More documentation on Linq to Entities and ADO.NET Entity Framework: http://docs.oracle.com/cd/E20434_01/doc/win.112/e23174/featLINQ.htm#CJACEDJG Note: ODP.NET also supports Entity SQL.

The provider is not compatible with the version of Oracle client

November 13, 2022 by Tarik

I’ve been looking into this problem further, and you simply need to grab all the appropriate DLL’s from the same downloaded version of ODP.Net and put them in the same folder as your Exe file, because ODP.Net is fussy about not mixing version numbers. I’ve explained how to do this here: http://splinter.com.au/using-the-new-odpnet-to-access-oracle-from-c Here’s the gist … Read more