Features

In This Topic

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 8 support
.NET 7 support
.NET 6 support
.NET 5 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, 6, and 7 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

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

[email protected]