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
• Easy to update to a new version via NuGet packages

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 the Direct mode
• DBA privileges to open a session with
• Unicode connections
• Multiple Oracle Homes support
• Server enumeration
• Support for starting and stopping an Oracle database instance

Security

• OS authentication (NTLM)
• Proxy Authentication support
• Oracle Data Encryption
• Oracle Data Integrity
• Support for encryption algorithms: RC4, RC4-56, RC4-128, RC4-256, DES-40, DES-56, DES-112, DES-168, AES-128, AES-192, AES-256
• Support for checksum algorithms: MD5, SHA1, SHA256, SHA384, SHA512
• Full support for operation in the FIPS 140-2 mode in Windows
• SSL/TLS encryption support
• SSH encryption support
• Passing credentials via OracleCredential class, based on SecureString

Compatibility

• Full support of the latest Oracle versions from Oracle 23c to Oracle 8, including Personal and Express editions
• Support for Oracle Cloud Database as a Service (DBaaS)
• Support for all versions of Oracle Clients, including Instant Client
• Support for both x64 and x86 architecture
• Windows, Linux, MacOS support
• .NET 5.0-9.0 support
• .NET Core 3.x, 2.x, and 1.x support
• .NET Standard 2.1, 2.0, 1.6, 1.5, 1.4, and 1.3 support
• .NET Frameworks 4.8, 4.7, 4.6, 4.5, 4.0, 3.5, 2.0 support
• .NET Compact Framework support
• Mono Framework support
• Microsoft Visual Studio 2022, 2019, 2017, 2015, 2013, 2012, 2010, and 2008 support
• CodeGear Delphi 2007 support
• Embarcadero Delphi Prism support
• SQL Server 2008 - 2023 Business Intelligence Solutions support
• Support for Enterprise Library Data Access Application Block (DAAB)
• Publisher policy files for versions compatibility
• Sync Framework support

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
• Ability to perform SQL and PL/SQL tracing with OracleTrace class
• Support for Object Change Notification (OCN)
• Support for Query Result Change Notification (QRCN)
• ROWID values retrieval
• Overloaded stored procedures support
• OracleGlobalization for managing culture settings
• OCI Statement Caching support
• DBMS_APPLICATION_INFO package support
• Password change API
• Extended metadata information retrieval
• OracleCommand execution cancelling support

Oracle data types support

• All Oracle data types support
• Direct LOB access support
• Temporary LOB management routines
• Temporary LOBs for updating LOB fields
• Miscellaneous LOB management modes
• 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
• Auto increment identity columns support
• Provider-specific types support

Performance

• High overall performance
• Intelligent fetch block size control
• Several pooling kinds support: unmanaged OCI pooling and managed pooling implementation.
• Support for Direct Path interface with OracleLoader component
• RAC support
• Oracle Database Sharding support
• Single Client Access Name (SCAN) support
• Load Balancing support
• Database Resident Connection Pool(DRCP) support
• Prepared statements support
• Flexible LOB prefetch configuration
• High performance batch processing
• DML array operations support
• Session Data Unit configuration in both Direct and OCI modes
• Asynchronous command execution
• Performance Counters support

Durability

• Oracle local transactions support
• Oracle distributed transactions support
• Oracle Services for Microsoft Transaction Server (OraMTS) support
• Oracle Transparent Application Failover support
• Support for HA events from Oracle RAC [New]
• Oracle Transaction Guard support

ADO.NET Entity Framework

• Entity Framework 1, 4.0, 4.5, 5, and 6.4.4 support
• Entity Framework Core 1.1, 2.2, 3.1, 5.0, 6.0, 7.0, and 9.0 support
• High performance, because of Batch Updates, Oracle Hints, etc.
• Wide support for LINQ to Entities
• Entity Framework Code First support
• Entity Framework Code First Migrations support
• Full CRUD (Create, Retrieve, Update, Delete) support, including CRUD via stored procedures
• Wide support for server data types
• Entity Framework Spatials support
• Change tracking and Object data caching support
• Inheritance mapping support (TPH, TPT, and TPCT models)
• Stored procedures and functions support
• Ability to build database-independent applications
• Full-text search support
• Reverse engineering of database objects to entity model in several ways:
  • Via Entity Developer
  • With Visual Studio EDM Wizard/EF Tools
  • Scaffold-DbContext
