dotConnect for Oracle 9.5 is released!

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Site Admin
Posts: 3276
Joined: Tue 26 Oct 2004 13:51

dotConnect for Oracle 9.5 is released!

Post by Devart » Mon 30 Oct 2017 15:39

Dear users,

Devart is glad to announce the release of dotConnect for Oracle 9.5, Devart ADO.NET data provider for Oracle with support for Entity Framework, LinqConnect (LINQ to Oracle) and NHibernate. The new version offers you support for .NET Standard 2.0, .NET Core 2.0 and Entity Framework Core 2.0.

.NET Standard Compatible Assemblies

dotConnect provider for Oracle now has .NET Standard compatible assemblies both for .NET Standard 1.3 and .NET Standard 2.0. .NET Standard 2.0 assemblies require .NET Core 2.0 or later or Full .NET Framework 4.6.1 or later. .NET Standard 2.0 compatible assemblies are not included in the product installers and are available only via NuGet packages, as well as .NET Standard 1.3 compatible assemblies.

NuGet packages of dotConnect for Oracle now include both .NET Standard 1.3 and .NET Standard 2.0 compatible assemblies. The corresponding assemblies are selected automatically, depending on the target framework of your project.

Not all provider features, available for Full .NET Framework are also available in .NET Standard compatible assemblies. However, the new .NET Standard 2.0 compatible assemblies support much more features, that are not available in .NET Standard 1.3 compatible assemblies. Particularly, the new assemblies include support for distributed transactions, DataAdapter and CommandBuilder classes, Dump classes, etc. You can see the full list of features in the dotConnect for Oracle documentation.

Technical Licensing

.NET Standard 2.0 compatible assemblies use the same licensing mechanism as .NET Standard 1.3 compatible assemblies. They use either license key files placed to a specific folder (C:\ProgramData\Devart\dotConnect\License\) or license keys provided as a connection string parameter. Note that trial license key files are generated by the trial installers of our product. If you want to try the .NET Standard compatible assemblies of our products, distributed via NuGet packages, you will still need to install the product in order to obtain the trial license key file. You can find more information about technical licensing in the dotConnect for Oracle documentation.

New Features in Entity Developer

The new version of Entity Developer supports Entity Framework Core 2.0. Now you can design both Entity Framework Core 1.1 and 2.0 models. In Entity Framework Core 2.0 models you can use complex types for entity properties, Entity Framework Core 2.0 native mapping for database scalar functions, table splitting, generate self-contained type configuration code, etc.

Additionally, the new version of Entity Developer now supports executing LINQ queries against the model and retrieving data when working with projects, targeting .NET Core or .NET Standard.

Here is the complete list of dotConnect for Oracle 9.5.381 features:
  • .NET Standard 2.0 is supported
    • .NET Standard 2.0 compatible assemblies are added to the Devart.Data and Devart.Data.Oracle NuGet packages
    • Distributed transactions are supported
    • The OracleDataAdapter and OracleCommandBuilder are implemented
    • The OracleConnection.GetSchema() and OracleDataReader.GetSchemaTable() methods for metadata retrieving are implemented
    • The OracleDataSourceEnumerator class is implemented
    • The Details property is added to the OracleNotificationEventArgs class
    • Component classes in .NET Standard 2.0 compatible assemblies are inherited from the Component class, and some of them implement the ICloneable and ISupportInitialize interfaces
    • Some of the classes, representing data types, now implement the INullable and ISerializable interfaces
  • .NET Core 2.0 is supported
  • The bug with serializing TrimFixedChar, PassParametersByName, ActionName, ClientInfo, ModuleName properties of the OracleConnection class in .NET Compact Framework projects is fixed
  • The bug with using Oracle Client by .NET Standard compliant assemblies in full .NET Framework project is fixed
LinqConnect (formerly known as LINQ to Oracle)
  • .NET Standard 2.0 is supported
  • .NET Core 2.0 is supported
  • The bug with .Union().Any() is fixed
Entity Developer
  • .NET Standard 2.0 projects in Visual Studio 2017 are supported
  • .NET Core 2.0 projects in Visual Studio 2017 are supported
  • Entity Framework Core 2.0 is supported
  • The Retrieve Data functionality via Model Explorer for EF Core 2 is implemented
  • The bug with escaping invalid XML characters in the comments generated by templates is fixed
Entity Framework support
  • Entity Framework Core 1.1.3 is supported
  • Entity Framework Core 2.0 is supported
  • The bug with comparing NCLOB/CLOB columns in WHERE clauses of the UPDATE/DELETE commands when translating EF Core queries is fixed
Devart development team