dotConnect for Oracle Professional 9.8.838

What's new in this version:

dotConnect for Oracle Professional 9.8.838
- The integration with Visual Studio 2019 is improved: now the installation detects both 2019 Release and 2019 Preview versions
- The bug with applying Oracle globalization settings for TIMESTAMP WITH LOCAL TIME ZONE is fixed
- The bug with throwing "Unknown error 1" by OracleDataReader.GetOracleLob() in the Direct mode is fixed
- The bug with using array binding on Oracle 19c in the Direct mode is fixed
- The bug with using parameters of invalid object type in the Direct mode is fixed
- The bug with generating code for a parameterless package procedure by Oracle Package Wizard for Oracle 12c and higher is fixed

Entity Developer:
- Entity Framework 6.3 Preview 9 is supported for projects with target framework .NET Core 3 or .NET Standard 2.1
- The behaviour is changed: a plural form of names ending with "s" now has a longer version (for example, status -> statuses)
The bug with applying the new Foreign Key's Delete Rule values SET DEFAULT and SET NULL by the Update Database From Model and Update Model From - Database wizards is fixed (Entity Framework)
- The bug with copying a property with Primary Key=True / Entity Key=True to a complex type is fixed (Entity Framework)
- The bug with naming of a composing unique key by Create Model Wizard / Update From Database Wizard in EF Core is fixed (Entity Framework)
- The bug with invalid attempt to cast unsupported Visual Studio project to type 'VSLangProj.VSProject' is fixed

Entity Framework support:
- Entity Framework 6.3 Preview 9 is supported
- A new NuGet package Devart.Data.Oracle.EF6 with a .NET Standard 2.1 assembly, compatible with .NET Core 3, is added
- The bug with missing CAST for RAW(16) parameters in the WHERE clause of UPDATE statements in EF6 is fixed
- The bug with using the same database connection in several EF Core contexts is fixed
- The bug with applying a value converter to .Where expression with .Contains on nullable enum in EF Core 2 is fixed
- The bug with translating .All clause within .Where condition in EF Core 2 is fixed


dotConnect for Oracle Professional 9.7.805
- The bug with throwing System.IndexOutOfRangeException when OracleParameter.Size=-1 is fixed

Entity Framework support:
- The bug with applying a value converter to a nullable column in EF Core 2 is fixed
- The bug with using the binary operator Add for the types 'System.String' and 'System.String' within LINQ query in EF Core 2 is fixed


dotConnect for Oracle Professional 9.7.790
- The bug with inserting TIMESTAMP WITH TIMEZONE values with negative timezone in the Direct mode is fixed
- The bug with throwing "Operation is not supported" by web providers, when the cookie is used, is fixed
- The bug with reading incorrect timestamp's timezone and offset in the Direct connection mode when the timezone is presented as a string value is fixed


dotConnect for Oracle Professional 9.7.770
- Deprecated design-time Synchronous API calls are no longer used with Visual Studio 2019 and Visual Studio 2017
- The bug with executing OracleCommand, having CommandType.StoredProcedure, when its CommandText contains a colon, which does not denote a stored procedure overload number, is fixed
- The bug with processing line breaks by OracleScript, when a script contains lines of only a semicolon character, is fixed
- The bug with inserting a long string into the VARCHAR2 column on Oracle Server with NLS_CHARACTERSET=UTF8 in the Direct mode is fixed
- The bug with reading data from the NVARCHAR2 column on Oracle Server with NLS_NCHAR_CHARACTERSET=UTF8 in the Direct mode is fixed
- The bug with reading CLOB data in the OracleUtils.OracleClientCompatible mode via the reader.GetOracleLob().Value and reader.GetOracleLob().Length properties and reader.GetOracleLob().Read() and reader.GetString() methods is fixed
- The bug with reading incorrect timestamp's timezone and offset from an Oracle object field when the timezone is presented as a string value, is fixed
- The bug with throwing "ORA-01000: maximum open cursors exceeded" in the Direct mode is fixed
- The bug with errors when executing ExecuteArray with large string array parameters without specifying the parameters Size is fixed

LinqConnect (formerly known as LINQ to Oracle):
- The bug with executing incorrect SQL request (cached during one of the previous calls), when a variable initialized with an empty collection participates in LINQ query, is fixed