• Support for most Entity Framework Canonical Functions and EntitySQL
• Visual model creation and code generation with Entity Developer
  • Update Model From Database functionality for Entity Developer
  • Update To Database with Mapping Synchronization functionality for Entity Developer
• Illustrated tutorial to get started with Entity Framework in 5 minutes

LinqConnect (formerly known as LINQ to Oracle)

• LinqConnect is a fast and easy to use ORM solution, developed closely to the Microsoft LINQ to SQL technology, and having its own features
• Visual model creation and code generation with Entity Developer
  • Update Model From Database functionality for Entity Developer
  • Update To Database with Mapping Synchronization functionality for Entity Developer
• Illustrated tutorial to get started with LinqConnect in 5 minutes

Workflow Foundation Support

• Oracle Workflow Instance Store support
• OracleTrackingParticipant class to store tracking records in a Oracle database

Extended DataTable and DataSet functionality

• Powerful OracleDataTable component for manipulating individual tables or query result
• Structural representation and editing of Oracle objects
• NonBlocking mode allows fetching data asynchronously in the background
• Fill DataSet with several REF CURSOR
• Fill DataSet with object, array and nested table data
• Advanced CommandBuilder component with automatic refresh SQL
• On-demand data fetch for data-bound controls
• Paginal access to query result
• Server side master-detail relation based on queries
• Ability to refresh individual records in OracleDataTable component
• Extended warning and error information retrieval
• Extended interface for processing execution exceptions
• OracleDataAdapter.Fill method with sequential fetch support
• Ability to defer fetching of some columns in a resultset
• Custom Oracle Object mapping with ICustomOracleObject interface

Business Intelligence Solutions Support

• SQL Server Integration Services (SSIS) 2016, 2014, 2012, 2008 support
• SSIS DataFlow Source and Destination components
• Analysis Services support
• Reporting Services support

WinForms-specific features

• Flexible data binding with DataLink component
• InterForm technology for cross-form components cooperation
• Oracle Object data binding Support
• Global position synchronization within a data source

ASP.NET-specific features

• ASP.NET Core support
• ASP.NET Identity 1 and 2 support
• ASP.NET data providers: Membership, Role, Session State, Profile, Personalization, Site Map, Web Event
• OracleDataSource web component
• OracleCacheDependency component to control Cache item dependencies in ASP.NET applications

Script execution

• Advanced script execution features with OracleScript component
• Support for executing individual statements in scripts
• Support for executing huge scripts stored in files with dynamic loading
• Ability to use standard SQL*Plus tool syntax in scripts

SQL execution monitoring

• Extended SQL tracing capabilities with OracleMonitor component
• Support for dbMonitor utility for advanced tracing analysis and control
• Per-component SQL tracing
• Optional log output to IDE toolwindows

Design-time enhancements

• Automatic component registration in toolbox
• Advanced integration with Visual Studio 2008, 2010, 2012, 2013, 2015, 2017, 2019, and 2022 including Server Explorer, Data Source wizard, TableAdapter configuration, Query Builder and configuring web component OracleDataSource
• DataSet Wizard to create and edit typed Oracle-oriented datasets
• DataSet Manager to list and bind datasets in the project
• DataSet Editor to edit dataset contents
• Oracle Package Wizard that simplifies working with PL/SQL Packages
• Oracle Object Wizard that simplifies working with Oracle Objects
• Advanced design-time component and property editors
• IntelliSense descriptions for dotConnect for Oracle classes
• Easy migration from MS OracleClient and ODP.NET with Migration Wizard
• Syntax highlighting and SQL code completion in design-time editors
• TableMappings editor
• Convenient instant data preview and management in design time

dbForge Fusion for Oracle main features

• Integration with dotConnect for Oracle for enhanced component designers and drag-and-drop features
• PL/SQL debugger
• SQL code completion and navigation
• Visual query builder
• Database Explorer
• Visual object editors
• Database search engine
• Code template library
• Security Manager
• Session Manager
• Export/Import Wizards

Product clarity

• Complete documentation sets integrated into Visual Studio and Embarcadero Delphi
• Integration with Visual Studio and MSDN help collections
• A large amount of helpful demos in C# and VB

Licensing and support

• Included annual dotConnect for Oracle Subscription with Priority Support
• Licensed royalty-free per developer, per team, or per site