I have successfully connected to an Oracle database (10g) from C# (Visual Studio 2008) by downloading and installing the client administration tools and Visual Studio 2008 on my laptop.
The installation footprint for Oracle Client tools was over 200Mb, and quite long winded.
Does anyone know what the minimum workable footprint is? I am hoping that it's a single DLL and a register command, but I have the feeling I need to install an oracle home, and set various environment variables.
I am using Oracle.DataAccess in my code.
You need an Oracle Client to connect to an Oracle database. The easiest way is to install the Oracle Data Access Components.
To minimize the footprint, I suggest the following :
This amounts to about 19Mb (v10).
If you do not care about sharing this folder between several applications, an alternative would be to ship the above mentioned DLLs along with your application binaries, and skip the PATH setting step.
If you absolutely need to use the Oracle provider (Oracle.DataAccess), you will need :
Note that I haven't tested this latest configuration...
As of 2014, the OPD.NET, Managed Driver is the smallest footprint.
Here is a code usage comparison to the non-managed versions that previous (outdated) answers suggested: http://docs.oracle.com/cd/E51173_01/win.122/e17732/intro005.htm#ODPNT148
You will need to download these dlls and reference
Oracle.ManagedDataAccess.dll in your project:
Download the ODP.NET, Managed Driver Xcopy version only
Here is a typical foot print you will need to package with your release:
all together, a whopping 6.4 MB for .Net 4.0.