New .NET Features for Oracle Database

New .NET Features for Oracle Database

The list below details when new Oracle .NET features were introduced. It does not cover bug fixes nor minor changes. The version numbers refer to the Oracle .NET product version when the feature was introduced, not the Oracle database server nor client version number. Many of the new .NET features can be used with older database server versions. To learn more about these features, read the "Changes" section in the Oracle documentation of the product.

New ODP.NET Features by Release

Version 23.6

  • Kerberos (core)
  • OpenTelemetry enhancements (core and managed)
  • Vector BINARY numeric format (core and managed)
  • Easier proxy server setup for cloud deployments (core and managed)
  • IsFloatingPointNumber schema table column (core and managed)
  • Disallow Universal Naming Convention paths (core and managed)
  • User-created wallet stored client secret for Azure service principal authentication (core and managed)
  • Disable double encryption and double data integrity (core and managed)

Version 23.5.1

  • Eliminates exception using Transparent Application Failover SELECT mode (core and managed)

Version 23.5

  • REF CURSOR column type (core and managed)
  • Globally suppress GetDecimal invalid vast exception (core and managed)
  • OpenTelemetry activity tag for rows affected by SQL (core and managed)
  • ODP.NET product information and application metadata (core and managed)
  • Bulk copy notification after all rows processed (core and managed)
  • OCI Object Storage change notification for connection information (core and managed)
  • Easy Connect Plus address lists (core and managed)
  • Microsoft identity platform tokens v2.0 enhancement (core and managed)
  • System.Text.Json DLL and dependency dynamic loading (unmanaged)

Version 23.4

  • AI vector search and vector data types
  • Public OracleMigrationSqlGenerator class (managed)

Version 23.3.3

  • Transparent Application Failover (TAF) and callbacks (core and managed)
  • Faster authentication for the first new connection (core and managed)

Version 23.3.2

  • .NET Metrics (core and managed)
  • OpenTelemetry – automatic instrumentation and dynamic enablement (core and managed)
  • Centralized configuration providers – cloud vault and new config options (core and managed)
  • Microsoft Certificate Store certificate selection using thumbprints (core and managed)

Version 23.3

  • Centralized configuration providers (core and managed)
  • Azure Active Directory single sign-on (core and managed)
  • Oracle IAM single sign-on token (core and managed)

Version 23.2

  • Asynchronous programming (core and managed)
  • Pipelining (core and managed)
  • Advanced Queuing and Transactional Event Queues (core and managed)
  • Application Continuity and Transparent Application Continuity (core and managed)
  • OpenTelemetry (core and managed)
  • JSON Relational Duality
  • SQL BOOLEAN data type
  • Oracle True Cache
  • Disabling auto-commit (core and managed)
  • SQL domain name and schema
  • Annotations
  • Increased database password length
  • TLS 1.3
  • Sharding split partitionset (core and managed)
  • Programmatic database startup and shutdown (core and managed)

Version 21.12

  • .NET Runtime 8 (core)
  • Entity Framework Core 8 (core)

Version 21.8

  • .NET Runtime 7 (core)
  • Entity Framework Core 7 (core)

Version 21.7

  • Azure Active Directory (core and managed)
  • TLS 1.3 (core and managed)

Version 21.6.1

  • Secure External Password Store support for non-Windows platforms (core)
  • Oracle IAM - Database alternate password (core)
  • Oracle IAM - IAM password, token, and database alternate password (managed)

Version 21.5

  • One-way TLS/SSL without wallets (unmanaged)

Version 21.4.1

  • .NET Runtime 6 (core)
  • Entity Framework Core 6 (core)
  • Oracle Identity and Access Management cloud service (core)

Version 21.4

  • One-way TLS/SSL without wallets (core and managed)
  • Debian and Ubuntu Linux distribution certification (core)

Version 21.3

  • User-defined types (core and managed)

Version 21.1

  • Entity Framework Core 5 certification (core)
  • Binary JSON column data type
  • Client Initiated Continuous Query Notification
  • Sharding (core and managed)
  • More administrative privileges: SYSBACKUP, SYSDG, SYSKM, and SYSRAC
  • Trace redaction (core and managed)

