軟體下載 dotConnect for Oracle Professional 9.11.951

• 1

  版本確認

• 2

  檔案準備中

• 3

  檔案下載

What's new in this version:

dotConnect for Oracle Professional 9.11.951
- 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


dotConnect for Oracle Professional 9.9.887
- The "Optimize rendering for screens with different pixel densities" feature of Visual Studio 2019 is supported by Devart DataSet Editor

Entity Developer:
- The Self-Contained Entity Configuration property is added to VB.NET version of EF Core template
- The Entities Configuration Output property is added to VB.NET version of EF Core template
- The code generation for the class properties with Alternate Key=True by VB.NET version of EF Core template is supported in EF Core model
- The bug with code generation, when Raw SQL Query is initialized in class properties, in EF Core 3 model is fixed
- The bug with generating .HasNoKey(), when Self-Contained Entity Configuration is set to True in properties of EF Core template, in EF Core 3 - model is fixed
- The bug with generating alternate keys, when Self-Contained Entity Configuration is set to True in C# version of EF Core template, in EF Core - model is fixed

Entity Framework support:
- The config.DatabaseScript.PrimaryKey.IndexTablespace configuration option is added to specify the tablespace for implicit PK indices created via - the Code-First approach
- Support for changing NULL/NOT NULL constraint for LOB columns in the AlterColumn operation of EF Core Code-First Migrations is added
- The SQL generation in case of config.QueryOptions.UseCSharpNullComparisonBehavior=true in EF1/EF4/EF5/EF6 is improved
- The bug with using Scaffold-DbContext in EF Core 3 is fixed
- The bug with the redundant empty ORDER BY clause in a subquery, when paging is used, in EF Core 3 is fixed
- The bug with generating invalid SQL when calling members of owned type in EF Core 2 is fixed
- The bug with throwing "ORA-12704: character set mismatch" in case of UNION ALL over OUTER APPLY/CROSS APPLY in EF1/EF4/EF5/EF6 is fixed
- The bug with using .Contains within .Select of LINQ query in EF Core 2 is fixed