The Oracle data Access Components (ODAC) library provides a number of non-visual components for Borland delphi,c++ Builder and Kylix. They are used to access Oracle relational database systems. Similar to BDE, ODAC is also one of the alternative ways to process data.
The ODAC directly uses the Oracle call Interface (OCI). OCI is a process or function that allows application developers to access an Oracle data server using a third-party development language, and an application interface (API) that controls the execution state of all SQL statements. OCI is through a dynamic runtime library (ora*. DLL) provides a standard database access library and functions to establish a connection in the application. You can also use the ODAC net option without having to install an Oracle client on the client computer to connect to Oracle. In this case, ODAC only needs the support of the TCP/IP protocol to create a true, minimal database application.
Unlike the use of BDE to develop Oracle C/s (client/server) applications, BDE does not have access to some of the special features of Oracle, the use of more resources, the inability to process data at high speeds, and the occasional cumbersome application distribution and management.
During the. NET (C #) programming process, the following three free-to-install Oracle Access components are used to access the Oracle database without installing Oracle clients
1:oracle Data Provider for. NET, Managed Driver:Oracle's official managed database access Components, single dll,oracle.manageddataaccess.dll, direct reference, usage and related documents: http://www.oracle.com/technetwork/ Issue-archive/2014/14-mar/o24odp-2147205.html
2:oracle Data Access componentsThe same Oracle-provided database access component is unmanaged, but Oracle provides a. NET Wrap Dll, That is Oracle.DataAccess.dll, this component is required to be installed, but can also be treated by a certain process, the use of free installation, see: http://blog.csdn.net/rrrrssss00/article/details/7178515
3:datadirect ODBC drivers from OracleThird-party managed database access components, that is, the famous DDTek.Oracle.dll, free installation, direct use, very convenient, how to use: http://blog.csdn.net/rrrrssss00/article/details/5757301
contrast 1: accessibilityThe first two are available for Oracle and are free to download at http://www.oracle.com/technetwork/topics/dotnet/ UTILSOFT-086879.HTML,ODAC's package is both managed and unmanaged third, Ddtek for commercial software, need to buy, also can be free trial (online also cracked)
Summary: 1 equals 2 is better than 3 (the words are all the same when using a cracked ...) ）
Contrast 2: Ease of UseThe first kind: Single DLL, direct reference can be the second: Refer to the above usage article, need to find multiple dependent DLL files from different ODAC package, put together to use, slightly inconvenient, and different version of the ODAC, the number of dependent DLLs and the location of the DLL files are not the same .... The Third Kind: Single DLL file plus license file, also direct reference
Summary: 1 equals 3 better than 2 (ODAC find DLL to really bother)
Contrast 3: FunctionalThe first, ODP Managed Driver, a part of the functionality in this managed version is not implemented, detailed reference: http://www.oracle.com/technetwork/database/windows/downloads/ Odpmbetainstall-1696475.html#known%20issues the last two tables of this page, such as bulkcopy and Customtype are not supported by the second, ODAC, this function is the most third kind, Ddtek, which is also fully managed, has some functional limitations, but slightly more than the first, such as BulkCopy, which is supported
Summary: 2 better than 3 better than 1
