Connecting to the Oracle database in C # has suffered a variety of pain.
Using the VS Default way to connect to Oracle Discovery has version limitations, and you also need to install Oracle's clients, otherwise you won't be able to connect. The version of the client is not connected to the version of the Oracle database.
On the internet also found a lot, tried to use odp.net to connect, found the same, even after the reference DLL, a run will be error. The trouble is dead.
Finally, found a way to use a third-party library to achieve, found a cracked version of the. After the test is feasible, do not need to install the client, do not need to install other, directly can connect.
Test environment:
PC: WIN7 64-bit, with Oracle64bit client installed.
Database: WIN2003, the Oracle 32bit database is installed
I hereby record it. Also attached to the test written in the complete demo source, containing the corresponding cracked library files.
Address: Demo Source download
Enable C # Direct connection to Oracle database operations without installing a variety of plugins