Devart dotConnect for Oracle v10.1.151.0 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 approache...
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.
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
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, 3.x, 5.0, and 6.0
Visual Studio 2022 version 17.7 Preview is supported
Implemented IOracleCommandAdapter interface to access OracleCommand in IDbCommandInterceptor in EF6
Implemented option config.QueryOptions.InitialLobFetchSize for EF4/EF5/EF6 and EF Core
Fixed bug with InitialLobFetchSize in OracleCommand when calling Clone() method
Entity Framework support
Entity Framework Core 7.0.5 is supported
Entity Framework Core 6.0.16 is supported
The bug with incorrect SQL translation of reused LINQ query, which includes array.Contains() and other expressions, in EF Core 5/6/7 is fixed
The bug with generating parameter prefixed by a double colon in EF Core 7 is fixed
The bug with assigning null to the NetTopologySuite property in EF Core is fixed
The bug with using the .ExecuteDelete() functionality in EF Core 7 is fixed
The behavior is changed: the primitive properties by default have Inheritance Modifier = None
The bug with the detection of non-existent changes while updating a model from a database is fixed
The bug with creating Devart Entity Model in Visual Studio 2022 is fixed
The bug with missing model context namespace in EntityFrameworkUnitOfWork.cs produced by the Repository And Unit of Work template (C#) in EF Core is fixed
The bug with generating incorrect scale in mapping for decimal columns by the EF Core template (Visual Basic) in EF Core 5 and higher is fixed
The bug with code generation for TPT inheritance in the EF Core template is fixed
The bug with retrieving metadata of functions, procedures, packages in Oracle Server 8i/9i/10g by Create Model Wizard is fixed