|
What's new in this version: dotConnect for Oracle Professional 9.11.980
- The new connection string parameter SSL Key is added
The bug with using the following parameters of connection.GetSchema("Arguments", ...) is fixed:
- connection.GetSchema("Arguments", new string[] { "schema_name", null })
- connection.GetSchema("Arguments", new string[] { "schema_name", "%" })
- connection.GetSchema("Arguments", new string[] { "schema_name", "package_name", "procedure_name" })
- connection.GetSchema("Arguments", new string[] { "schema_name", null, "procedure_name" })
- The bug with calling OracleDataReader.IsDBNull() for a NULL value got from the ANYDATA column is fixed
- The bug with defining functions and procedures in the view body specified in OracleScript.ScriptText for Oracle 12c and higher is fixed
LinqConnect (formerly known as LINQ to Oracle):
- The insert of the object, the type of which is an unmapped class inherited from a mapped class, is supported
- The bug with throwing System.NullReferenceException, when constructing the error saying that unmapped class is not supported, is fixed
Entity Developer:
- Command-line interface is implemented in a standalone Entity Developer
- The new property Context Name is added to Model Properties in EF Core Model
- The new property Target Framework is added to Model Properties in EF Core Model
- The provider registration is improved: requirement to put provider registration entry in the config file is not obligatory anymore
- Create Model Wizard is improved: now it allows installing multiple NuGet packages on the final step
- Model file tree in .NET Core / .NET Standard projects is improved: all generated code files and model files are nested under the same node in Solution Explorer
Entity Framework support:
- Entity Framework Core 3.1.3 is supported
- The .ToString() call for numbers, DateTime/DateTimeOffset properties and values in LINQ queries in EF Core is supported
- The call of Convert.ToString(value) in LINQ queries in EF Core is supported
- The bug with using collections with more than 1000 items in a .Contains() method in EF Core 3 is fixed
- The bug with the AlterColumn operation in EF Core Code-First Migrations, when data type is being changed but oldType is not specified, is fixed
- The bug with generating EXCEPT instead of MINUS in SQL produced by EF Core 3.1 is fixed
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 |
