OraDirect .NET Data Provider 3.0

OraDirect .NET is a data provider to direct access to Oracle database server for the Microsoft .NET Framework. It is completely based on ActiveX Data Objects for the .NET Framework (ADO.NET) technology.
OraDirect .NET data provider can be used in the same way as the SQL Server .NET or the OLE DB .NET Data Provider.
OraDirect .NET uses Oracle Call Interface (OCI) directly. OCI is low-level native application programming interface to access to Oracle database. Using OCI allows to create lightweight and fast applications working with Oracle.
OraDirect .NET provides functionality for connecting to Oracle database, executing commands, and retrieving results. Those results can be processed directly, or placed in an ADO.NET DataSet for further processing while in a disconnected state.
While in the DataSet, data can be exposed to the user, combined with other data from multiple sources, or passed remotely between tiers. Any processing performed on the data while in the DataSet can then be reconciled to Oracle database.
OraDirect .NET data provider is designed to be lightweight. It consists of a minimal layer between Oracle database and your code. This extends functionality without sacrificing performance.
Main features:
- 100% managed code
- High performance
- Supports Oracle 10g, 9i, 8i and 8.0
- All Oracle data types support
- Support Oracle object types OBJECT, VARRAY, TABLE, REF
- Support Oracle XML type
- Easy to deploy
- OracleScript component to execute scripts
- OracleLoader component for fast loading data
- OraclePackage component for easy working with PL/SQL packages
- OracleDataTable component to retrieve and manipulate data from Oracle server data source
- Metadata retrieval support
- Ability of monitoring query and stored procedures execution by DBMonitor
- Array binding feature
- PL/SQL tables support
- PL/SQL records support
- OS authentication enabled
- DBA privileges to open a session with
- Transparent Application Failover support
- Fill DataSet with several REF CURSOR
- Fill DataSet with object, array and nested table data
- Advanced connection pooling
- Paginal access to query result
- Base-Class-Based provider model
- Working with Oracle homes
- Advanced design-time editors
- Integrated OraTools to design, debug and try SQL and PL/SQL and browse schema objects
- Migration wizard from MS OracleClient and ODP.NET
- Help integrated into Visual Studio .NET
- Free support for registered users
- Licensed per a developer without royalty fee
OraDirect .NET supports Oracle 10g, 9i, 8i and 8.0, including Personal and Lite editions. The provider works with .NET Framework 1.0, 1.1, 2.0, and can be used with the following development environments:
- Microsoft Visual Studio .NET 2005 Beta 1
- Microsoft Visual Studio .NET 2003, 2002
- Borland Delphi 2005, Delphi 8
- Borland C#Builder
OraDirect .NET can be used together with UniDirect .NET data provider that provides universal access to different databases within a single code.