Devart dotConnect for Oracle v9.11.951 Professional
Devart dotConnect for Oracle v9.11.951 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.11.951 20-Feb-20
SQL Server Integration Services 2019 (SSIS 2019) is supported
SSL/TLS is supported in the Direct mode
The new connection string parameters SSL Cert and SSL Server CertDN are added
The new properties WalletMethod and WalletLocation are added to the DirectUtils class
The new class OracleCredential is implemented to provide a more secure way to specify the password while opening connection in the OCI mode on Windows
The new overload OracleConnection(string connectionString, OracleCredential credential) is added
The new overload ChangePassword(SecureString newPassword) is added
The new property DefaultExpressionCacheSize (by default, 100) is added to the OracleLoader class to specify the number of default expressions that are evaluated at a time
The new property DefaultExpressionBehavior is added to the OracleLoader class to specify how the direct path API handles default expressions for columns that are not explicitly being loaded
OCI Multiple Homes is supported in .NET Standard 2.1
The OracleDataTable and OracleDataSet classes are supported in .NET Standard 2.0/2.1
Connection pool performance counters are supported in .NET Standard 2.0/2.1
.NET Standard 2.1 compatible assembly is added to the Devart.Data.Oracle NuGet package
The new class OracleShardingKey is implemented to store one or more key values for sharding in the OCI Session Pooling mode with Oracle Client 12g Release 2 and higher
The new methods SetShardingKey(OracleShardingKey shardingKey) and SetShardingKey(OracleShardingKey shardingKey, OracleShardingKey superShardingKey) are added to the OracleConnection class
Query Result Change Notification (QRCN) is supported
The new column QueryId is added to DataTable stored in OracleNotificationEventArgs.Details
The new properties GroupingNotificationEnabled, GroupingType, GroupingInterval are added to the OracleNotificationRequest class
The new properties RegisteredQueryIds, RegisteredResources, RegId are added to the OracleDependency class
The new connection mode OracleConnectMode.SysRac is supported for managing Real Application Clusters in Oracle Server 12c Release 2 and higher
The new property OracleUtils.ParameterValueTrimming (by default, false) is added to trim value that exceeds OracleParameter.Size
The behavior is changed: OCIStmtPrepare2() is used now instead of OCIStmtPrepare() in the OCI mode to support the use of Application Continuity in an HA infrastructure
The behavior is changed: pool is automatically cleared when AppDomain is being closed
The bug with inserting Unicode N-prefixed string literal when using the "Unicode=true" connection string parameter in the Direct mode is fixed
The bug with getter of OracleParameter.OracleValue, when it returns an empty array, is fixed
The bug with initializing NHibernate configuration on .NET Standard 2.0 is fixed
LinqConnect (formerly known as LINQ to Oracle)
The bug with case insensitive comparison via string.Compare() is fixed
Entity Developer
The bug with returning multiple result sets in code generated by the EF Core template is fixed
Entity Framework support
Entity Framework Core 3.1.1 is supported
The bug with using a discriminator in EF Core 3 is fixed
The bug with querying types in inheritance hierarchy via EF Core 3 is fixed
The bug with generating a subselect within the CASE clause in EF Core 3 is fixed
The bug with using .All in the .Where expression in EF Core 2 and EF Core 3 is fixed
The bug with detecting string parameter data type in EF Core 3 expressions is fixed
The bug with paging in EF Core 3, when using JOINs and subqueries to Oracle 11.2 and below, is fixed
The bug with missing GENERATED BY DEFAULT AS IDENTITY in the script created by EF Core Migrations for the property with .HasColumnType(@"NUMBER").ValueGeneratedOnAdd() is fixed
The bug with using nullable enum properties with default mapping to integers in LINQ query in EF Core 3.1 is fixed
The bug with using value converters detected automatically by .HasConversion() in EF Core 3 is fixed
The bug with using NULL constant values in EF Core 3 is fixed
The bug with using binary operators AND, OR in EF Core 3 is fixed
SQL Server Integration Services 2019 (SSIS 2019) is supported
SSL/TLS is supported in the Direct mode
The new connection string parameters SSL Cert and SSL Server CertDN are added
The new properties WalletMethod and WalletLocation are added to the DirectUtils class
The new class OracleCredential is implemented to provide a more secure way to specify the password while opening connection in the OCI mode on Windows
The new overload OracleConnection(string connectionString, OracleCredential credential) is added
The new overload ChangePassword(SecureString newPassword) is added
The new property DefaultExpressionCacheSize (by default, 100) is added to the OracleLoader class to specify the number of default expressions that are evaluated at a time
The new property DefaultExpressionBehavior is added to the OracleLoader class to specify how the direct path API handles default expressions for columns that are not explicitly being loaded
OCI Multiple Homes is supported in .NET Standard 2.1
The OracleDataTable and OracleDataSet classes are supported in .NET Standard 2.0/2.1
Connection pool performance counters are supported in .NET Standard 2.0/2.1
.NET Standard 2.1 compatible assembly is added to the Devart.Data.Oracle NuGet package
The new class OracleShardingKey is implemented to store one or more key values for sharding in the OCI Session Pooling mode with Oracle Client 12g Release 2 and higher
The new methods SetShardingKey(OracleShardingKey shardingKey) and SetShardingKey(OracleShardingKey shardingKey, OracleShardingKey superShardingKey) are added to the OracleConnection class
Query Result Change Notification (QRCN) is supported
The new column QueryId is added to DataTable stored in OracleNotificationEventArgs.Details
The new properties GroupingNotificationEnabled, GroupingType, GroupingInterval are added to the OracleNotificationRequest class
The new properties RegisteredQueryIds, RegisteredResources, RegId are added to the OracleDependency class
The new connection mode OracleConnectMode.SysRac is supported for managing Real Application Clusters in Oracle Server 12c Release 2 and higher
The new property OracleUtils.ParameterValueTrimming (by default, false) is added to trim value that exceeds OracleParameter.Size
The behavior is changed: OCIStmtPrepare2() is used now instead of OCIStmtPrepare() in the OCI mode to support the use of Application Continuity in an HA infrastructure
The behavior is changed: pool is automatically cleared when AppDomain is being closed
The bug with inserting Unicode N-prefixed string literal when using the "Unicode=true" connection string parameter in the Direct mode is fixed
The bug with getter of OracleParameter.OracleValue, when it returns an empty array, is fixed
The bug with initializing NHibernate configuration on .NET Standard 2.0 is fixed
LinqConnect (formerly known as LINQ to Oracle)
The bug with case insensitive comparison via string.Compare() is fixed
Entity Developer
The bug with returning multiple result sets in code generated by the EF Core template is fixed
Entity Framework support
Entity Framework Core 3.1.1 is supported
The bug with using a discriminator in EF Core 3 is fixed
The bug with querying types in inheritance hierarchy via EF Core 3 is fixed
The bug with generating a subselect within the CASE clause in EF Core 3 is fixed
The bug with using .All in the .Where expression in EF Core 2 and EF Core 3 is fixed
The bug with detecting string parameter data type in EF Core 3 expressions is fixed
The bug with paging in EF Core 3, when using JOINs and subqueries to Oracle 11.2 and below, is fixed
The bug with missing GENERATED BY DEFAULT AS IDENTITY in the script created by EF Core Migrations for the property with .HasColumnType(@"NUMBER").ValueGeneratedOnAdd() is fixed
The bug with using nullable enum properties with default mapping to integers in LINQ query in EF Core 3.1 is fixed
The bug with using value converters detected automatically by .HasConversion() in EF Core 3 is fixed
The bug with using NULL constant values in EF Core 3 is fixed
The bug with using binary operators AND, OR in EF Core 3 is fixed
Only for V.I.P Warning! You are not allowed to view this text.