Entity Framework support:
- Entity Framework Core 2.2.4 is supported
- The bug with closing database connection by context.Dispose() in the scope of a distributed transaction in EF Core 2 is fixed
- The bug with using a value converter, when the .NET data type remains the same, within the WHERE clause in EF Core 2 is fixed
- The bug with applying an escaped quotation to the idempotent script in EF Core 2 Code-First Migrations is fixed


dotConnect for Oracle Professional 9.7.734

- Visual Studio 2019 is supported
- OS authentication is supported in the Direct mode
- The behaviour is changed: when loading data in the Direct mode, OracleLoader now adds the /* APPEND_VALUES */ hint to the generated SQL for Oracle 11g Release 2 and higher
- The bug with freezing when reading an XMLTYPE value in the OCI mode, when CommandBehavior is set to SequentialAccess, is fixed
- The bug with encoding registration in .NET Standard compliant assemblies is fixed

Entity Developer:
- The bug with processing DBNull returned by the function in EF Core is fixed

Entity Framework support:
- The bug with using the "Generate Database from Model" wizard when working with Entity Framework 6 Tools is fixed
- The bug with quoting string parameter set in the DbFunction attribute in EF Core is fixed


dotConnect for Oracle Professional 9.6.725

- Visual Studio 2019 Release Candidate 4 is supported
- The GetOracleTimeStamp, GetDateTimeOffset, and GetTimeSpan methods are added to OracleArrayDataReader
- The bug with throwing NRE when calling the GetSchemaTable method of OracleArrayDataReader for a VARRAY column is fixed
- The bugs with reading data via OracleArrayDataReader are fixed
- The bug with corrupting not Latin-1 characters by Migration Wizard for files with non-unicode encoding is fixed

Entity Framework support:
- Entity Framework Core 2.2.3 is supported
- The SQL translation of the following method overloads, that accept the StringComparison argument and return bool, in the System.String class is supported in EF Core 2: Contains, StartsWith, EndsWith, Equals
- The .HasComputedColumnSql functionality for the AddColumn and AlterColumn operations in EF Core Code-First Migrations is supported
- The bug with using the TIMESTAMP(6) WITH TIME ZONE column type in EF Core 2.2 mapping is fixed
- The bug with generating the COALESCE expression in EF Core is fixed
- The bug with calling DbExecutionStrategy.ShouldRetryOn(Exception), when the first connection fails to open, is fixed


dotConnect for Oracle Professional 9.6.675

- The bug with calling OracleDataReader.IsDBNull() for a NULL value from an XMLTYPE column is fixed
- The bug with connecting to a localhost in the Direct mode is fixed
- The bug with connecting to Oracle 12c in the Direct mode is fixed

LinqConnect (formerly known as LINQ to Oracle):
- The new overload DataContext.Refresh(bool ignoreErrors, RefreshMode mode, object entity) is added for ignoring errors during refresh
- The existing overload DataContext.Refresh(RefreshMode mode, object entity) is improved: its check avoids the try to refresh the entity that is added to the context but not submitted to the database
- The type and text of the error generated by the DataContext.Refresh(RefreshMode mode, object entity) method, when the passed entity doesn't exist in database, is fixed

Entity Developer:
- The multiple select functionality in EF Core Model is improved: now it allows setting PrimaryKey, ValueGenerated, Concurrency for several properties simultaneously
- The bug with detecting order of columns in composite primary key with two or more columns by Update To Database and by Update From Database wizards in EF Core is fixed
- The bug with using ASP.NET Core Web Application (.NET Framework) and Azure Functions v1 (.NET Framework) projects in Visual Studio 2017 is fixed

Entity Framework support:
- Entity Framework Core 2.2.1 is supported
- The new extension method Database.IsOracle() in EF Core 2 is implemented
- The .HasComputedColumnSql functionality in EF Core Code-First Migrations is supported
- The performance of Entity Data Model Wizard is improved
- The bug with applying config.Workarounds.IgnoreSchemaName=true to the .ToTable() functionality in EF Core 2 is fixed
- The bugs with using the GuidToStringConverter, EnumToStringConverter, ValueConverter classes in EF Core 2 are fixed
- The bug with constructing the LIKE clause in EF Core 2 is fixed
- The bug with generating a subselect within the SELECT list in EF Core 2 is fixed
- The bug with applying an aggregate function to the result of a subselect in EF Core 2 is fixed
- The bug with throwing "ORA-00907: missing right parenthesis" in EF Core 2 is fixed
- The bug with accessing FKs, when the SELECT permission is granted through roles, by Entity Data Model Wizard is fixed