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 native Source and Destination components for DataFlows in SQL Server Integration Services projects.
Source Components
Source components of dotConnect for Oracle are data flow components that query data from the corresponding database and make it available for other DataFlow components. They provide powerful editor dialog boxes, allowing you to tweak the components visually.
These editors display an object tree with availabe tables to select data from and SQL Server Integration Services (SSIS) system variables allowing you to quickly use their names in the queries.
Destination Components
Devart Destination components use database-specific features to load data quickly, thus providing significantly higher perfomance for data loading that the standard ADO.NET Destination component. They also allow advanced per-row error processing. Destination components can return a set of columns, containing error code, error columns, and error description for the rows, that caused an error.
Here is the complete list of dotConnect for Oracle 7.9.322 features:
- SSIS DataFlow Source and Destination components for Oracle are implemented
- The bug with the '-1' value of the MaxLength property for columns with the string or varchar type, which are created by OracleDataAdapter, is fixed
- The bug with the GetHashCode method of the OracleNumber class is fixed
- The bug with an error occurring during opening a connection, and then this connection getting into the pool is fixed
- The bug with the Caption property of the DataGridView column with the Devart DataTable component is fixed
- The bug with generating wrong exception, when invalid password is used in the Direct mode, is fixed
- The bug with detecting self-relations in Microsoft DataSet Wizard is fixed
- The bug with setting an incorrect LockExpiration when extending lock in Oracle Workflow Instance Store is fixed
- The possibility to use the extension method AsQueryable() in LINQ queries is added
- The support for correct retrieving of the TimeSpan and DateTimeOffset values while materializing is added
- The bug with eager loading is fixed
- The bug with the redundant opened sessions is fixed
- The bug with missing CreateCommand method in the DataProvider class is fixed
- The bug related to the ArgumentNullException on SubmitChanges method when trying to update a row with the same values is fixed
- The bug with the wrong DDL generation in the CreateDatabase() method with the DateTimeOffset properties is fixed
- The "Close the window when the generation completes successfully" option in the Generation Process window is implemented in the standalone Entity Developer
- The "Rewrite connection string during regeneration" option (default value is True) of model settings is added to provide the possibility to turn off modifying connection string in *.config after model is saved first time (Entity Framework models)
- The design time support for model-defined functions is added (Entity Framework models)
- The behaviour is changed: now connection string is configured with the name of the assembly, where the model is located, in case when the context class is located in another assembly (Entity Framework models)
- The bug with the Retrieve Data functionality of the model with the DbContext template, when its Fluent Mapping property is set to True, is fixed (Entity Framework models)
- The bug related to the detection of Table Per Type inheritances as Table Per Concrete Type inheritances when opening an existing model is fixed (Entity Framework models)
- The bug with parsing *.edmx is fixed (Entity Framework models)
- The bug with generating "An item with the same key has already been added" error when using DbContext Template is fixed (Entity Framework models)
- The bug with DbContext template, when its MappingGenerationStrategy is set to UseConfigurationClasses, generating fluent mapping for an association with turned off generation of one navigation property is fixed (Entity Framework models)
- The bug with availability of the New Blank Template option of the Templates context menu in Model Explorer in the Entity Developer version integrated into Visual Studio is fixed
- The bug with generating invalid code when using MVC View Advanced template is fixed
- Entity Framework 6 Release Candidate 1 is supported
- The config.DmlOptions.UseReturningClause configuration option (default value is True) is added to provide the possibility to turn off generation of RETURNING clause when obtaining database-generated values with INSERT/UPDATE commands
- SharpMap 1.0 RTM is supported
- NetTopologySuite 1.13.1 is supported
- Devart.Data.Oracle.Entity.SharpMap.dll assembly is renamed to Devart.Data.Oracle.Entity.Spatials.dll
- The bug with generating NRE when adding parameter to a command in IDbCommandInterceptor.ReaderExecuting in Entity Framework 6 is fixed
http://www.devart.com/dotconnect/oracle/