Using Oracle Odp.net 11g. NET Program Publishing method

Odp.net 11g is an Oracle-released Ado.net component for. NET programs to access Oracle databases, better performance than Microsoft's own Oracle components, more access to the UDT (User Defined type) type, Procedure, Ref and so on advanced Oracle features.

The publishing files required by the. NET 1.1 clients are as follows:

Oracle.DataAccess.dll (odt111\odp.net\bin\1.x)

OraOps11.dll (Odt111\bin)

. NET 2.0 needs to be published:

Oracle.DataAccess.dll (odt111\odp.net\bin\2.0)

OraOps11w.dll (Odt111\bin)

The client above requires OCI Basic Package support:

Oci.dll

Oraociei11.dll (can also be replaced with smaller oraociicus11.dll)

Orannzsbb11.dll

For ease of testing on the client side, you can add a Sql*plus package, including two files:

Sqlplus.exe

Orasqlplusic11.dll

The Publish Sqlplus package can use Sqlplus "USER_NAME/PASSWORD@//192.168.1.31:1521/ORCL" to test Oracle's state on the client.

According to the above guidelines, the smallest odp.net Oracle client publishing file includes 5 files, compressed to 8MB:

Oci.dll

Oraociicus11.dll

Orannzsbb11.dll

Oracle.DataAccess.dll

OraOps11.dll