dotConnect for Oracle

Features

Direct Mode
Allows your application to work with Oracle directly via TCP/IP without involving Oracle Client.

ASP.NET
Implements Role, Session State, Membership, Profile, Site Map, and other ASP 2.0 providers.

Enterprise Library
Can be used in conjunction with Microsoft Enterprise Library Data Access Application Block.

BIS
Enables Integration Services to export and import data to/from Oracle servers.

Monitoring
Allows per-component tracing of database events with a free dbMonitor application.

Compatibility
Supports Oracle 11g, 10g, 9i, 8i, 8.0, and 7.3 on .NET and .NET Compact Framework 2.0 and higher and Mono.

General usability
• Direct access to server data. dotConnect for Oracle can be used without Oracle Client Software.
• Real RAD for database applications
• Fully compliant with ADO.NET
• 100% managed code
• Highly usable design time support
• Easy to deploy

Network and connectivity
• In Direct mode does not require Oracle Client Software and works directly through TCP/IP
• Both connected and disconnected data access models
• Support for setting connection timeout values for Direct mode
• OS authentication
• DBA privileges to open a session with
• Proxy Authentication support
• Unicode connections

Compatibility
• Full support of the latest versions of Oracle, including Personal and Express editions
• Support for all versions of Oracle Clients, including Instant Client
• Full support for x64 architecture
• .NET Compact Framework support
• Mono Framework support
• Microsoft Visual Studio 2008, 2010, and 2012 support
• CodeGear Delphi 2007 support
• Embarcadero Delphi Prism support
• SQL Server 2008 Business Intelligence Solutions support
• Publisher policy files for versions compatibility

Oracle technology support
• Oracle Advanced Queuing support
• Oracle package support with powerful OraclePackage component
• Ability to manage alerts with OracleAlerter class
• Ability to use pipes with OraclePipe class
• Support for Direct Path interface with OracleLoader component
• Ability to perform SQL and PL/SQL tracing with OracleTrace class
• Support for Oracle Change notifications functionality of Oracle 10g
• Oracle Transparent Application Failover support
• Multiple Oracle Homes support
• DML array operations support
• Direct LOB access support
• Temporary LOB management routines
• Temporary LOBs for updating LOB fields
• Miscellaneous LOB management modes
• OCI Connection Pooling
• Statement Caching
• ROWID values retrieval
• Overloaded stored procedures support
• OracleGlobalization for managing culture settings

Oracle data types support
• All Oracle data types support
• TIMESTAMP and INTERVAL data types support
• PL/SQL table support
• PL/SQL records support
• Support for REF CURSORs, including IN, OUT, and IN/OUT
• Oracle Object (including NOT FINAL objects) types support
• Nested table support
• Objects handling in both connected and disconnected modes
• XMLTYPE data type support

Performance
• High overall performance
• Intelligent fetch block size control
• Advanced connection pooling
• High performance batch processing

ADO.NET technology support
• Full support for ADO.NET Entity Framework v1 and v4
• Server enumeration
• Batch update support
• Extended metadata information retrieval
• Advanced CommandBuilder component with automatic refresh SQL
• Enhanced pooling control through connection string
• Connection string builder
• Provider factory for generating key data access classes
• Asynchronous command execution
• Provider-specific types support
• Password change API
• Database Change Notification Support
• OracleCommand execution cancelling support