Version 19.16

  • TLS 1.3 (core and managed)

Version 19.15.1

  • Azure Active Directory

Version 19.14

  • One-way TLS/SSL without wallets (unmanaged)

Version 19.13.1

  • Oracle Identity and Access Management cloud service (core)

Version 19.13

  • One-way TLS/SSL without wallets (core and managed)

Version 19.11

  • .NET Decimal retains trailing zeros after decimal point from Oracle NUMBER

Version 19.10

  • .NET Runtime 5 certification (core)
  • Bulk Copy (core and managed)
  • Oracle provider types deserialization into DataSet/DataTable
  • KeepAlive on non-Windows platforms (core)
  • LDAP on non-Windows platforms (core)
  • Suppress GetDecimal invalid cast exception

Version 19.8 for ODAC 19c Release 2

  • Entity Framework Core 3.1 Certification (core)

Version 19.7

  • Websocket and Websocket with SSL/TLS (core and managed)
  • Connection string attributes: Tns_Admin and Wallet_Location (core and managed)
  • SYSASM privileged connections (core and managed)

Version 19.6

  • .NET Core 3.1 certification (core)
  • Linux 8 certification (core)
  • Entity Framework 6.4 certification (managed and unmanaged)

Version 19.5

  • .NET Core 3 certification (core)
  • Entity Framework Core 2.1 certification (core)

Version 19.3 for ODAC 19c Release 1

  • Entity Framework Core 2.2 certification (core)
  • Dynamically enabled tracing and trace file size Limit
  • More configuration options with new OracleConnection properties (core and managed)
  • SYSASM privileged connections (unmanaged)

Version 19.3

  • .NET Framework 4.8 certification
  • Easy Connect Plus
  • Secure Oracle Notification Service connections
  • Configuration as code (managed)
  • Lightweight Directory Access Protocol (LDAP) on Windows (core)
  • Performance counters (core)

Version 18.3 for ODAC 18c Release 1

  • ODP.NET for .NET Core on Windows and Linux

Version 18.3

  • .NET Framework 4.7.x certification, including 4.7.1 and 4.7.2
  • Secure passwords with OracleCredential class

Version 12.2.0.1

  • .NET Framework 4.6.2 Certification
  • Application Continuity (unmanaged)
  • Sharding and ODP.NET Routing (unmanaged)
  • Longer Schema Identifiers
  • ODP.NET PL/SQL Boolean Data Type (managed)

Version 12.2.0.1 for ODAC 12.2 Release 1

  • .NET Framework 4.7 Certification
  • Entity Framework 6.2 Certification
  • Database Resident Connection Pooling
  • Multitenant and Pluggable Databases Connection Pooling
  • Edition-Based Redefinition Connection Pooling
  • Connection Configuration Upon Open

Version 12.1.0.24160719 for NuGet (September, 2016)

  • ODP.NET, Managed Driver can connect to Oracle Database Exadata Express Cloud Service

Version 12.1.0.24160419 for NuGet (April, 2016)

  • Data Integrity/Checksumming (managed)
  • Transport Layer Security (TLS) 1.1 and 1.2 (managed)
  • Configuration settings with relative Windows Paths and Windows Environment Variables (managed)
  • Search for *.ORA files in .EXE directory before looking in current working directory (managed)

Version 12.1.0.2 in ODAC 12c Release 4

  • .NET Framework 4.6 and 4.6.1 certification
  • Windows installer (managed)
  • Network data encryption (managed)
  • Secure External Password Store (managed)
  • Microsoft Local Security Authority (managed): MSLSA Kerberos credential cache
  • SSL/TLS Connections Use a Single Port (managed)
  • Service Relocation Connection Timeout: Avoid connection attempts to an unavailable service
  • Transaction Guard (unmanaged): Less application code needed to manage transaction recovery
  • Transaction Guard (managed)
  • Fully Managed Code for Distributed Transactions (unmanaged)
  • SQL Translation Framework (unmanaged): Migrate vendor-proprietary SQL syntax to semantically-equivalent Oracle syntax
  • Tracing: Improves and unifies tracing features between managed and unmanaged ODP.NET

