Released: Jun 9, 2016

Updates in V9.1.35

Features

• HA Events from Oracle RAC are supported.
• Connection pool performance counters are implemented.
• The PartitionName property, specifying the name of the partitioned table partition to load data into, is added to the OracleLoader class.
• The new LoadTable overloads for loading data from a IDataReader, array of rows, or only rows with a specific RowState from a DataTable are added to the OracleLoader class.
• The Options property of the new OracleLoaderOptions type that allows configuring OracleLoader behavior is added to the OracleLoader class.
• The RowsCopied event that allows tracking data loading progress and correctly break the data loading operation is added to the OracleLoader class.
• When loading data in the OCI mode using array binding, OracleLoader now adds the /* APPEND_VALUES */ hint to the generated SQL for Oracle 11g Release 2 and higher.
• The OracleLogicalTransaction property is added to the OracleConnection class and the new OracleLogicalTransaction class is created for better support of Oracle Transaction Guard.
• All DbTypes are supported.
• Truncate member that represents the TRUNCATE TABLE statement is added to the SqlStatementType enum.
• The GetMappedType method that returns the result .NET type for the specified precision and scale and allows testing specified number mapping configuration is added to the OracleNumberMappingCollection class.
• Oracle objects in array binding in the Direct mode are supported.
• The OracleLob class is improved.
• The OracleXml class is improved.
• The OracleNumber structure is improved.
• The OracleDate structure is improved.
• The OracleTimeStamp structure is improved.
• The OracleBoolean structure is improved.
• The OracleCursor class is improved.
• The OracleString class is improved.
• The OracleRef class is improved.
• The OracleHomeCollection class is improved.
• Support for binary representation of Oracle data types is improved in OracleDate and OracleString structures.
• The Run Once Command connection string parameter, which specifies a command or several commands to execute when the connection is opened the first time and not executed when the connection is taken from the pool, is added.
• The Initialization Command connection string parameter is improved: now it can contain several commands.
• The implementation of DML arrays in output parameters in the Direct mode is improved.
• The exception message when the source value is out of range for a .NET Framework type is improved: now it also contains the name of column that caused the issue.
• The behavior is changed: the CreateColumns method of the OracleLoader class now does not add GENERATED ALWAYS AS IDENTITY columns to the collection in the OCI mode.
• The behavior is changed: now the ORA-01805 error is ignored when Oracle Client and server have timezone files of different versions and a value of a TIMESTAMP WITH TIME ZONE with time zone explicitly specified by name is read.
• The behavior is changed: number mappings in the connection string now influence the code generated by Oracle Package Wizard.

LinqConnect (formerly known as LINQ to Oracle)

• Bitwise And, Or, and Xor operators are supported in LINQ queries for integer operands.

Entity Developer  

• Entity Framework Core support is added.
• The DbProviderFactory provider registration in application's *.config is supported by the Entity Developer version integrated into Visual Studio.

Entity Framework

• Entity Framework Core RC2 is supported.
• Entity Framework-related assemblies are renamed.
• The config.QueryOptions.OrderByNullBehavior option is added to specify whether to add NULLS FIRST or NULLS LAST to the ORDER BY clause.
• Upgrade Wizard is improved for upgrading projects with the Entity Framework functionality.