Direct Connection to Oracle
dotConnect for Oracle allows connecting to Oracle Database via TCP/IP without any need for Oracle Client, which greatly simplifies application development and deployment.

• Easy connection without Oracle Client.
• Full support for Oracle-specific data types.
• Robust security with advanced encryption and authentication.
• Flexible connectivity options for diverse operational environments.
• Cost-effective deployment.

Advanced ORM Support
dotConnect for Oracle offers enhanced ORM support with a bundled visual designer for ORM models - Entity Developer.

Features

• Advanced connection configuration - Easily manage Oracle database connections with tools like OracleConnectionStringBuilder and OracleCredential, enabling dynamic runtime configuration. Use Oracle environment management (OracleHome, OracleHomeCollection) and metadata access for flexible, multi-home Oracle database connectivity in complex .NET deployments.
• Support for Oracle-specific data types - Fully utilize Oracle's rich data types, including LOBs (OracleLob, OracleBFile), UDTs (OracleObject, OracleArray, OracleRef), and XML storage (OracleXml). dotConnect simplifies working with custom Oracle structures and offers strong .NET mapping for safer, more productive development.
• Bulk data operations and backups - Streamline data migration and ETL processes with OracleLoader that provides high-performance bulk data loading capabilities. Create and manage database backups with built-in scripting support (OracleScript, OracleSqlStatementCollection), simplifying maintenance and preserving data integrity across environments.
• Secure connectivity and configuration - Ensure robust security and high availability for mission-critical applications with built-in support for SSH tunneling, SSL encryption, and advanced connection failover handling (OracleFailoverEventsArgs). dotConnect also integrates tightly with Oracle RAC and supports transparent application failover for continuous availability.
• Event-driven monitoring and change tracking - Build responsive applications with Oracle-specific event-driven APIs. Use OracleDependency for query notifications, OracleAlerter and OracleAlert for DBMS_ALERT integration, and OracleQueue for Advanced Queuing (AQ). Track SQL execution and performance diagnostics with OracleMonitor and OracleTrace for precise runtime monitoring.
• Development wizards in Visual Studio - Enhance Oracle development with Visual Studio wizards for connections, DataSets, and migrations to boost productivity and simplify database tasks.