Version 12.1.0.2 in ODAC 12c Release 3

  • Entity Framework 6 certification
  • Entity Framework 6 Code First
  • Entity Framework 6 Code First Migrations
  • NuGet package (managed)
  • XML DB support (managed)
  • Distributed transactions without Oracle.ManagedDataAccessDTC.dll (managed)
  • Kerberos (managed)

Version 12.1.0.2

  • .NET Framework 4.5.2 certification
  • Character data types increased to 32 KB (managed)
  • Return number of rows affected from each input in array binding operations (managed)
  • Version 12.1 in ODAC 12c Release 2

    • .NET Framework 4.5.1 certification
    • More easily distinguish ODP.NET, Managed Driver versions

    Version 12.1 in ODAC 12c Release 1

    • LDAP Connections to Active Directory and Oracle Internet Directory (managed)

    Version 12.1.0.1 in Oracle Database 12c

    • ODP.NET, Managed Driver
    • Multitenant container database support in Oracle Database 12c
    • Auto increment Identity column support (unmanaged)
    • Character data types increased to 32 KB (unmanaged)
    • ODP.NET PL/SQL Boolean data type (unmanaged)
    • Enhanced implicit REF Cursor binding
    • Return number of rows affected from each input in array binding operations (unmanaged)
    • LINQ: SQL APPLY keyword support for lateral views
    • Transaction Guard support: Ensures transactions commit at-most-once even after outages (unmanaged)
    • Faster and less disruptive planned database outages
    • Oracle Notification Service (ONS) support
    • Global Data Services support: Adds ODP.NET run-time connection load balancing and fast connection failover to Oracle Data Guard and GoldenGate
    • Transaction and connection association: ODP.NET connections, by default, detach from transactions only when connection objects are closed or transaction objects are disposed

    Version 11.2.0.3.20

    • .NET Framework 4.5 certification
    • Entity Framework 5 certification

    Version 11.2.0.3.0

    • ADO.NET Entity Framework 4 and LINQ to Entities
    • WCF Data Services and OData
    • Implicit REF CURSOR Parameter Binding

    Version 11.2.0.2.1

    • 64-bit Instant Client for Windows x64: Smaller ODP.NET and xcopy installation
    • TimesTen In-Memory Database Support: Faster ODP.NET performance through TimesTen access
    • 64-bit .NET Framework 4 and .NET Framework 4 Client Profile support

    Version 11.2.0.1.2

    • 32-bit .NET Framework 4 and .NET Framework 4 Client Profile support

    Version 11.2.0.1.0

    • Edition-Based Redefinition: Allows upgrading the database component of an application while in use by .NET, thereby minimizing or eliminating down time
    • End-to-End Tracing using ClientInfo attribute

    Version 11.1.0.7.20

    • Oracle Streams Advanced Queuing API: Build .NET messaging applications with Oracle's database-integrated queue
    • Promotable Transactions: Promote local transactions to distributed during run time
    • Application Self-Tuning: Automatically optimizes statement cache size at run time
    • Faster Data Retrieval and Optimized Memory Usage
    • Code Access Security: Enforce imperative and declarative Oracle security
    • High Availability Event Notification and Callback: Create event handlers to respond to database status changes
    • Programmatic Database Startup and Shutdown

    Version 11.1.0.6.20

    • 32-bit Instant Client: Smaller ODP.NET client and xcopy installation
    • User-Defined Types: Map Oracle objects, collections, and REFs to .NET custom types
    • ADO.NET 2.0 Bulk Copy: Upload large data sets into Oracle from .NET
    • Process Database Down Events: ODP.NET automatically frees connections to a downed Data Guard instance
    • Windows-Authenticated User Connection Pooling: Windows users can now use ODP.NET connection pooling
    • Connection Pool Performance Counters: Monitor connections and connection pool status
    • End-to-End Tracing using Action and Module attributes

    Version 11.1.0.6.0

    • Oracle Client Result Cache: Faster performance
    • Faster data retrieval with SecureFiles and LOBs
    • Improved parameter context caching for faster performance
    • Row-Based Database Change Notification

    Version 10.2.0.4.0

    • .NET Framework 3.0 and 3.5 support
    • Configuration File Support: Customize ODP.NET settings at the machine.config, web.config, or application config level

    Version 10.2.0.3.02

    • 64-bit ODP.NET for Windows x64
    • 64-bit ODP.NET for Windows Itanium
    • Local Transactions in System.Transacations
    • Configure FetchSize via Windows Registry

    Version 10.2.0.2.20

    • Multiple active ODP.NET Oracle Homes: one active home per process
    • ADO.NET 2.0 Support
    • DbCommon and Factory Classes
    • DataAdapter Batch Update
    • Schema Discovery
    • Connection String Builder
    • Server Enumeration
    • Distributed Transactions in System.Transactions

    Version 10.2.0.1.0

    • Server-side ODP.NET for .NET stored procedures
    • RAC client-side connection load balancing and automatic connection cleanup
    • Database Change Notification
    • LOB and LONG retrieval improvements
    • Faster data retrieval with no code changes needed
    • InitialLOBFetchSize can be up to 2GB
    • Full LOB and LONG functionality when initial fetch size is greater than zero
    • (i.e. GetOracleClob and GetOracleBlob methods are enabled).
    • Connection Pool Management - explicitly clear connection pool(s)
    • Metadata Caching in the connection pool
    • Client Identifier property for supporting application context security, such as with VPD
    • Input REF Cursor parameters
    • Dynamic Distributed Transaction Enlistment

    Version 10.1.0.3.0

    • Statement caching
    • DeriveParameters - automatic population of stored procedure parameters
    • Cancel long runnries
    • ADO.NET 1.1 interfaces - HasRows and EnlistDistributedTransaction properties
    • LOB and LONG retrieval - Entire LOB and LONG column data can be retrieved even if the select list does not contain a primary key, ROWID, or unique key

    Version 10.1.0.2.0

    • Grid support
    • Schema-based XMLType
    • BINARY_FLOAT and BINARY_DOUBLE datatypes
    • Multiple Oracle Homes

    Version 9.2.0.4.01

    • Improved XML DB and XMLType support
    • PL/SQL associative arrays
    • Connection validation when retrieving from the connection pool
    • InitialLOBFetchSize property to improve LOB retrieval performance

