Devart is glad to announce the release of the new version of dotConnect for Oracle, enhanced database connectivity solution, built over the ADO.NET architecture, that supports Entity Framework and LinqConnect ORM solutions. New dotConnect for Oracle offers you support for Oracle 12c and Microsoft Sync Framework 2.1.
Oracle 12c Support
dotConnect for Oracle now supports the latest Oracle version - Oracle 12c. Now you can use such its new features as implicitly returned result sets, new connection modes (SYSBACKUP, SYSDG, SYSKM), autoincrement Identity columns, Transaction Guard and more.
When working with Oracle 12c, Entity Developer generates Identity columns instead of a sequence and a trigger for when generating a database script from a model with identity columns. Entity Developer also supports new Oracle 12c connection modes when creating a connection.
Sync Framework Support
dotConnect for Oracle now provides support for Sync Framework 2.1. It provides OracleSyncProvider class, classes for provisioning and deprovisioning, and OracleSyncDescriptionBuilder class. Now you can easily synchronize your Oracle databases using dotConnect for Oracle.
Here is the complete list of dotConnect for Oracle 8.0.17 features:
- Oracle 12c is supported
- Auto increment identity columns are supported (only in the OCI-mode, and only for Oracle 12c)
- Returning of affected row count for each array element when using array binding is supported (only in the OCI-mode, and only for Oracle 12c)
- Implicit result sets are supported (only in the OCI-mode, and only for Oracle 12c)
- Transaction Guard is supported (only in the OCI-mode, and only for Oracle 12c)
- New connection modes are supported: SYSBACKUP, SYSDG and SYSKM
- Microsoft Sync Framework support is implemented
- The OracleDate.IsValidDateTime property is implemented for checking if a valid DateTime will be returned for the Value property
- The overload for constructor of OracleNumber class with System.Single type parameter is added
- The bug with OracleCommand Editor when opening the Object Name combobox for a stored procedure for Oracle 8.0 is fixed
- The bug with executing ExecuteArray for VarChar/NVarChar parameters with Size not specified explicitly, when the parameter Value contains an array, having only enum values, is fixed
- The bug with not copied values of CommandTimeout and PassParametersByName properties of an OracleCommand object, when cloning it, is fixed
- The bug with reexecuting a prepared query in the Direct mode is fixed
- The bug with precision loss when reading BINARY_FLOAT, BINARY_DOUBLE, FLOAT as OracleNumber is fixed
- The bug related to the "Operation is not valid due to the current state of the object" exception when using Parallel in the Direct mode is fixed
- The Collate method of the SqlMethods class is implemented
- VARCHAR2/NVARCHAR2/RAW types with length increased to 32KB are supported for Oracle 12c
- Oracle 12c specific SQL generation for paging is supported
- The behaviour is changed: CreateDatabase functionality generates columns with the identity clause 'GENERATED AS IDENTITY' for primary key properties with 'IsDbGenerated=True' (only for Oracle 12c)
- The bug with ignoring 'IsDbGenerated = True' when using Attach(TEntity entity, bool asModified) method is fixed
- The bug with the compiled query cache when query contains parameters with the same values is fixed
- The predefined templates are improved: new template setting, "Use Compiled Query Cache", is added (LinqConnect models)
- The behaviour is changed: "Generate Database Script"/"Update Database From Model" wizards generate columns with the identity clause 'GENERATED AS IDENTITY' for properties with 'Store Generated Pattern=Identity' (only for Oracle 12c, Entity Framework models)
- The behaviour is changed: "Generate Database Script"/"Update Database From Model" wizards generate columns with the identity clause 'GENERATED AS IDENTITY' for properties with 'Auto Generated Value=True' (only for Oracle 12c, LinqConnect models)
- The bug with "DevartEntityDeploy" task, which generates mapping files, in Visual Studio 2013 Release Candidate is fixed
- Generation of OUTER APPLY statement in Entity Framework is supported for Oracle 12c
- Oracle 12c specific SQL generation for paging is supported
- VARCHAR2/NVARCHAR2/RAW types with length increased to 32KB are supported for Oracle 12c
- The behaviour is changed: Code-First/Code-First Migrations generate columns with the identity clause 'GENERATED AS IDENTITY' for entity key properties with 'Store Generated Pattern=Identity' (only for Oracle 12c)
- The behaviour is changed: Code-First Migrations generates DEFAULT 0 for new NOT NULL columns of numeric types when adding them in the existing table
- The behaviour is changed: Code-First Migrations generates DEFAULT EMPTY_CLOB() for new NOT NULL columns of CLOB/NCLOB types when adding them in the existing table
- The behaviour is changed: Code-First Migrations generates DEFAULT '' for new NOT NULL columns of CHAR/NCHAR/VARCHAR2/NVARCHAR2 types when adding them in the existing table
- The bug related to work in Entity Data Model Wizard with Oracle 9.2 is fixed
- The bug with performing queries via the ExecuteStoreQuery, SqlQuery methods in Entity Framework 6 is fixed
http://www.devart.com/dotconnect/oracle/