Devart dotConnect for Oracle v9.10.909 Professional
Devart dotConnect for Oracle v9.10.909 Professional
dotConnect for Oracle is a high-performance ORM enabled data provider for Oracle that builds on ADO.NET technology to present a complete solution for developing Oracle-based database applications. It introduces new approaches for designing application architecture, boosts productivity, and facilitates the development of database applications.
Our ADO.NET Oracle provider supports a wide range of Oracle-specific features, such as Advanced Queuing , Alerts, Pipes, Direct Path Loading , Change notifications, Transparent Application Failover, REF cursors, objects, packages, and others.
Advanced Visual Studio Integration
dotConnect for Oracle provides a vast number of GUI tools that increase your productivity. For example, it includes DataSet tools, such as DataSet Wizard, DataSet Editor, DataSet Manager, provide you an easy way to create and edit typed and untyped DataSets.
Oracle ADO.NET Provider supports advanced Visual Studio integration (DDEX), and provides convenient visual component editors to simplify component tweaking.
Broad Compatibility
dotConnect for Oracle was the first Oracle database provider to support .NET Core and Entity Framework Core, and we work hard to support new platforms and development technologies as soon as they are released.
Oracle support: from 7.3 to 19с, Oracle TimesTen
Visual Studio support: 2008 – 2019
Platforms support:
Full .NET Framework 2.0 – 4.8
.NET Core 1.x, 2.x, and 3.0
.NET Compact Framework 2.0 and above
Mono 2.0 and above
Enhanced ORM Support
dotConnect for Oracle offers enhanced ORM support with a bundled visual designer for ORM models - Entity Developer. Our Oracle ADO.NET Provider supports the following ORMs:
Entity Framework v1 - v6
Entity Framework Core 1.x, 2.x, and 3.1
NHibernate
LinqConnect
Features
Direct Mode
Allows your application to work with Oracle directly via TCP/IP without involving Oracle Client.
ASP.NET
Implements Role, Session State, Membership, Profile, Site Map, and other ASP 2.0 providers.
Performance
Uses many Oracle-specific performance features & optimizations to ensure the highest performance.
BIS
Enables Integration Services to export and import data to/from Oracle servers.
Monitoring
Allows per-component tracing of database events with a free dbMonitor application.
Security
Supports various encryption algorithms, OS authentication, Proxy authentication, Oracle Data Integrity, etc.
9.10.909 23-Dec-19
Visual Studio 2019 version 16.5 Preview is supported
The bug with using the OracleDbType.VarChar parameter with length greater than 1333 symbols on Oracle 12.1 with NLS_CHARACTERSET=AL32UTF8 in the Direct mode is fixed
The bug with using Toolbox component OracleDataSource in web projects of Visual Studio 2013, 2015, 2017, 2019 is fixed
The bug with enabling Devart DataSet Editor in Visual Studio 2017 and Visual Studio 2019 is fixed
LinqConnect (formerly known as LINQ to Oracle)
The bug with using Toolbox component DbLinqDataSource in web projects of Visual Studio 2013, 2015, 2017, 2019 is fixed
Entity Developer
The 12cR2 option is added to the list of available Oracle versions in Model Synchronization Settings
The bug with truncating long names to 30 symbols for Oracle Server 12.2 and higher by Update To Database Wizard / Generate Database Script Wizard is fixed
The bug with creating one-to-one association basing on an optional FK in EF Core Model is fixed
The bug with code generation for oneOrZero-to-one and one-to-many associations based on an optional FK in EF Core Model is fixed
The bug with generating a mapping for a unique constraint specified in owned type property of EF Core Model is fixed
Entity Framework support
Entity Framework 6.4 is supported
Entity Framework Core 3.1 is supported
Views are supported via Scaffold-DbContext in EF Core 3
The new \Entity\EFCore3\Devart.Data.Oracle.Entity.EFCore.dll assembly compiled with EF Core 3.1 and .NET Framework 4.6.1 is added
The new config.CodeFirstOptions.TruncateAllLongNames option (default value is False) is added to use EF Core 2/EF Core 3 implementation for truncating long names of columns and PK/FK/IX/UX
The config.DatabaseScript.ForeignKey.IndexCreation configuration option is supported in EF Core 1/EF Core 2/EF Core 3
The config.DatabaseScript.ForeignKey.IndexTablespace configuration option is supported in EF Core 1/EF Core 2/EF Core 3
The bug with creating a unique constraint in the database via EF Core Code-First Migrations is fixed
The bug with throwing System.NullReferenceException on SaveChanges() when inserting a new entity with value generated by the database in EF Core 3 is fixed
The bug with applying .ValueGeneratedOnAdd() to the string, guid, byte[] properties with .Key() and without .HasDefaultValueSql() in EF Core is fixed
The bug with redundant CASTs when working with NUMBER, DATE and TIMESTAMP columns in EF Core 1/EF Core 2 is fixed
The bug with detecting implicit database column type, when model mapping and migration mapping are different, via EF Core Code-First Migrations is fixed
The bug with generating SQL when using explicit cast in LINQ queries in EF Core 1/EF Core 2 is fixed
The bug with throwing the "Null TypeMapping in Sql Tree" error by methods in LINQ query in EF Core 3 is fixed
Visual Studio 2019 version 16.5 Preview is supported
The bug with using the OracleDbType.VarChar parameter with length greater than 1333 symbols on Oracle 12.1 with NLS_CHARACTERSET=AL32UTF8 in the Direct mode is fixed
The bug with using Toolbox component OracleDataSource in web projects of Visual Studio 2013, 2015, 2017, 2019 is fixed
The bug with enabling Devart DataSet Editor in Visual Studio 2017 and Visual Studio 2019 is fixed
LinqConnect (formerly known as LINQ to Oracle)
The bug with using Toolbox component DbLinqDataSource in web projects of Visual Studio 2013, 2015, 2017, 2019 is fixed
Entity Developer
The 12cR2 option is added to the list of available Oracle versions in Model Synchronization Settings
The bug with truncating long names to 30 symbols for Oracle Server 12.2 and higher by Update To Database Wizard / Generate Database Script Wizard is fixed
The bug with creating one-to-one association basing on an optional FK in EF Core Model is fixed
The bug with code generation for oneOrZero-to-one and one-to-many associations based on an optional FK in EF Core Model is fixed
The bug with generating a mapping for a unique constraint specified in owned type property of EF Core Model is fixed
Entity Framework support
Entity Framework 6.4 is supported
Entity Framework Core 3.1 is supported
Views are supported via Scaffold-DbContext in EF Core 3
The new \Entity\EFCore3\Devart.Data.Oracle.Entity.EFCore.dll assembly compiled with EF Core 3.1 and .NET Framework 4.6.1 is added
The new config.CodeFirstOptions.TruncateAllLongNames option (default value is False) is added to use EF Core 2/EF Core 3 implementation for truncating long names of columns and PK/FK/IX/UX
The config.DatabaseScript.ForeignKey.IndexCreation configuration option is supported in EF Core 1/EF Core 2/EF Core 3
The config.DatabaseScript.ForeignKey.IndexTablespace configuration option is supported in EF Core 1/EF Core 2/EF Core 3
The bug with creating a unique constraint in the database via EF Core Code-First Migrations is fixed
The bug with throwing System.NullReferenceException on SaveChanges() when inserting a new entity with value generated by the database in EF Core 3 is fixed
The bug with applying .ValueGeneratedOnAdd() to the string, guid, byte[] properties with .Key() and without .HasDefaultValueSql() in EF Core is fixed
The bug with redundant CASTs when working with NUMBER, DATE and TIMESTAMP columns in EF Core 1/EF Core 2 is fixed
The bug with detecting implicit database column type, when model mapping and migration mapping are different, via EF Core Code-First Migrations is fixed
The bug with generating SQL when using explicit cast in LINQ queries in EF Core 1/EF Core 2 is fixed
The bug with throwing the "Null TypeMapping in Sql Tree" error by methods in LINQ query in EF Core 3 is fixed
Only for V.I.P Warning! You are not allowed to view this text.