New Oracle Developer Tools for Visual Studio Features by Release

Version 12.2.0.1.0

  • Support for Visual Studio 2017
  • New Oracle Database Project Version 2 project type with "offline" Schema Compare support
  • New Dependencies and References Viewer

Version 12.1.0.2.4

  • Support for Visual Studio 2015
  • New Oracle Database Project Version 2 project type with "offline" Schema Compare support (BETA FEATURE)
  • New Update Target and Generate Script toolbar button have been added to Schema Compare
  • An Action checkbox in the Schema Compare output window allows partial script generation or partial target update
  • A Drop objects in target that are not in source option has been added to the Schema Compare Source and Target Dialog Advanced Options
  • Schema Compare now supports materialized views.
  • Server Explorer menu items Generate Create Script and Generate Create Script to Projectnow supports materialized views, XMLType tables/views and Index Organized Tables.
  • Server Explorer reorganization of Tables, Views, Indexes and Triggers nodes

Version 12.1.0.2.0

  • Option to enable/disable schema name usage in script generation
  • Generate Create Script menu item on Data Connection Node
  • Option to limit number of objects displayed under a Server Explorer collection node (for better performance)
  • Schema Compare now supports XMLType Table and XMLType Views, Index Organized Tables, and Bitmap join indexes

Version 12.1.0.1.2

  • Support for Visual Studio 2013

Version 12.1.0.1.0

  • Multitenant container database administration features
  • Schema compare tools
  • Automatic Implicit REF CURSOR Metadata Generation (useful when mapping a REF CURSORparameter in a stored procedure to a Complex Entity type return value of an Entity Function)
  • Support for Oracle Data Provider for .NET, Managed Driver in Server Explorer (Allows code generation specific to the managed provider)
  • Connection Dialog Support for SQL*Net EZ Connect and TNSNAMES.ORA Searching
  • Script Generation to Database Project Creates Master Script with Child Scripts
  • Oracle Database 12 Release 1 (12.1) New Data Types Support
  • Support for Parameterized SQL and PL/SQL in Query Window
  • Grant PL/SQL Debugging Privileges Dialog
  • Binary XML Support

