Devart.Data.Oracle.EFCore 10.4.190

Prefix Reserved
.NET 6.0 This package targets .NET 6.0. The package is compatible with this framework or higher. .NET Standard 1.3 This package targets .NET Standard 1.3. The package is compatible with this framework or higher.
There is a newer version of this package available.
See the version list below for details. 
dotnet add package Devart.Data.Oracle.EFCore --version 10.4.190                

                    
                

            
NuGet\Install-Package Devart.Data.Oracle.EFCore -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.EFCore" 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.EFCore --version 10.4.190                

                    
                

            
#r "nuget: Devart.Data.Oracle.EFCore, 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.EFCore as a Cake Addin
#addin nuget:?package=Devart.Data.Oracle.EFCore&version=10.4.190

// Install Devart.Data.Oracle.EFCore as a Cake Tool
#tool nuget:?package=Devart.Data.Oracle.EFCore&version=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+. The product is compatible with ADO.NET Entity Framework (EF) Core.

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.

Visual ORM Designer

ORM Support

It also includes visual ORM designer for Entity Framework, Entity Framework Core, and LinqConnect ORM models.

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
Entity Framework Core 6, 5, 3, 1
.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 Entity Framework Core 1, 3, 5, 6 with Oracle, install this package. Execute the following command in the Package Manager Console:

Install-Package Devart.Data.Oracle.EFCore

For projects, using Entity Framework Core 1.1, for which you use database-first approach and generate an Entity Framework Core mapping via the Scaffold-DbContext command of Package Manager Console, you need to install the Devart.Data.Oracle.EFCore.Design package.

For projects that require integration with Entity Framework 6.4 (EF6), use the Devart.Data.Oracle.EF6 package.

There also are Visual Studio extensions for earlier Visual Studio versions. If you use some other tool than Visual Studio, you can get NuGet packages with the nuget.exe console tool.

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

This snippet directly configures a Oracle database connection for an Entity Framework Core DbContext using a connection string.

public class MyDbContext : DbContext {
 
  protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder) {

     optionsBuilder.UseOracle(@"UserId=demo;Password=test;ServiceName=orcl;Server=127.0.0.1;Port=1521;");
  } 
}

Configuration Using OracleConnection Instance

using Devart.Data.Oracle;
...

public class MyDbContext : DbContext {
 
  protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder) {

     var connection = new OracleConnection();
     connection.Direct = true;
     connection.Host = "127.0.0.1";
     connection.ServiceName = "orcl";
     connection.Port = 1521;
     connection.UserId = "demo";
     connection.Password = "test";
     optionsBuilder.UseOracle(connection);
  } 
}

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 is compatible.  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.

NuGet packages (27)

Showing the top 5 NuGet packages that depend on Devart.Data.Oracle.EFCore:

Package Downloads
Devart.Data.Oracle.EFCore.Design

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.
Volo.Abp.EntityFrameworkCore.Oracle.Devart

Package Description
Aguacongas.TheIdServer.Migrations.Oracle

Contains db contexts migrations code for Oracle.
Eltra.EntityFramework

Library for Eltra .Net
Devart.Data.Oracle.EFCore.NetTopologySuite

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.

GitHub repositories (3)

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

Repository Stars
abpframework/abp
Open-source web application framework for ASP.NET Core! Offers an opinionated architecture to build enterprise software solutions with best practices on top of the .NET. Provides the fundamental infrastructure, cross-cutting-concern implementations, startup templates, application modules, UI themes, tooling and documentation.
besley/Slickflow
.NET Open Source Workflow Engine, .NET 开源工作流
Aguafrommars/TheIdServer
OpenID/Connect, OAuth2, WS-Federation and SAML 2.0 server based on Duende IdentityServer and ITFoxtec Identity SAML 2.0 with its admin UI
Version Downloads Last updated
10.4.190.9 400 12/27/2024
10.4.190.8 100 12/27/2024
10.4.190.7 97 12/27/2024
10.4.190 153 12/27/2024
10.3.105.8 3,953 11/13/2024
10.3.105.7 212 11/13/2024
10.3.105 301 11/13/2024
10.3.104.8 1,831 11/8/2024
10.3.104.7 177 11/8/2024
10.3.104 869 11/8/2024
10.3.21.8 23,953 6/6/2024
10.3.21.7 252 6/6/2024
10.3.21 610 6/6/2024
10.3.20.8 10,177 5/30/2024
10.3.20.7 155 5/30/2024
10.3.20 260 5/30/2024
10.3.10.8 40,937 1/18/2024
10.3.10.7 1,457 1/18/2024
10.3.10 3,403 1/18/2024
10.2.0.7 88,341 11/17/2023
10.2.0 1,334 11/17/2023
10.1.151.7 67,438 6/7/2023
10.1.151 2,854 6/7/2023
10.1.134.7 22,364 3/4/2023
10.1.134 7,912 3/4/2023
10.0.0 255,229 7/1/2022
9.16.1434 222,530 1/26/2022
9.15.1410 27,797 12/21/2021
9.14.1382 48,870 11/9/2021
9.14.1369 12,175 10/21/2021
9.14.1353 7,345 9/28/2021
9.14.1312 15,798 7/30/2021
9.14.1298 3,817 7/8/2021
9.14.1273 19,289 6/3/2021
9.14.1234 33,609 4/9/2021
9.14.1228 7,021 4/1/2021
9.14.1204 22,634 2/18/2021
9.14.1180 11,216 1/14/2021
9.14.1160 8,002 12/17/2020
9.14.1150 19,850 12/3/2020
9.13.1127 343,429 10/29/2020
9.13.1107 14,983 10/1/2020
9.13.1098 6,224 9/17/2020
9.12.1064 140,189 7/30/2020
9.12.1054 3,645 7/16/2020
9.11.1034 34,245 6/17/2020
9.11.980 251,207 4/2/2020
9.11.951 32,242 2/20/2020
9.10.909 35,658 12/23/2019
9.9.887 14,329 11/21/2019
9.9.872 7,515 10/31/2019
9.9.867 73,906 10/24/2019
9.8.838 27,793 9/13/2019
9.7.805 47,810 7/25/2019
9.7.790 8,932 7/4/2019
9.7.770 35,237 6/6/2019
9.7.734 196,003 4/12/2019
9.6.725 20,104 3/28/2019
9.6.696 90,127 2/14/2019
9.6.675 38,166 1/10/2019
9.6.646 22,973 11/29/2018
9.6.621 13,804 10/25/2018
9.6.597 50,051 9/20/2018
9.6.584 7,714 8/31/2018
9.6.570 9,362 8/10/2018
9.6.558 5,769 7/19/2018
9.6.540 7,451 6/22/2018
9.5.520 12,114 5/25/2018
9.5.502 10,825 4/27/2018
9.5.483 3,992 3/30/2018
9.5.454 7,542 2/15/2018
9.5.429 6,375 1/11/2018
9.5.399 8,738 11/23/2017
9.5.381 2,868 10/30/2017
9.4.348 4,108 9/7/2017
9.4.326 3,214 8/4/2017
9.4.314 2,789 7/14/2017
9.4.299 2,607 6/23/2017
9.4.280 3,641 5/25/2017

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