Oracle Autonomous Database supports connectivity to the Microsoft .NET Framework, .NET Core, Visual Studio, and Visual Studio Code.
Oracle Data Provider for .NET (ODP.NET) provides run-time ADO.NET data access to a database.
ODP.NET has the following driver types:
Unmanaged ODP.NET for .NET Framework applications
Managed ODP.NET for .NET Framework applications
ODP.NET Core for .NET Core applications
The following minimum versions are required:
ODP.NET: 12.1 (Starting with April 2022 WINDBBP; ODP.NET Managed only), 18 (base release or later), 19.4 (or later, except for 19.10), or 21 (base release or later).
Oracle Developer Tools for Visual Studio and Oracle Developer Tools for VS Code provide database application design-time support in the Microsoft development environment, including tools for managing Autonomous Databases in the Oracle Cloud.
Oracle Developer Tools for VS Code provides database application design-time support in Visual Studio Code.
These software components are available as a free download from the following sites:
- Managed ODP.NET and ODP.NET Core: NuGet Gallery
- Unmanaged ODP.NET: Oracle Data Access Components Downloads
- Oracle Developer Tools for Visual Studio Code: VS Code Marketplace
- Oracle Developer Tools for Visual Studio: Oracle Developer Tools for Visual Studio
Oracle recommends using the latest provider and tools version with Oracle Autonomous Database.
Click the following link for instructions to download, install, and configure these components for use with mutual TLS (mTLS) and wallets:
To use mutual TLS (mTLS) authentication to connect to Autonomous Database, you must download a wallet. See Download Client Credentials (Wallets) for information downloading wallets.
ODP.NET connectivity to Oracle Autonomous Database supports mutual TLS (mTLS) with wallets as well as TLS. See Connect Microsoft .NET, Visual Studio Code, and Visual Studio Without a Wallet for information on using TLS connections.
To learn more about using Oracle Autonomous Database and .NET, try the free .NET Development with Oracle Autonomous Database Quick Start. This lab walks you through setting up a .NET web server on Oracle Cloud Infrastructure that connects to Oracle Autonomous Database. Next, the lab guides developing and deploying a simple ASP.NET Core web application that uses all these components. By the end, you will have a live, working website on the Internet.