Version 11.2.0.3.20

  • Support for Visual Studio 2012

Version 11.2.0.3.0

  • Entity Designer is now supported, including a new DDL Generation Template, and new Database Generation Workflows
  • Query Window is nol fledged "code window" including features such as Intellisense and collapsible regions
  • Query Window adds support for parameterized anonymous PL/SQL blocks

Version 11.2.0.1.2

  • Support for Visual Studio 2010

Version 11.1.0.7.20

  • Oracle Performance Analyzer - Tune your application from Visual Studio
  • SQL Tuning Advisor - Tune ad-hoc queries in Query Window or tune inefficient SQL in your application that is detected by Oracle Performance Analyzer
  • Advanced Queuing (AQ) Designers - Create, modify, and administer your queues and queue tables
  • Selection and operation on multiple Server Explorer nodes - Generate SQL scripts on any Oracle schema object or group of objects. Compile any number of stored procedures or functions at once.
  • Server Explorer Collection Node Filtering - Gives you fine grained control over which Oracle schema objects are displayed
  • Server Explorer Node Paging - Improves performance when there are many database objects
  • User and Role designers and Users and Roles Server Explorer nodes
  • Grant/Revoke Privileges Wizard support for System Privileges and Roles
  • PL/SQL Compiler Settings Options page
  • Table designer enhancements
  • Rename schema objects in Server Explorer
  • Oracle Trigger Designer enhancements

Version 11.1.0.6.20

  • Integration with Server Explorer in Visual Studio 2005 and 2008
  • Integration with Visual Studio 2005/2008 designers and wizards (e.g. Query Designer)
  • Support for Visual Studio 2005/2008 "Data Sources" Window and automatic code generation for Windows and ASP.NET applications
  • Oracle Database Project with Source Control Integration: Create SQL*Plus scripts automatically, store them in a project and check them into source control
  • SQL*Plus Script Editor
  • SQL*Plus Script Execution: Run any SQL*Plus script
  • Support for User-Defined Types (UDTs): All user-defined types defined in the database can be viewed in the Server Explorer and Oracle Explorer tree controls. Designers have been added for Objects, VARRAYs, and Nested Table Types. .NET code can be automatically generated for User Defined Types.
  • Query Window enhancements: EXPLAIN PLAN, auto-commit toggle, and shortcut keys
  • Data Window Enhancements: New options page that allows the user to restrict the number of rows fetched and displayed.
  • Granting and Revoking Privileges Dialog
  • PL/SQL debugger: Autos window support added
  • Import Table Wizard: This wizard makes it easy to move tables and their data from external data sources such as Microsoft SQL Server, Microsoft Access, and Excel spreadsheets.

New Oracle Providers for ASP.NET Features by Release

Version 23.4

  • Increased database password length

Version 12.1.0.2 in ODAC 12c Release 4

  • NuGet install
  • Windows installer
  • ODP.NET, Managed Driver Support in Oracle Providers for ASP.NET 4 and higher: Allows the ASP.NET provider stack to be platform independent

Version 11.2.0.2.1

  • 64-bit Instant Client for Windows x64: Smaller provider and xcopy installation
  • 64-bit ASP.NET 4 support

Version 11.2.0.1.2

  • 32-bit ASP.NET 4 support

Version 11.1.0.6.20

  • Membership Provider: Stores and retrieves registered user information in the Oracle database
  • Role Provider: Stores and retrieves user role information in the Oracle database
  • Site Map Provider: Stores and retrieves site map information in the Oracle database
  • Session State Provider: Stores and retrieves session state information in the Oracle database
  • Profile Provider: Stores and retrieves user profile information in the Oracle database
  • Web Event Provider: Stores and retrieves ASP.NET health monitoring event information in the Oracle database
  • Web Parts Personalization Provider: Stores and retrieves personalization data in the Oracle database
  • Cache Dependency Provider: Automatically invalidates ASP.NET cached data based on changes made to the base data in the Oracle database