Devart.Data.Oracle 10.4.190

Prefix Reserved

dotnet add package Devart.Data.Oracle --version 10.4.190

NuGet\Install-Package Devart.Data.Oracle -Version 10.4.190

This command is intended to be used within the Package Manager Console in Visual Studio, as it uses the NuGet module's version of Install-Package.

<PackageReference Include="Devart.Data.Oracle" Version="10.4.190" />

For projects that support PackageReference, copy this XML node into the project file to reference the package.

paket add Devart.Data.Oracle --version 10.4.190

The NuGet Team does not provide support for this client. Please contact its maintainers for support.

#r "nuget: Devart.Data.Oracle, 10.4.190"

#r directive can be used in F# Interactive and Polyglot Notebooks. Copy this into the interactive tool or source code of the script to reference the package.

// Install Devart.Data.Oracle as a Cake Addin
#addin nuget:?package=Devart.Data.Oracle&version=10.4.190

// Install Devart.Data.Oracle as a Cake Tool
#tool nuget:?package=Devart.Data.Oracle&version=10.4.190

The NuGet Team does not provide support for this client. Please contact its maintainers for support.

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

Direct Connection

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.

Support Area

More Resources

Explore additional resources about dotConnect for Oracle:

Product	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.
.NET Core	netcoreapp1.0 was computed. netcoreapp1.1 was computed. netcoreapp2.0 was computed. netcoreapp2.1 was computed. netcoreapp2.2 was computed. netcoreapp3.0 was computed. netcoreapp3.1 was computed.
.NET Standard	netstandard1.3 is compatible. netstandard1.4 was computed. netstandard1.5 was computed. netstandard1.6 was computed. netstandard2.0 is compatible. netstandard2.1 is compatible.
.NET Framework	net46 was computed. 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	tizen30 was computed. tizen40 was computed. tizen60 was computed.
Universal Windows Platform	uap was computed. uap10.0 was computed.
Xamarin.iOS	xamarinios was computed.
Xamarin.Mac	xamarinmac was computed.
Xamarin.TVOS	xamarintvos was computed.
Xamarin.WatchOS	xamarinwatchos was computed.

Compatible target framework(s)

Included target framework(s) (in package)

Learn more about Target Frameworks and .NET Standard.

.NETStandard 1.3
- Devart.Data (>= 6.0.190)
- Microsoft.NETCore.Portable.Compatibility (>= 1.0.1)
- 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.ComponentModel.TypeConverter (>= 4.3.0)
- System.Diagnostics.FileVersionInfo (>= 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.Security.Cryptography.Csp (>= 4.3.0)
- System.Text.Encoding.CodePages (>= 4.4.0)
- System.Xml.XmlDocument (>= 4.3.0)
.NETStandard 2.0
- Devart.Data (>= 6.0.190)
- Microsoft.Win32.Registry (>= 4.5.0)
- System.Diagnostics.PerformanceCounter (>= 4.5.0)
- System.Reflection.Emit (>= 4.3.0)
- System.Reflection.Emit.ILGeneration (>= 4.3.0)
- System.Text.Encoding.CodePages (>= 4.5.0)
.NETStandard 2.1
- Devart.Data (>= 6.0.190)
- Microsoft.Win32.Registry (>= 4.5.0)
- System.Diagnostics.PerformanceCounter (>= 4.5.0)
- System.Reflection.Emit (>= 4.3.0)
- System.Reflection.Emit.ILGeneration (>= 4.3.0)
- System.Text.Encoding.CodePages (>= 4.5.0)

NuGet packages (13)

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 1.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. 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.	2.6M
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. 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.	85.5K
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 1.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. 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.	73.7K
Rebus.Oracle.Devart Rebus.Oracle.Devart	39.7K
NewenNetworks.Database.Oracle NewenNetworks Standard SDK	17.0K

GitHub repositories (1)

Showing the top 1 popular GitHub repositories that depend on Devart.Data.Oracle:

Repository	Stars
linq2db/linq2db Linq to database provider.	3.0K

Version	Downloads	Last updated
10.4.190	98	12/27/2024
10.3.104	15,030	11/8/2024
10.3.21	52,496	6/6/2024
10.3.20	17,561	5/30/2024
10.3.10	89,979	1/18/2024
10.2.0	120,112	11/17/2023
10.1.151	123,672	6/7/2023
10.1.134	68,089	3/4/2023
10.0.0	330,346	7/1/2022
9.16.1434	310,598	1/26/2022
9.15.1410	41,140	12/21/2021
9.14.1382	93,182	11/9/2021
9.14.1369	49,378	10/21/2021
9.14.1353	17,809	9/28/2021
9.14.1312	67,532	7/30/2021
9.14.1298	15,884	7/8/2021
9.14.1273	35,588	6/3/2021
9.14.1234	82,513	4/9/2021
9.14.1228	10,829	4/1/2021
9.14.1204	39,491	2/18/2021
9.14.1180	29,960	1/14/2021
9.14.1160	52,141	12/17/2020
9.14.1150	43,090	12/3/2020
9.13.1127	364,284	10/29/2020
9.13.1107	21,412	10/1/2020
9.13.1098	20,714	9/17/2020
9.12.1064	151,419	7/30/2020
9.12.1054	6,311	7/16/2020
9.11.1034	50,659	6/17/2020
9.11.980	400,825	4/2/2020
9.11.951	51,841	2/20/2020
9.10.909	66,029	12/23/2019
9.9.887	22,597	11/21/2019
9.9.872	22,617	10/31/2019
9.9.867	77,567	10/24/2019
9.8.838	51,865	9/13/2019
9.7.805	58,467	7/25/2019
9.7.790	48,811	7/4/2019
9.7.770	43,197	6/6/2019
9.7.734	203,718	4/12/2019
9.6.725	23,600	3/28/2019
9.6.696	112,720	2/14/2019
9.6.675	42,425	1/10/2019
9.6.646	26,174	11/29/2018
9.6.621	36,987	10/25/2018
9.6.597	60,823	9/20/2018
9.6.584	12,523	8/31/2018
9.6.570	12,142	8/10/2018
9.6.558	15,299	7/19/2018
9.6.540	16,267	6/22/2018
9.5.520	21,733	5/25/2018
9.5.502	13,255	4/27/2018
9.5.483	6,523	3/30/2018
9.5.454	146,846	2/15/2018
9.5.429	11,947	1/11/2018
9.5.399	12,185	11/23/2017
9.5.381	6,848	10/30/2017
9.4.348	9,271	9/7/2017
9.4.326	6,862	8/4/2017
9.4.314	7,607	7/14/2017
9.4.299	4,163	6/23/2017
9.4.280	9,471	5/25/2017

https://www.devart.com/dotconnect/oracle/revision_history.html