Devart.Data.Oracle 10.4.190
dotConnect for Oracle
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 1.0+, .NET 5+.
Direct Connection to Oracle
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 dotConnect for Oracle.
Compatibility
The following table show which version of this package to use with which version of frameworks.
| Frameworks | Version support |
|---|---|
| .NET | 9, 8, 7, 6, 5 |
| .NET Core | 3, 2, 1 |
| .NET Framework | 4.8, 4.7, 4.6 |
More information here
Installation
For projects, using general ADO.NET functionality of dotConnect for Oracle, you need to install this package. Execute the following command in the Package Manager Console:
Install-Package Devart.Data.Oracle
For projects, using Entity Framework Core 1, 3, 5, 6, 7, 8, 9 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.
License
dotConnect for Oracle is available in several editions. See pricing options for ordering.
To activate your license, please download dotConnect for Oracle from our website. This installer generates the trial key files required for using this package on a trial basis.
Usage
In this example, a new instance of the OracleConnection class (part of the Devart.Data.Oracle namespace) is created.
using Devart.Data.Oracle;
...
OracleConnectionStringBuilder oraCSB = new OracleConnectionStringBuilder();
oraCSB.Direct = true;
oraCSB.Server = "127.0.0.1";
oraCSB.Port = 1521;
oraCSB.ServiceName = "orcl";
oraCSB.UserId = "demo";
oraCSB.Password = "test";
OracleConnection myConnection = new OracleConnection(oraCSB.ConnectionString);
myConnection.Open();
This snippet simplifies the connection setup by directly assigning a connection string to the ConnectionString property of the OracleConnection object
connection.ConnectionString = "UserId=demo;Password=test;Server=127.0.0.1;";
ASP.NET Core and Blazor
Configuration File Snippet (appsettings.json):
{
"ConnectionStrings": {
"DefaultConnection": "UserId=demo;Password=test;Server=127.0.0.1;Port=1521;"
}
}
Dependency Injection of IConfiguration:
private readonly IConfiguration configuration;
public YourController(IConfiguration config)
{
configuration = config;
}
Retrieving a Connection String:
var connectionString = configuration.GetConnectionString("DefaultConnection");
var connection = new OracleConnection(connectionString);
For more information about secure connections using SSL or SSH connections and other connections types read at our documentation.
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.
Related Packages
Support Area
More Resources
Explore additional resources about dotConnect for Oracle:
Showing the top 20 packages that depend on Devart.Data.Oracle.
| Packages | Downloads |
|---|---|
|
Devart.Data.Oracle.EFCore
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 EF Core, 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 Entity Framework Core-related functionality of dotConnect for Oracle. It includes support for Entity Framework Core 1.1 - 3.0. Note that for Entity Framework Core 1.1 it does not include support for database-first approach via the Scaffold-DbContext command, which is available via the separate Devart.Data.Oracle.EFCore.Design package.
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. Besides, this installer generates the trial key files required for using this package on a trial basis. You can download it at www.devart.com.
|
10 |
.NET Standard 1.3
- Microsoft.NETCore.Portable.Compatibility (>= 1.0.1)
- System.Xml.XmlDocument (>= 4.3.0)
- Devart.Data (>= 6.0.190)
- System.Security.Cryptography.Csp (>= 4.3.0)
- Microsoft.Win32.Registry (>= 4.3.0)
- NETStandard.Library (>= 1.6.1)
- System.ComponentModel (>= 4.3.0)
- System.ComponentModel.Annotations (>= 4.3.0)
- System.ComponentModel.Primitives (>= 4.3.0)
- System.Text.Encoding.CodePages (>= 4.4.0)
- System.ComponentModel.TypeConverter (>= 4.3.0)
- System.Net.NameResolution (>= 4.3.0)
- System.Reflection (>= 4.3.0)
- System.Reflection.Emit (>= 4.3.0)
- System.Reflection.Emit.ILGeneration (>= 4.3.0)
- System.Security.Cryptography.Algorithms (>= 4.3.0)
- System.Diagnostics.FileVersionInfo (>= 4.3.0)
.NET Standard 2.1
- Devart.Data (>= 6.0.190)
- System.Text.Encoding.CodePages (>= 4.5.0)
- System.Reflection.Emit.ILGeneration (>= 4.3.0)
- System.Reflection.Emit (>= 4.3.0)
- System.Diagnostics.PerformanceCounter (>= 4.5.0)
- Microsoft.Win32.Registry (>= 4.5.0)
.NET Standard 2.0
- Devart.Data (>= 6.0.190)
- System.Text.Encoding.CodePages (>= 4.5.0)
- System.Reflection.Emit.ILGeneration (>= 4.3.0)
- System.Reflection.Emit (>= 4.3.0)
- System.Diagnostics.PerformanceCounter (>= 4.5.0)
- Microsoft.Win32.Registry (>= 4.5.0)
| Version | Downloads | Last updated |
|---|---|---|
| 11.1.35 | 0 | 2026/3/6 |
| 11.1.33 | 0 | 2026/2/24 |
| 11.0.0 | 0 | 2025/12/19 |
| 10.4.290 | 0 | 2025/7/30 |
| 10.4.235 | 0 | 2025/4/25 |
| 10.4.193 | 0 | 2025/2/11 |
| 10.4.191 | 1 | 2026/4/9 |
| 10.4.190 | 1 | 2026/4/9 |
| 10.3.104 | 1 | 2026/4/9 |
| 10.3.21 | 0 | 2024/6/6 |
| 10.3.20 | 0 | 2024/5/30 |
| 10.3.10 | 0 | 2024/1/18 |
| 10.2.0 | 0 | 2023/11/17 |
| 10.1.151 | 0 | 2023/6/7 |
| 10.1.134 | 1 | 2026/4/9 |
| 10.0.0 | 0 | 2022/7/1 |
| 9.16.1434 | 0 | 2022/1/26 |
| 9.15.1410 | 0 | 2021/12/21 |
| 9.14.1382 | 0 | 2021/11/9 |
| 9.14.1369 | 0 | 2021/10/21 |
| 9.14.1353 | 0 | 2021/9/28 |
| 9.14.1312 | 0 | 2021/7/30 |
| 9.14.1298 | 0 | 2021/7/8 |
| 9.14.1273 | 0 | 2021/6/3 |
| 9.14.1234 | 0 | 2021/4/9 |
| 9.14.1228 | 0 | 2021/4/1 |
| 9.14.1204 | 0 | 2021/2/18 |
| 9.14.1180 | 0 | 2021/1/14 |
| 9.14.1160 | 0 | 2020/12/17 |
| 9.14.1150 | 0 | 2020/12/3 |
| 9.13.1127 | 0 | 2020/10/29 |
| 9.13.1107 | 0 | 2020/10/1 |
| 9.13.1098 | 0 | 2020/9/17 |
| 9.12.1064 | 0 | 2020/7/30 |
| 9.12.1054 | 0 | 2020/7/16 |
| 9.11.1034 | 0 | 2020/6/17 |
| 9.11.980 | 8 | 2025/3/3 |
| 9.11.951 | 0 | 2020/2/20 |
| 9.10.909 | 0 | 2019/12/23 |
| 9.9.887 | 0 | 2019/11/21 |
| 9.9.872 | 0 | 2019/10/31 |
| 9.9.867 | 0 | 2019/10/24 |
| 9.8.838 | 0 | 2019/9/13 |
| 9.7.805 | 0 | 2019/7/25 |
| 9.7.790 | 0 | 2019/7/4 |
| 9.7.770 | 0 | 2019/6/6 |
| 9.7.734 | 0 | 2019/4/12 |
| 9.6.725 | 0 | 2019/3/28 |
| 9.6.696 | 0 | 2019/2/14 |
| 9.6.675 | 0 | 2019/1/10 |
| 9.6.646 | 0 | 2018/11/29 |
| 9.6.621 | 0 | 2018/10/25 |
| 9.6.597 | 0 | 2018/9/20 |
| 9.6.584 | 0 | 2018/8/31 |
| 9.6.570 | 0 | 2018/8/10 |
| 9.6.558 | 0 | 2018/7/19 |
| 9.6.540 | 0 | 2018/6/22 |
| 9.5.520 | 0 | 2018/5/25 |
| 9.5.502 | 0 | 2018/4/27 |
| 9.5.483 | 0 | 2018/3/30 |
| 9.5.454 | 0 | 2018/2/15 |
| 9.5.429 | 0 | 2018/1/11 |
| 9.5.399 | 0 | 2017/11/23 |
| 9.5.381 | 0 | 2017/10/30 |
| 9.4.348 | 0 | 2017/9/7 |
| 9.4.326 | 0 | 2017/8/4 |
| 9.4.314 | 0 | 2017/7/14 |
| 9.4.299 | 0 | 2017/6/23 |
| 9.4.280 | 0 | 2017/5/25 |