Key Features of dotConnect for Oracle

Compatibility

  • Support for Oracle servers 23c, 21c, 19c, 18c, 12c, 11g, 10g, 9i, 8i, and 8.0, including Personal and Express editions.
  • Integration with Oracle Cloud Database as a Service (DBaaS) in Oracle Cloud, Oracle on Azure, and Amazon RDS for Oracle
  • Compatibility with all versions of Oracle Clients 23c, 21c, 19c, 18c, 12c, 11g, 10g, 9i, 8i and 8.0, including Instant Client
  • Support for Oracle TimesTen 11g Release 1 and Oracle TimesTen 11g Release 2.
  • Architecture availability for both x64 and x86 systems
  • Platform support for Windows, Linux, and macOS

Platforms

  • .NET 5.0-9.0
  • .NET Core 1.x-3.0
  • .NET Standard 1.3-2.1
  • .NET Frameworks 2.0–4.8
  • ASP.NET Core
  • Blazor
  • .NET MAUI (previously Xamarin)
  • .NET Compact Framework
  • Mono Framework
  • Sync Framework

.NET languages

  • C#
  • VB.NET
  • F#

ORM support

  • Entity Framework Core 1.x-9.0
  • Entity Framework v1-v6
  • Dapper 1.x, 2.x
  • NHibernate 1.x-5.x
  • LINQ to Entities

Entity Framework features

  • Spatials support
  • Change tracking and object data caching support
  • Inheritance mapping support (TPH, TPT, TPCT models)
  • Stored procedures and functions support
  • Ability to build database-independent applications
  • Full-text search support

With Entity Developer

  • Visual model creation and code generation
  • Model update from the database
  • Database update with mapping synchronization
  • Reverse engineering of database objects to an entity model
  • Storage schema editing of Entity Framework
  • Standalone usage or Visual Studio integration

Security standards

  • SSL/TLS and SSH connections
  • Proxy authentication
  • OS authentication (NTLM)
  • Oracle data encryption
  • Oracle data integrity
  • Encryption algorithms: RC4, RC4-56, RC4-128, RC4-256, DES-40, DES-56, DES-112, DES-168, AES-128, AES-192, and AES-256
  • Checksum algorithms: MD5, SHA1, SHA256, SHA384,
    and SHA512
  • Operation in the FIPS 140-2 mode on Windows
  • Passing credentials via the OracleCredential class
    using SecureString

Certification

  • DigiCert Trusted G4 Code Signing RSA4096 SHA384
    2021 CA1

Performance

  • Intelligent fetch block size control
  • Unmanaged OCI pooling and managed
    pooling implementations
  • Direct Path interface with the OracleLoader component
  • RAC support
  • Oracle Database Sharding
  • Single Client Access Name (SCAN) support
  • Load balancing
  • Database Resident Connection Pooling (DRCP)
  • Prepared statements
  • Flexible LOB prefetch configuration
  • High-performance batch processing
  • DML array operations
  • Session Data Unit configuration in both Direct and
    OCI modes
  • Asynchronous command execution
  • Connection pool performance counters

IDE integration

Visual Studio

Microsoft Visual Studio 2008-2022

  • DataSet Wizard for creating and editing typed Oracle-oriented datasets
  • DataSet Manager for listing and binding datasets in the project
  • DataSet Editor for editing dataset contents
  • Oracle Package Wizard for simplifying work with
    PL/SQL packages
  • Oracle Object Wizard for facilitating work with
    Oracle objects
  • Advanced design-time component and property editors
  • IntelliSense support with descriptions for dotConnect for Oracle classes
  • Easy migration from MS OracleClient and ODP.NET with the Migration Wizard
  • Syntax highlighting and SQL code completion in design-time editors
  • TableMappings editor
  • Convenient instant data preview and management at design time

Without design-time integration

  • Visual Studio Code
  • JetBrains ReSharper and Rider
  • CodeGear Delphi 2007
  • Embarcadero Delphi Prism
  • Support for the Enterprise Library Data Access Application Block (DAAB)

ADO.NET architecture

  • Batch update support
  • Extended metadata information retrieval
  • Advanced CommandBuilder component with automatic refresh SQL
  • Enhanced pooling control through the 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
  • Possibility to retrieve the last auto-incremented value
  • Retrieval of output parameters from stored procedures and functions

NuGet availability

Devart.Data.Oracle 
dotnet add package Devart.Data.Oracle
Devart.Data.Oracle.EFCore 
dotnet add package Devart.Data.Oracle.EFCore
Devart.Data.Oracle.EFCore.Design 
dotnet add package Devart.Data.Oracle.EFCore.Design
Devart.Data.Oracle.EF6 
dotnet add package Devart.Data.Oracle.EF6

Script execution

  • Advanced script execution capabilities with the
    OracleScript component
  • Support for executing individual statements within scripts
  • Support for executing large scripts stored in files with dynamic loading
  • Ability to use standard SQL*Plus syntax in scripts

SQL execution monitoring

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

Oracle durability

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

WinForms-specific features

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

Oracle data types

  • Support for All Oracle data types
  • Direct LOB access support
  • Temporary LOB management routines
  • Temporary LOBs for updating LOB fields
  • Various LOB management modes
  • Support for TIMESTAMP and INTERVAL data types
  • PL/SQL table support
  • PL/SQL records support
  • Support for REF CURSORs, including IN, OUT, and IN/OUT
  • Support for Oracle Object types (including NOT FINAL objects)
  • Nested table support
  • Objects handling in both connected and
    disconnected modes
  • XMLTYPE data type support
  • Support for auto-increment identity columns
  • Support for provider-specific types

Oracle-specific features

  • Oracle Database Advanced Queuing
  • Oracle package support with the powerful
    OraclePackage component
  • Ability to manage alerts with the OracleAlerter class
  • Ability to use pipes with the OraclePipe class
  • Ability to perform SQL and PL/SQL tracing with the OracleTrace class
  • Object Change Notification (OCN)
  • Query Result Change Notification (QRCN)
  • Retrieval of ROWID values
  • Support for overloaded stored procedures
  • OracleGlobalization for managing culture settings
  • OCI Statement Caching support
  • DBMS_APPLICATION_INFO package support
  • Password change API
  • Extended metadata information retrieval
  • OracleCommand execution cancellation

Extended DataTable and DataSet functionality

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