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


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 [New]
  • Passing credentials via OracleCredential class, based on SecureString [New]

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 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 - 2016 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 data types support


Performance


Durability


ADO.NET Entity Framework

  • Entity Framework v1, v4.x, v5, and v6.x support
  • Entity Framework Core 1.x, 2.x, 3.x, 5.0, 6.0, and 7.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
  • Entity Framework Core 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) 2019, 2017, 2016, 2014, 2012, and 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


Script execution


SQL execution monitoring


Design-time enhancements


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
  • Documentation available as a standalone chm file
  • Online documentation
  • 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