Devart.Data.Oracle
11.1.100
Prefix Reserved
dotnet add package Devart.Data.Oracle --version 11.1.100
NuGet\Install-Package Devart.Data.Oracle -Version 11.1.100
<PackageReference Include="Devart.Data.Oracle" Version="11.1.100" />
<PackageVersion Include="Devart.Data.Oracle" Version="11.1.100" />
<PackageReference Include="Devart.Data.Oracle" />
paket add Devart.Data.Oracle --version 11.1.100
#r "nuget: Devart.Data.Oracle, 11.1.100"
#:package Devart.Data.Oracle@11.1.100
#addin nuget:?package=Devart.Data.Oracle&version=11.1.100
#tool nuget:?package=Devart.Data.Oracle&version=11.1.100
Advanced C# Connection Provider for Oracle
dotConnect for Oracle is a high-performance ORM enabled data provider for Oracle Database 9i/10g/11g/12c/18c/19c/21c/23ai/26ai and Oracle Cloud (DBaaS) that builds on ADO.NET technology.
The provider works with .NET Frameworks, .NET Core, .NET.
It supports a wide range of Oracle-specific features, such as Direct Mode connection without Oracle Client, secure SSL and SSH connections, Oracle RAC and Transparent Application Failover, and others. Package provides advanced Visual Studio integration and convenient visual component editors to simplify component tweaking.
More information at dotConnect for Oracle.
Installation
- Install the NuGet Package
Install-Package Devart.Data.Oracle
- Activate license
- Free Trial License: Evaluate the full capabilities of dotConnect for Oracle in a non-commercial environment—ideal for development and testing. Start your free trial
- Commercial License: Deploy dotConnect for Oracle in commercial applications and access full technical support with a valid license. Purchase a license
Work with EF Core and Entity Framework
For projects, using Entity Framework Core with Oracle, install the Devart.Data.Oracle.EFCore package.
For projects that require integration with Entity Framework 6.4 (EF6), use the Devart.Data.Oracle.EF6 package.
Compatibility
The following table show which version of this package to use with which version of frameworks.
| Frameworks | Version support |
|---|---|
| .NET | 10, 9, 8, 7, 6, 5 |
| .NET Core | 3.1, 3.0, 2.2, 2.1, 2.0 |
| .NET Framework | 4.8, 4.7, 4.6.2, 4.6.1 |
More information here
Key Features
- Direct Mode — No Oracle Client Required: Connect to Oracle databases over TCP/IP without installing Oracle Client software, simplifying deployment and reducing infrastructure overhead.
- Enterprise-Grade Security: Secure Oracle connectivity with SSL, SSH, HTTP tunneling, and multiple encryption algorithms including AES and 3DES. dotConnect for Oracle follows rigorous security standards in product development.
- High Performance Data Access: Built-in Oracle-specific optimizations including OCI Statement Caching, Database Resident Connection Pooling (DRCP), Direct Path interface with OracleLoader, and intelligent fetch block size control.
- Full ADO.NET Compatibility: 100% compliant with ADO.NET standards, supporting key interfaces such as DbConnection, DbCommand, DataSet, and DataTable for seamless integration into .NET applications.
- Comprehensive Oracle Data Type Support: Native handling of all Oracle data types including LOBs, TIMESTAMP, INTERVAL, REF CURSORs, PL/SQL tables and records, nested tables, and XMLTYPE.
- Oracle RAC and High Availability: Supports Oracle Real Application Clusters, Transparent Application Failover, Oracle Transaction Guard, and HA event notifications from Oracle RAC clusters.
- Advanced Oracle Integration: Full support for Oracle Advanced Queuing, Object Change Notification, Query Result Change Notification, Oracle Sharding, and PL/SQL packages via the Oracle Package Wizard.
- Visual Studio Integration: Accelerate development with wizards for connection setup, typed DataSet generation, and schema management—all embedded in Visual Studio.
- Broad Platform Compatibility: Fully compatible with .NET Framework, .NET Core, and .NET, supporting Windows, Linux, and macOS for cloud-native and enterprise applications.
- Priority Support and Continuous Improvement: Backed by dedicated technical support and regular updates that deliver security enhancements, feature improvements, and long-term stability.
Usage
To help you get started quickly, here's a simple code example demonstrating how to connect to an Oracle database.
using Devart.Data.Oracle;
class Program
{
static void Main()
{
string connectionString = "" +
"Server=127.0.0.1;" +
"Port=1521;" +
"User Id=TestUser;" +
"Password=TestPassword;" +
"Service Name=orcl;" +
"Direct=True;" +
"License Key=**********";
using (OracleConnection connection = new OracleConnection(connectionString))
{
try
{
connection.Open();
Console.WriteLine("Connection successful!");
}
catch (Exception ex)
{
Console.WriteLine($"Error: {ex.Message}");
}
}
}
}
Basic Connection Strings
| Property | Meaning |
|---|---|
| Server | Specifies the hostname or IP address of the Oracle server. |
| Port | Specifies the port number on which the Oracle server is listening. |
| User Id | Specifies the Oracle database username. |
| Password | Specifies the password for the user ID. |
| Service Name | Specifies the Oracle service name for the database instance. |
| Direct | Set to True to use Direct Mode without Oracle Client software. |
| License Key | Specify your license key in this parameter. |
For more detailed tutorials, API reference, and advanced examples, visit our Getting Started guide.
Related Packages
Support Area
| Product | Versions Compatible and additional computed target framework versions. |
|---|---|
| .NET | net5.0 was computed. net5.0-windows was computed. net6.0 was computed. net6.0-android was computed. net6.0-ios was computed. net6.0-maccatalyst was computed. net6.0-macos was computed. net6.0-tvos was computed. net6.0-windows was computed. net7.0 was computed. net7.0-android was computed. net7.0-ios was computed. net7.0-maccatalyst was computed. net7.0-macos was computed. net7.0-tvos was computed. net7.0-windows was computed. net8.0 was computed. net8.0-android was computed. net8.0-browser was computed. net8.0-ios was computed. net8.0-maccatalyst was computed. net8.0-macos was computed. net8.0-tvos was computed. net8.0-windows was computed. net9.0 was computed. net9.0-android was computed. net9.0-browser was computed. net9.0-ios was computed. net9.0-maccatalyst was computed. net9.0-macos was computed. net9.0-tvos was computed. net9.0-windows was computed. net10.0 was computed. net10.0-android was computed. net10.0-browser was computed. net10.0-ios was computed. net10.0-maccatalyst was computed. net10.0-macos was computed. net10.0-tvos was computed. net10.0-windows was computed. |
| .NET Core | netcoreapp2.0 was computed. netcoreapp2.1 was computed. netcoreapp2.2 was computed. netcoreapp3.0 was computed. netcoreapp3.1 was computed. |
| .NET Standard | netstandard2.0 is compatible. netstandard2.1 is compatible. |
| .NET Framework | net461 was computed. net462 was computed. net463 was computed. net47 was computed. net471 was computed. net472 was computed. net48 was computed. net481 was computed. |
| MonoAndroid | monoandroid was computed. |
| MonoMac | monomac was computed. |
| MonoTouch | monotouch was computed. |
| Tizen | tizen40 was computed. tizen60 was computed. |
| Xamarin.iOS | xamarinios was computed. |
| Xamarin.Mac | xamarinmac was computed. |
| Xamarin.TVOS | xamarintvos was computed. |
| Xamarin.WatchOS | xamarinwatchos was computed. |
-
.NETStandard 2.0
- Devart.Data (>= 7.0.100)
- Microsoft.Win32.Registry (>= 4.5.0)
- System.Diagnostics.PerformanceCounter (>= 10.0.5)
- System.Reflection.Emit (>= 4.3.0)
- System.Reflection.Emit.ILGeneration (>= 4.3.0)
- System.Text.Encoding.CodePages (>= 10.0.0)
-
.NETStandard 2.1
- Devart.Data (>= 7.0.100)
- Microsoft.Win32.Registry (>= 4.5.0)
- System.Diagnostics.PerformanceCounter (>= 10.0.5)
- System.Reflection.Emit (>= 4.3.0)
- System.Reflection.Emit.ILGeneration (>= 4.3.0)
- System.Text.Encoding.CodePages (>= 10.0.0)
NuGet packages (14)
Showing the top 5 NuGet packages that depend on Devart.Data.Oracle:
| Package | Downloads |
|---|---|
|
Devart.Data.Oracle.EFCore
dotConnect for Oracle is a high-performance ORM enabled data provider for Oracle and Oracle Cloud (DBaaS) that builds on ADO.NET technology. The provider works with .NET Frameworks 2.0+, .NET Core 2.0+, .NET 5+. It supports a wide range of Oracle-specific features, including different connection modes/protocols, data types, and optimized components for bulk data operations and database script handling. In Direct mode does not require Oracle Client Software and works directly through TCP/IP. Package provides advanced Visual Studio integration and convenient visual component editors to simplify component tweaking. More information at https://www.devart.com/dotconnect/oracle/ Key Features * Direct Mode: Allows your application to work with Oracle directly, without involving Oracle client library. * ASP.NET Core: Supports ASP.NET Core Identity. * Performance: Uses many Oracle-specific performance features & optimizations to ensure the highest performance. * Monitoring: Allows per-component tracing of database events with a free dbMonitor application. * Security: Supports various encryption ciphers, SSL and SSH connections, etc. * Support and updates: Enjoy dedicated support team for prompt issue resolution and regular updates to keep your software running smoothly and securely. License dotConnect for Oracle is available in several editions. The NuGet package initiates the retrieval of an activation key from the Devart website. This key is required to activate the product for a free trial. |
|
|
Devart.Data.Oracle.Linq
dotConnect for Oracle is an enhanced database connectivity solution built over ADO.NET architecture and a development framework with advanced support for ORMs, such as Entity Framework and LinqConnect and offers a complete solution for developing DB-related applications and web sites. It introduces new approaches for designing a data access layer and boosts the productivity of database application development. This package contains the .NET Standard/.NET Core compatible assemblies with LinqConnect-related functionality of dotConnect for Oracle. LinqConnect (LINQ to Oracle) is a fast ORM solution, having a LINQ to SQL-compatible interface, but also providing its own advanced features. This package contains only runtime features of dotConnect for Oracle. dotConnect for Oracle is also provided as an installation package (exe), which installs runtime assemblies for Full .NET Framework and a set of design-time tools, integrated into Visual Studio - Server Explorer integration, DataSet tools, Windows Forms components with powerful design-time, etc. It also includes visual ORM designer for Entity Framework, Entity Framework Core, and LinqConnect ORM models. You can download it at www.devart.com. The NuGet package initiates the retrieval of an activation key from the Devart website. This key is required to activate the product for a free trial. |
|
|
Devart.Data.Oracle.EF6
dotConnect for Oracle is a high-performance ORM enabled data provider for Oracle and Oracle Cloud (DBaaS) that builds on ADO.NET technology. The provider works with .NET Frameworks 2.0+, .NET Core 2.0+, .NET 5+. It supports a wide range of Oracle-specific features, including different connection modes/protocols, data types, and optimized components for bulk data operations and database script handling. In Direct mode does not require Oracle Client Software and works directly through TCP/IP. Package provides advanced Visual Studio integration and convenient visual component editors to simplify component tweaking. More information at https://www.devart.com/dotconnect/oracle/ Key Features * Direct Mode: Allows your application to work with Oracle directly, without involving Oracle client library. * ASP.NET Core: Supports ASP.NET Core Identity. * Performance: Uses many Oracle-specific performance features & optimizations to ensure the highest performance. * Monitoring: Allows per-component tracing of database events with a free dbMonitor application. * Security: Supports various encryption ciphers, SSL and SSH connections, etc. * Support and updates: Enjoy dedicated support team for prompt issue resolution and regular updates to keep your software running smoothly and securely. License dotConnect for Oracle is available in several editions. The NuGet package initiates the retrieval of an activation key from the Devart website. This key is required to activate the product for a free trial. |
|
|
Rebus.Oracle.Devart
Rebus.Oracle.Devart |
|
|
NewenNetworks.Database.Oracle
NewenNetworks Standard SDK |
GitHub repositories (1)
Showing the top 1 popular GitHub repositories that depend on Devart.Data.Oracle:
| Repository | Stars |
|---|---|
|
linq2db/linq2db
Linq to database provider.
|
| Version | Downloads | Last Updated |
|---|---|---|
| 11.1.100 | 0 | 5/25/2026 |
| 11.1.72 | 16,025 | 4/23/2026 |
| 11.1.35 | 20,937 | 3/6/2026 |
| 11.1.33 | 7,477 | 2/24/2026 |
| 11.0.0 | 38,377 | 12/19/2025 |
| 10.4.290 | 82,600 | 7/30/2025 |
| 10.4.235 | 112,350 | 4/25/2025 |
| 10.4.193 | 67,497 | 2/11/2025 |
| 10.4.191 | 13,414 | 1/15/2025 |
| 10.4.190 | 16,218 | 12/27/2024 |
| 10.3.104 | 139,243 | 11/8/2024 |
| 10.3.21 | 161,390 | 6/6/2024 |
| 10.3.20 | 38,068 | 5/30/2024 |
| 10.3.10 | 194,207 | 1/18/2024 |
| 10.2.0 | 222,204 | 11/17/2023 |
| 10.1.151 | 166,377 | 6/7/2023 |
| 10.1.134 | 83,199 | 3/4/2023 |
| 10.0.0 | 439,427 | 7/1/2022 |
| 9.16.1434 | 396,551 | 1/26/2022 |
| 9.15.1410 | 48,092 | 12/21/2021 |