dotConnect for Oracle History

10.3.104 08-Nov-24

Supported Visual Studio 2022 version 17.12 Preview
Fixed an issue with integration in Visual Studio 2015 and earlier versions
Fixed the DataSet Wizard crash in Visual Studio 2022
Fixed an issue with the Oracle Object Wizard in Visual Studio 2022
Fixed a design-time bug with the OracleQueue component in Visual Studio 2022
Fixed a design-time bug with the OracleDataTable Tasks interface element in Visual Studio 2022
Resolved an issue with connecting to Oracle 19 and higher in Direct mode when using Oracle Encryption or Oracle Data Integrity

Entity Framework support

Updated support for Entity Framework Core 8 to version 8.0.10
Updated support for Entity Framework Core 6 to version 6.0.35
Fixed an issue with incorrect conversion of single-element enum arrays in EF Core LINQ queries
Resolved an issue causing an ORA-00920 error when generated SQL included duplicate WHEN CASE clauses in EF Core 8
Resolved an issue with type mappings that occurred when config.CodeFirstOptions.UseNonLobStrings=true in EF Core 2.1 and later versions
Resolved search query issues with geometry objects containing points in EF Core
Resolved a bug that caused a MissingMethodException in EF Core versions 6, 7, and 8

Entity Developer

Fixed an issue where the Update From Database Wizard reset navigation property names in EF Core models

10.3.21 06-Jun-24

Entity Framework support

Updated support for Entity Framework Core 8 to version 8.0.6
Updated support for Entity Framework Core 7 to version 7.0.20
Updated support for Entity Framework Core 6 to version 6.0.31

10.3.20 29-May-24

Supported Visual Studio 2022 version 17.11 Preview
Added the GetAuditActionBanner() and GetUnauthorizedAccessBanner() methods to the OracleConnection class
Fixed an issue with passing a negative year number in OracleTimeStamp
Fixed an issue where an incorrect comma was added before LEFT OUTER JOIN with OracleSelectStatement
Fixed an issue with OracleSelectStatement that caused an exception after adding a WHERE condition and converting to ToString()

Entity Framework support

Updated support for Entity Framework Core 8 to version 8.0.5
Updated support for Entity Framework Core 7 to version 7.0.19
Updated support for Entity Framework Core 6 to version 6.0.30

Entity Developer

Resolved an issue with saving 'Version=Original' in the Stored Procedure Mapping menu for LinqConnect model

10.3.10 17-Jan-24

.NET 8 compatibility
Visual Studio 2022 version 17.9 Preview is supported
Added support for connect to servers with enabled Security Banners in the Direct mode
The error in the string representation of the OracleSelectStatement containing a JOIN has been fixed
The functionality of the OracleConnection.ChangePassword() method in the Direct mode has been corrected to enable the modification of expired passwords

Entity Framework support

Entity Framework Core 8.0.0 is supported
Entity Framework Core 7.0.14 is supported
Entity Framework Core 6.0.25 is supported
The bug with throwing ArgumentNullException when quering parent table in TPT inheritance in EF Core is fixed

LinqConnect (formerly known as LINQ to Oracle)

.NET 8 compatibility

Entity Developer

EF Core 8 is added to the list of available Entity Framework versions in Create Model Wizard and Model Settings in EF Core Model
.NET 8 is added to the list of available Target Framework versions in Create Model Wizard and Model Settings in EF, EF Core, and LinqConnect models
The new extended property Do Not Generate OnConfiguring Method is added for the model in EF Core Model
The bug with naming of local variables in the code generated for invoking stored procedures and functions with parameters in EF Core is fixed
The bug with unnecessary generation of the GetByKey() method in a repository for entities without primary key (QueryType=True) in EF Core is fixed
The bug with wrongly turned on without the ability to turn off options "Detect Many-to-Many associations" and "Detect Table-Per-Type inheritances" in Model Settings of EF Core 1, 2, 3 models is fixed
The bug with the availability of the "Table-Per-Type Hierarchy (TPT)" option in the "Model Refactoring" dialog of EF Core 1, 2, 3 models is fixed
The bug with the availability of the "Table-Per-Concrete-Type Hierarchy (TPC)" option in the "Model Refactoring" dialog of EF Core 1, 2, 3, 5, 6 models is fixed
The hang of Visual Studio 2022 when saving the model is fixed

10.2.0 16-Nov-23

Oracle 23c is supported
Visual Studio 2022 version 17.8 Preview is supported
The error during installation on the 32-bit version of Windows has been fixed

Entity Framework support

Entity Framework Core 7.0.10 is supported
Entity Framework Core 6.0.21 is supported
The behavior is changed: no additional connection is opened to the database before the first query in EF Core when config.Workarounds.ProviderManifestToken is set explicitly
The bug with running LINQ queries to Oracle Server 11.2 and below in EF Core 5/6/7 is fixed
The bug with a redundant requirement to register UseNetTopologySuite, when it is not used, in EF Core 7 is fixed
The bug with generating invalid SQL when filtering on a boolean property in the Where clause of LINQ query in EF Core 5/EF Core 6/EF Core 7 is fixed
The bug with using the Any clause of LINQ query in EF Core 7 is fixed
The bug with throwing Microsoft.EntityFrameworkCore.Infrastructure.ManyServiceProvidersCreatedWarning by the UseOracle(DbConnection connection) extension method of DbContextOptionsBuilder in EF Core 6 and EF Core 7 is fixed
The bug with using custom converters in mapping in EF Core 3 and higher is fixed
The bug with using the same __EFMigrationsHistory table by several contexts in EF Core Code-First Migrations is fixed

Entity Developer

The bug with detecting NUMBER(1) NOT NULL DEFAULT 1 as function-based column default value in EF Core Model is fixed
The bug with detecting the numeric default value of string columns as function-based column default value in EF Core Model is fixed

10.1.151 01-Jun-23

Visual Studio 2022 version 17.7 Preview is supported
Implemented IOracleCommandAdapter interface to access OracleCommand in IDbCommandInterceptor in EF6
Implemented option config.QueryOptions.InitialLobFetchSize for EF4/EF5/EF6 and EF Core
Fixed bug with InitialLobFetchSize in OracleCommand when calling Clone() method

Entity Framework support

Entity Framework Core 7.0.5 is supported
Entity Framework Core 6.0.16 is supported
The bug with incorrect SQL translation of reused LINQ query, which includes array.Contains() and other expressions, in EF Core 5/6/7 is fixed
The bug with generating parameter prefixed by a double colon in EF Core 7 is fixed
The bug with assigning null to the NetTopologySuite property in EF Core is fixed
The bug with using the .ExecuteDelete() functionality in EF Core 7 is fixed

Entity Developer

The behavior is changed: the primitive properties by default have Inheritance Modifier = None
The bug with the detection of non-existent changes while updating a model from a database is fixed
The bug with creating Devart Entity Model in Visual Studio 2022 is fixed
The bug with missing model context namespace in EntityFrameworkUnitOfWork.cs produced by the Repository And Unit of Work template (C#) in EF Core is fixed
The bug with generating incorrect scale in mapping for decimal columns by the EF Core template (Visual Basic) in EF Core 5 and higher is fixed
The bug with code generation for TPT inheritance in the EF Core template is fixed
The bug with retrieving metadata of functions, procedures, packages in Oracle Server 8i/9i/10g by Create Model Wizard is fixed

10.1.134 01-Mar-23

Visual Studio 2022 version 17.5 Preview is supported
.NET 7 compatibility

Entity Framework support

Entity Framework Core 7.0.2 is supported
Entity Framework Core 6.0.13 is supported
Entity Framework Core 3.1.32 is supported

Entity Developer

The new extended properties Do Not Generate Serializable Attribute and Do Not Serialize are added for complex types in EF Core Model
The bug with applying the Generate Serializable Attributes and Serialization Library settings of the EF Core template to the generated complex types is fixed

10.0.0 30-Jun-22

.NET 6 compatibility.
macOS 11 Arm64 (or "Apple Silicon" or "Apple M1") support
Windows 11 is supported.
Visual Studio 2022 version 17.2 is supported.
Visual Studio 2022 version 17.3 Preview is supported.

Entity framework:

Entity Framework Core 6.0.5 is supported.
Entity Framework Core 5.0.17 is supported.
Entity Framework Core 3.1.25 is supported.

Entity Developer:

64-bit version of standalone Entity Developer application is added.
64-bit version of console Entity Developer application is added.

9.16.1434 25-Jan-22

Entity Developer

The behavior is changed: turning off the "Save connection to" option in Model Settings of EF Core Model wipes out connection string literal from the generated code

Entity Framework support

The SQL translation of the following class members used in LINQ query is supported in EF Core 3, EF Core 5, EF Core 6

static method IsNullOrWhiteSpace() of the String class
static property Today and instance property DayOfWeek of the DateTime class
static methods Sqrt(), Max(), Min(), Log(), Log10(), Sin(), Cos(), Tan(), Asin(), Acos(), Atan(), Atan2(), Sinh(), Cosh(), Tanh() of the Math class

The SQL translation of the following class members used in LINQ query is supported in EF Core 5 and EF Core 6:

static methods Abs(), Round(), Truncate(), Floor(), Ceiling(), Pow(), Sqrt(), Max(), Min(), Log(), Log10(), Sin(), Cos(), Tan(), Asin(), Acos(), Atan(), Atan2(), Sinh(), Cosh(), Tanh() of the MathF class

The SQL translation of the following class members used in LINQ query is supported in EF Core 6:

static method Log2() of the Math and MathF classes

Mapping of internet/intranet data type System.Uri to Oracle string data types is supported in EF Core 3, EF Core 5, EF Core 6
Mapping of network data types System.Net.IPAddress and System.Net.NetworkInformation.PhysicalAddress to Oracle string data types is supported in EF Core 5 and EF Core 6
Mapping of Oracle object types like MDSYS.SDO_GEOMETRY or Oracle user-defined object datatypes in a database to the OracleObject class in EF Core 3, EF Core 5, EF Core 6 is supported
The config.SpatialOptions.PreferSpatialOperators configuration option is added (default value is False) to provide the possibility of using spatial operators instead of functions from the SDO_GEOM package
The bug with auto savepoints enabled in EF Core 6 transactions is fixed
The bug with generating the "Value cannot be null" error when dropping indexes via Code-First Migrations in EF Core is fixed
The bug with a materialization used within the Let operator of LINQ query in EF6 is fixed
The bug with using .Contains with a collection within .Select of LINQ query in EF Core 2 is fixed

9.15.1410 21-Dec-21

The type converter of the OracleTimeStamp structure is improved for converting to/from DateTime and DateTimeOffset
The bug with declaring several functions or procedures in the WITH clause executed via the OracleScript class is fixed
The bug with AUDIT and NOAUDIT statements in the Direct mode is fixed

Entity Developer

The model validation is improved: the errors are generated for all entities with QueryType=True in EF Core Model when EF Core version=EF Core 1 in Model Settings
The bug with wrong automatic assigning QueryType=True for views added to EF Core Model, when EF Core version=EF Core 1 in Model Settings, is fixed
The bug with throwing System.NullReferenceException when saving the changed value of the "Save connection to" option in Model Settings of EF Core Model is fixed

Entity Framework support

Entity Framework Core 6.0.1 is supported
Entity Framework Core 5.0.13 is supported
Entity Framework Core 3.1.22 is supported
The config.SpatialOptions settings are supported in EF Core
NetTopologySuite 2.4.0 is supported in EF Core 3, EF Core 5, and EF Core 6
The bug with throwing the "Expression in SQL tree does not have type mapping assigned" error with NetTopologySuite in EF Core is fixed
The bug with generating the "Value cannot be null" error when adding or dropping FK via Code-First Migrations in EF Core is fixed
The bug with calling methods and properties of the Geometry class and its child classes, when the type member returns bool, with NetTopologySuite in EF Core is fixed
The bug with incomplete SQL generation by update-database -script when config.CodeFirstOptions.DropConstraintsByColumns=true in Entity Framework 6.4.4 is fixed
The bug with throwing ORA-00920 by the GeometryCollection.Intersects method when using NetTopologySuite spatial service in EF Core 5 is fixed
The bug with throwing ORA-00920 by the Geometry.Disjoint method when using NetTopologySuite spatial service in EF Core 3 and EF Core 5 is fixed
The bug with throwing the "Unexpected primitive type kind 'r'." error when using NetTopologySuite spatial service with a geometric constant in EF Core 3 and EF Core 5 is fixed

9.14.1382 09-Nov-21

Entity Developer

The bug with parsing discriminator value as string, even when its type is different, in TPH inheritance of EF Core Model is fixed

Entity Framework support

Entity Framework Core 5.0.12 is supported
Entity Framework Core 3.1.21 is supported
The bug with incomplete SQL generation by update-database -script in Entity Framework 6.4.4 is fixed

9.14.1369 21-Oct-21

Visual Studio 2019 Preview support is discontinued
The bug with throwing Devart.Common.LicenseException, when Devart.Data.Oracle.dll is embedded into a single file application, is fixed
The bug with InOut LOB parameters is fixed
The bug with applying .NET Standard licensing to .NET 6 projects is fixed

Entity Developer

The bug with launching Entity Developer after applying Windows 10 Update KB5006670 and Windows 11 Update KB5006674 is fixed

LinqConnect (formerly known as LINQ to Oracle)

The bug with parsing TypeName values in XML mapping generated by Visual Basic template is fixed

Entity Framework support

Entity Framework Core 5.0.11 is supported
Entity Framework Core 3.1.20 is supported
The implementation of config.CodeFirstOptions.TruncateLongDefaultNames in EF6 .NET Standard compliant assemblies is improved: the generated names are constant, independent on a current domain and workstation
The config.CodeFirstOptions.DropConstraintsByColumns configuration option is added (default value is False) to provide the possibility of dropping the existing foreign keys and indexes basing on the column names instead of constraint names
The bug with using DateTime.Now, DateTime.UtcNow, DateTimeOffset.Now within LINQ query in EF Core 5 is fixed

9.14.1353 28-Sep-21

The bug with a connection via a DNS name in an IPv6 network in the Direct mode using NuGet packages is fixed
The bug with ORA-12899 error when using parameters with an Oracle 12 server in the Direct mode is fixed
The bug with ORA-01461 error when using parameters with an Oracle 12 NLS_CHARACTERSET=WE8ISO8859P15 server in the Direct mode is fixed
The bug with the System.NullReferenceException error in Event objects when using parameters with an Oracle 12 server in the Direct mode is fixed
The bug with throwing ORA-01483 on Oracle Server 12.2 with NLS_CHARACTERSET = EE8MSWIN1250 when using parameters in the Direct mode is fixed

Entity Developer

The new property Validation Framework is implemented in the Data Transfer Object template for generating DataAnnotations attributes
The new option "Save connection to" is implemented in Model Settings of EF Core Model to provide the ability to store the connection string in "Model file", "Entity Developer storage", "Environment variable"
The new option "Enum Output" is added to the EF Core template to specify output for the generated enums
The new property Generate UnitOfWork Repository Properties (by default, True) is implemented in the Repository and Unit Of Work template of EF Core Model for accessing the collections of entities
The representation of one-to-one association with non-nullable properties on both ends is changed from 1 -> 1 to 0..1 -> 1 on a diagram in EF Core Model
The bug throwing "Unknown property 'DoNotSerialize'.", when complex types and VB.NET template are used in EF Core Model, is fixed
The bug with code generation for the Constrained option of Association Editor in the case of 0..1 -> 1 association in EF Core Model is fixed

Entity Framework support

Entity Framework Core 5.0.10 is supported
Entity Framework Core 3.1.19 is supported
Mapping of System.Decimal to Oracle NUMBER with specified precision and scale in EF Core 5 is supported
The definition of System.ICloneable is removed from .NET Framework assembly \Entity\EFCore3\Devart.Data.Oracle.Entity.EFCore.dll

9.14.1312 30-Jul-21

LinqConnect (formerly known as LINQ to Oracle)

The new methods IsNotDistinctFrom() and IsDistinctFrom() are added to the Devart.Data.Linq.SqlMethods class
The bug with using out parameters of a stored procedure, when Mapping Mode is set to File in Model Settings, is fixed

Entity Framework support

Entity Framework Core 5.0.8 is supported
Entity Framework Core 3.1.17 is supported
The bug with ignoring schema set for indexes via RenameIndex() operation of EF Core Code-First Migrations is fixed
The bug with missing N-prefix in the generated Unicode literal used in .Contains(), .EndsWith(), .StartsWith() within .Where() in EF6 is fixed

9.14.1298 08-Jul-21

Visual Studio 2019 version 16.11 Preview 2.0 is supported

Entity Developer

The behavior of the Regenerate Storage and Mapping functionality in EF Core Model is changed: the NOT NULL attribute of the column is reset to undefined now; after that, the behavior depends on the Nullable attribute of the class property only
The bug with applying the Default Precision and Default Scale values from Model Settings to the non-decimal data types by Update To Database Wizard in EF Core is fixed

Entity Framework support

Entity Framework Core 5.0.7 is supported
Entity Framework Core 3.1.16 is supported
The bug with comparing enum values in EF Core 3 and EF Core 5 is fixed
The bug with .Contains and .Length in EF Core 3 and EF Core 5, when using NetTopologySuite spatial functionality, is fixed
The bug with missing N-prefix in the generated Unicode literal used in .Contains(), .EndsWith(), .StartsWith() within .Where() in EF Core 3 and EF Core 5 is fixed

9.14.1273 03-Jun-21

The bug with ORA-03106 error in the Direct mode is fixed

Entity Developer

The new extended property Use Generic DbContextOptions Constructor Argument is added to model properties of EF Core Model
The new extended property Do Not Generate Constructor With DbContextOptions Argument is added to model properties of EF Core Model
The bug with generating the Equals method for entities with Record Type=True by C# EF Core template is fixed
The bug with cleaning values of Length and Precision/Scale column's attributes by Update From Database Wizard in EF Core Model is fixed
The bug with ignoring template's Validation Error Messages values in the generated code, when class property's Validate Expression is initialized and Validate Format is set to a non-default value, is fixed
The bug with creating app.config in Visual Studio .NET Framework projects, when the "Rewrite connection string during regeneration" option is turned off in Model Settings, is fixed

Entity Framework support

Entity Framework Core 5.0.6 is supported
Entity Framework Core 3.1.15 is supported
The EF6 provider registration used with .NET Framework compliant assemblies is improved: the [DbConfigurationType(typeof(OracleEntityProviderServicesConfiguration))] attribute set for DbContext descendant allows now calling the DbContext constructor, that accepts a connection string, with no need to register a custom IDbConnectionFactory implementation
The bug with connection recovery after the initial connection attempt failure in EF Core is fixed

9.14.1234 09-Apr-21

Entity Developer

The new hotkey Alt+E is implemented in Property Editor for opening Column Editor in EF Core Model
The bug with throwing "bufferAdapter is not a VsTextDocData" when saving a model in .NET Core, .NET Standard, .NET 5, .NET 6 projects of Visual Studio 2019 is fixed
The bug with missing .NET Framework, .NET Core 1, .NET Core 2 options for the Target Framework property in Model Settings of EF Core Model in a standalone Entity Developer is fixed
The bug with preserving Target Framework=.NET Framework in Model Settings of EF Core Model in a standalone Entity Developer is fixed

9.14.1228 01-Apr-21

Visual Studio 2019 version 16.10 Preview is supported
Additional mode of parameter substitution in the query in the SSIS Data Flow Source component: substitution as is, without escaping
The bug with a DateTime variable in the SSIS Source component is fixed
The bug with calling OracleObject.ExecuteMethod(), when OracleObject is created in application code without assigned attributes, is fixed
The bug with string conversion by OracleTimeStamp.ToString(), when .ToString() includes FF fractional seconds format and the database column is TIMESTAMP(0), is fixed
The bug with throwing AccessViolationException by OracleCommand.ExecuteScalar() in the OCI mode is fixed
The ORA-01483 and ORA-03120 errors on a server with NLS_CHARACTERSET=WE8MSWIN1252 are fixed (Direct mode)

Entity Developer

.NET 6.0 is added to the list of available Target Framework versions in Create Model Wizard and Model Settings in EF Core, EF6, LinqConnect models
The new extended property Record Type is added for classes in the case of C# EF Core template to generate records instead of classes in C# 9.0 or higher and .NET 5 or higher
The new options "Private setter for store generated properties" and "Constructor parameter" are added to Model Settings in EF Core for controlling visibility of setter for store generated properties
The new options "Don't show this message again" in the prompt window and "Prompt before generating code when there are model validation warnings" in the menu Options are implemented in a standalone Entity Developer to provide the ability not to stop code generation by warnings
The new extended property Do Not Generate Default Constructor is added to EF Core Model for model, classes, and complex types
The new extended property Do Not Generate Mapping is added to EF Core Model for class properties
The JSON (Newtonsoft.Json, Microsoft.Text.Json) and YAML (YamlDotNet) serializations are supported in EF Core (via EF Core template) and EF6 (via DbContext template):

The new template property Serialization Library is added for specifying the library used for serialization
The new template property Serialize Original Column Names is added for controlling the appearance of original column names in serialization
The new template property Serialize Navigation Properties is added for controlling the appearance of navigation properties in serialization
The new template property Serialize Null Value is added for managing the behavior of nullable properties
The new extended property Do Not Serialize is added for properties and navigation properties to exclude them from serialization
The new extended property Serialization Name is added for properties and navigation properties to set custom names in serialization

The Data Transfer Object template is improved:

The new template property Serialization Library is added for specifying library used for serialization, possible values are Data Contract, JSON (Newtonsoft.Json), JSON (Microsoft.Text.Json), YamlDotNet
The new extended property Do Not Serialize is added for properties and navigation properties to exclude them from serialization
The new extended property Serialization Name is added for properties and navigation properties to set custom names in serialization
The behavior is changed: WCF Data Contract Attributes is set to False by default now

The following properties are marked as obsolete:

the Generate Data Contracts property of the EF Core template
the Do Not Generate Data Contract Attribute extended property of navigation properties in EF Core Model
the WCF Data Contract Attributes property of the DbContext and Data Transfer Object templates
the WCF DataMember Attribute on Navigation Properties property of the DbContext and Data Transfer Object templates

The bug with creating app.config in Visual Studio .NET Core projects is fixed
The bug with detecting the existing classes with QueryType=True by Update From Database Wizard in EF Core Model is fixed

Entity Framework support

Entity Framework Core 5.0.4 is supported
Entity Framework Core 3.1.13 is supported
The bug with throwing ORA-00920, when using conditional operator within LINQ query, in EF Core 3 and EF Core 5 is fixed
The bug with inserts and updates, when property mapping includes DatabaseGeneratedOption, in EF Core 5 is fixed

9.14.1204 18-Feb-21

The new command line option /disablegac that disables adding assemblies to GAC is added
The bug with using OracleCommand.CommandTimeout in the OCI mode, when Oracle Client leaves an open session to failed RAC node, is fixed
The bug with character encoding in the Direct mode when InitialLobFetchSize is set is fixed
Wrong timezone setting when opening a connection in the Direct mode is fixed

Entity Developer

The behavior is changed in Entity Developer embedded into Visual Studio: lower versions in the EF Core version property of Model Settings are not hidden any more
The behavior is changed in EF Core Model: QueryType=True is set now for all classes without PK
C# code generation is improved: the using directives are generated instead of full namespaces in the names of attributes for DataAnnotations, NHibernate Validator, and Enterprise Library validation frameworks
Code generation is improved: OnModelCreating(modelBuilder) of the base class is invoked now if the Base Context Type property of EF Core Model is initialized

Entity Framework support

Entity Framework Core 5.0.3 is supported
Entity Framework Core 3.1.12 is supported
The bug with translating Enum.HasFlag to SQL in EF Core 3 and EF Core 5 is fixed
The bug with throwing ORA-00907, when using conditional operator within LINQ query, in EF Core 3 is fixed

9.14.1180 14-Jan-21

The bug with blocking thread during retrieving a connection from the pool, when connections from the same pool are used in several threads, is fixed
The bug with memory leak when running a lot of queries in the OCI mode is fixed

Entity Developer

The new attribute DisplayName is implemented for model objects' extended properties which are available via template properties
The new options --ContextNamespace and --DefaultNamespace are added to the Create-Model command of Console Entity Developer
The new extended model property Base Context Type is added for specifying a parent class for the generated context in EF Core Model
The new extended properties Base Type for complex types and Base Complex Type for model are implemented in EF Core Model
The %type name% keyword is supported in the Base Type extended property of entities and complex types, and in Base Complex Type, Base Entity Type, Base Context Type extended model properties for setting generic base type in EF Core Model
Code generation is improved: RelationalIndexBuilderExtensions.HasDatabaseName is generated now instead of RelationalIndexBuilderExtensions.HasName in EF Core 5
Display names of extended properties in EF Core Model are updated: Entity Base is renamed to Base Type in class properties, Entity Base is renamed to Base Entity Type in model properties, Context Base is renamed to Base Context Type in model properties
The bug with setting additional keyboard mapping scheme via menu Options on Windows with German display language is fixed

LinqConnect (formerly known as LINQ to Oracle)

The new property Local is added to the Table and Table<T> classes to return a collection of the entities attached to the context
The new method GetEntityState(object entity) is added to Table class and ITable interface to return one of the EntityState values
The bug with throwing "Bad key member '...' in association '...' of type '...'." in runtime by .NET Standard compliant assemblies is fixed

Entity Framework support

Entity Framework Core 5.0.2 is supported
Entity Framework Core 3.1.11 is supported
The new metadata to describe autoincremental columns via annotations in EF Core Code-First Migrations are implemented
The new config.DatabaseScript.Index.UseCurrentSchema option (default value is false) is added for ability to ignore schema set for indexes via EF Core Code-First Migrations
The behavior is changed: config.DatabaseScript.Index.UseCurrentSchema is set to false by default; as a result, the schema argument in CreateIndex(), DropIndex(), AddUniqueConstraint(), DropUniqueConstraint() operations is now applied not only to the table name, but also to the index name, i.e. previously, the index was always created in the current schema, and now it is created in the schema of the table to which the index belongs
The bug with ignoring schema set for indexes via CreateIndex(), DropIndex(), AddUniqueConstraint(), DropUniqueConstraint() operations of EF Core Code-First Migrations is fixed

9.14.1160 17-Dec-20

The bug with retrieving the TIMESTAMP WITH LOCAL TIME ZONE values in the TZR (time zone region) format in the Direct mode is fixed
The bug with throwing System.ArgumentOutOfRangeException, when OracleCommand.Prepare() has been called before and reader is reused with another query, in the Direct mode is fixed
The bug with throwing ORA-00918 by OracleCommand.ExecutePageReader(), when SQL query returns several columns with the same name in the case of multiple result sets/multiple tables or views/subqueries, in Oracle 12c or higher is fixed

Entity Framework support

Entity Framework Core 5.0.1 is supported
The bug with creating savepoints in EF Core 5 is fixed
The bug with throwing "Sequence contains no elements" on insert or update in EF Core 5 is fixed

9.14.1150 03-Dec-20

Visual Studio 2019 version 16.9 Preview is supported
The bug with throwing the ORA-01483 error when updating the VARCHAR2 column on Oracle 12.2 with NLS_CHARACTERSET=UTF8 in the Direct mode is fixed
The bug with updating projects that reference EF6 provider assembly via Upgrade Wizard is fixed

Entity Developer

The new features are supported in Entity Framework 5.0:

TPT inheritance
Many-to-many associations
The new types of properties IPAddress and PhysicalAddress

The Model Refactoring functionality is supported for classes in EF Core Model
The behavior is changed in a standalone Entity Developer: by default the Target Framework model property in EF Core Model is set to .NET 5 instead of .NET Framework
The bug with saving non-default value of Target Framework model property in EF6 model modified with a standalone Entity Developer is fixed
The bug with adding new arguments at the end of argument list instead of actual position in method signature by Update From Database Wizard is fixed
The bug with placing procedure with no parameters in the Procedures node instead of being enlisted in its package's node of Update From Database Wizard tree in the case of Oracle 18c and higher is fixed

Entity Framework support

Entity Framework Core 5.0 is supported
Entity Framework Core 3.1.10 is supported
The behavior is changed: EF Core 3 assemblies available via NuGet package are compiled for .NET Standard 2.0 instead of .NET Standard 2.1
The behavior is changed: EF Core 2 assemblies are no longer available via NuGet package but created in the provider installation folder
The bug with generating invalid SQL, when the sdo_geometry column is part of a subquery, in EF Core 3 is fixed
The bug with using another context's connection in DbContextOptionsBuilder.UseOracle(connection) in EF Core is fixed

9.13.1127 29-Oct-20

The bug with Visual Studio 2019 integration, when both v16.7 RTM and v16.8 Preview are installed on the same computer, is fixed
The bug with connecting to Oracle Real Application Clusters (RAC) in the Direct mode is fixed
The bug with missing Name and Owner properties of the OracleConnection class in .NET Standard compliant assemblies is fixed

Entity Developer

The bug with reading templates from *.edps by console Entity Developer is fixed

Entity Framework support

Entity Framework Core 3.1.9 is supported
The bug with incorrect SQL translation of .Contains with a collection of more than 1000 items in EF Core 3 is fixed
The bug with generating invalid SQL for EF.Functions.Like in EF Core 3 is fixed

9.13.1107 01-Oct-20

Visual Studio 2019 version 16.8 Preview is supported

Entity Developer

EF Core 3 spatial data types support is improved: in addition to Geometry and Geography, specific .NET NetTopologySuite types like GeographyPoint, GeographyLine are now available property types
The bug with throwing "EntityProperty does not contain a definition for IsSpatialType", when custom template from previous versions is used, in EF Core Model is fixed
The bug with applying On Delete Action=Cascade set in Association Editor to the Generate Database Script functionality in EF Core Model is fixed
The bug with reading settings from *.edps by console Entity Developer is fixed

Entity Framework support

The bug with throwing System.NullReferenceException by the Code-First CreateDatabase() / Code-First Migrations functionality in EF Core is fixed

9.13.1098 17-Sep-20

The new DescribeStoredProcedure property is added to the OracleConnection class
The SendCallStack property is added to the Devart.Common.DbMonitor class for possibility to turn off resource-demanding logging of CallStack
The Filter property is added to the Devart.Common.DbMonitor class for possibility to choose events being logged
The Devart.Common.DbMonitor class is improved: now values of the DateTime parameters sent to the dbMonitor tool are supplemented with milliseconds
The bug with updating projects in folders below the main project by Upgrade Wizard is fixed
The bug with detecting daylight saving time settings on a current workstation when reading the TIMESTAMP WITH LOCAL TIME ZONE values in the Direct mode is fixed
The bug with double shifting timezone when retrieving the TIMESTAMP WITH LOCAL TIME ZONE values in the Direct mode is fixed

Entity Developer

The error message in console Entity Developer is improved: now the text includes the list of all available templates if the specified name of template was incorrect
The bug with saving a new model, which has never been saved before, after some time of work in a standalone Entity Developer is fixed
The bug with generating mapping for the properties with Shadow=True in EF Core Model is fixed
The bug with using spatial types inside complex types in EF Core Model is fixed

Entity Framework support

Support for spatial data types in EF Core 3 is implemented
Entity Framework Core 3.1.8 is supported
The new NuGet package Devart.Data.Oracle.EFCore.NetTopolosySuite with a .NET Standard 2.1 assembly, that is compatible with .NET Core 3, is added
The new \Entity\EFCore3\Devart.Data.Oracle.Entity.EFCore.NetTopolosySuite.dll assembly compiled with EF Core 3.1 and .NET Framework 4.6.1 is added
The OracleFunctions class, which allows using Oracle-specific functions in LINQ to Entities, is supported in EF Core
The OracleTextFunctions class, which allows using Oracle full-text search functionality in LINQ to Entities, is supported in EF Core
The bug with generating invalid SQL when filtering on a boolean property that is assigned with .Any() in EF Core 3.1 is fixed
The bug with generating invalid SQL when filtering on a boolean property that is assigned with comparing to Count() in EF Core 3.1 is fixed

9.12.1064 30-Jul-20

The performance of fetching data in the Direct mode is improved
The bug with throwing "ORA-03106: fatal two-task communication protocol error" on SELECT queries in the Direct mode is fixed
The bug with opening database connection, when OS user name includes special symbols, in the Direct mode is fixed
The bug with loading the Int32 value into a NUMBER column using OracleLoader via Oracle Client 19 is fixed
The bug with calling stored procedure using OracleCommand.ExecuteArray() via Oracle Client v19.5 is fixed
The bug with throwing "Cannot convert object of type 'Devart.Data.Oracle.OracleLob' to object of type 'Devart.Data.Oracle.OracleIntervalYM'." in the Direct mode is fixed

Entity Developer

The bug with throwing System.NullReferenceException when opening *.edmx with invalid associations is fixed

9.12.1054 16-Jul-20

SSH is supported in the Direct mode

Entity Developer

The bug with detecting FK relationships to tables in other schemas by Create Model Wizard and Update From Database Wizard is fixed

LinqConnect (formerly known as LINQ to Oracle)

The "Could not find element type in model" bug when loading XML mapping in .NET Standard LinqConnect assemblies is fixed
The bug with using enums via .NET Standard compliant assemblies is fixed

Entity Framework support

The bug with incorrect SQL generation when using .Substring() in a .Select() statement in EF Core 2 is fixed
The bug with casting a non-nullable numeric to an Enum during materialization of LINQ query in EF Core is fixed
The bug with incorrect SQL generation when using .OrderBy() with comparison in EF Core is fixed

9.11.1034 17-Jun-20

Visual Studio 2019 version 16.7 Preview is supported
The bug with throwing System.OverflowException by OracleCommand.ExecuteArray(), when passing a large amount of data containing empty strings, in the OCI mode is fixed
The bug with executing REVOKE statement via OracleScript in the Direct mode is fixed
The bug with opening connection in the Direct mode via SSL/TLS is fixed
The bug with throwing "ORA-03106: fatal two-task communication protocol error", when OracleCommand.InitialLobFetchSize is set to non-zero value, in the Direct mode is fixed

Entity Developer

.NET 5 is added to the list of available Target Framework versions in Create Model Wizard and Model Settings in EF6, EF Core, LinqConnect models
The new option "Execute procedures for result set detection" is added to Model Settings of EF Core Model to control obtaining metadata of a procedure or function result set
The new option "Use NULL parameter values" is added to Model Settings of EF Core Model to specify whether NULL parameter values are used for stored procedure execution
The new option "Add complex types to diagram" is added to Model Settings of EF Core Model to control behavior of Create Model Wizard and Update Model From Database Wizard
The new option "Add new complex types to the current diagram" is added to Update Model From Database Wizard of EF Core Model
The new Primitive Default Value Generation property is added to EF, EF Core templates to determine whether to generate initialization for a primitive property based on database DEFAULT column value
The new property Collection Property Type is added to EF template "DbContext" and EF Core template "EF Core" to determine .NET type used as a property type for the Many end of associations
The new property Collection Initialization Type is added to EF template "DbContext" and EF Core template "EF Core" to determine .NET type used for initialization of the Many end of association; if it is set to None, then no initialization is generated
The new property "Nullable Reference Types" is added to C# templates of EF, EF Core models to specify whether C# 8 nullable reference types and non-nullable reference types must be generated
The new partial method is added to the OnModelCreating(DbModelBuilder modelBuilder) method generated by DbContext template of EF model
The EF Core model deserialization is improved: Entity Developer shows the full list of detected errors and tries to load the model with invalid elements or ignores such elements if their deserialization is not possible
Console Entity Developer improvements:

Import of stored procedures and functions via Create-Model command is supported
The new options --Procedures and --Functions are added to Create-Model command for filtering stored procedures and functions; by default all procedures/functions are imported
The new option --Execute is added to Create-Model command for executing procedures/functions to get metadata from result set
The asterisk symbol (*) is supported in --Tables and --Views parameters of Create-Model to include all objects
The bug with opening connection via some supported providers is fixed
The bug with enumerating values separated with comma and without whitespace in --Templates, --Schemas, --Tables parameters is fixed

The list of keywords and reserved words of Oracle being quoted by Entity Developer is updated
The DbProviderFactories registration is implemented in Create Model Wizard for EF6 models and .NET Framework provider assemblies
The new property Target Framework is added to Create Model Wizard and Model Settings of EF6 models
The compatibility issue with JetBrains ReSharper is fixed
The behavior is changed: the definition of auto-implemented property is put now on the single line with

C# DbContext template of Devart Entity Model when ImplementINotifyPropertyChanging=False and ImplementINotifyPropertyChanged=False and PropertyChangePartialMethods=False
C# EF Core template of Devart EF Core Model when PropertyChangeNotifiers=False and PropertyChangePartialMethods=False

The behavior for the new EF, EF Core models is changed: Primitive Default Value Generation is set to Literal now instead of LiteralOrExpression
The behavior is changed: the names of system types are generated without "System." prefix now in EF Core models; for example, it is DateTime instead of System.DateTime
The behavior is changed: only one confirmation for executing stored procedure is requested by Entity Developer when drag&drop-ing procedure from Database Explorer to Model Explorer or diagram surface
The behavior is changed: now the EF Core template generates an additional partial class for the context class when "File Per Class" and "Generate Partial Class" are set to True
The bug with detecting strings, being expressions, as string literals when generating initialization of string properties basing on database columns' default values in EF, EF Core models is fixed
The bug with detecting numbers, being quoted string literals, as strings when generating initialization of numeric properties basing on database columns' default values in EF, EF Core models is fixed
The bug with missing default value in the generated code basing on DEFAULT value in a database, when any of ImplementINotifyPropertyChanging, ImplementINotifyPropertyChanged, PropertyChangePartialMethods options of DbContext template in EF is turned on, is fixed
The bug with code generation for zero-or-one to zero-or-one association in the EF6 model with the DbContext template (Fluent Mapping=True) is fixed
The bug with detecting numeric and string literals, specified within round brackets, when generating initialization of properties basing on Oracle columns' default values in EF, EF Core models is fixed
The bug with generating .HasMany end of one-to-many association in EF Core Model is fixed
The bug with generating TPH mapping in EF Core 3 model is fixed
The bug with false appearing the "Table or view '...' has no primary key columns, and the entity key for the corresponding storage entity was calculated automatically from other fields." warning in the Error List window is fixed
The bug with generating new Guid() with Primitive Default Value Generation=Literal in EF, EF Core models is fixed

LinqConnect (formerly known as LINQ to Oracle)

The bug with materializing elements, the types of which are explicitly converted from non-nullable to nullable on the client side, is fixed
The bug with incorrect detection of altered column comment in a many-to-many association join table by Update From Database Wizard is fixed

Entity Framework support

Entity Framework 6.4.4 is supported
The translation of the DateTime.AddMinutes() method in LINQ query into SQL statement in EF Core is supported
The EF6 provider registration used with .NET Standard compliant assemblies is improved: the [DbConfigurationType(typeof(OracleEntityProviderServicesConfiguration))] attribute set for DbContext descendant allows now calling the DbContext constructor, that accepts a connection string, with no need to register a custom IDbConnectionFactory implementation
The bug with adding / subtracting DateTime and TimeSpan, DateTimeOffset and TimeSpan values in LINQ query in EF Core 3 is fixed
The bug with using Scaffold-DbContext in EF Core and EDM Wizard in EF with more than 1000 tables/views is fixed
The bug with the opposite order of operands in case of less than, more than operators in the Where clause of LINQ query in EF Core 3 is fixed
The bug with including several subcollections in LINQ query in EF 6.4 is fixed
The bug with throwing "ORA-00907: missing right parenthesis" with Expression.Or, Expression.And in EF Core 3.1 is fixed
The bug with SQL generation in EF Core 3, when enum values are used in CASE and COALESCE statements, is fixed

9.11.980 02-Apr-20

The new connection string parameter SSL Key is added
The bug with using the following parameters of connection.GetSchema("Arguments", ...) is fixed

connection.GetSchema("Arguments", new string[] { "schema_name", null })
connection.GetSchema("Arguments", new string[] { "schema_name", "%" })
connection.GetSchema("Arguments", new string[] { "schema_name", "package_name", "procedure_name" })
connection.GetSchema("Arguments", new string[] { "schema_name", null, "procedure_name" })

The bug with calling OracleDataReader.IsDBNull() for a NULL value got from the ANYDATA column is fixed
The bug with defining functions and procedures in the view body specified in OracleScript.ScriptText for Oracle 12c and higher is fixed

LinqConnect (formerly known as LINQ to Oracle)

The insert of the object, the type of which is an unmapped class inherited from a mapped class, is supported
The bug with throwing System.NullReferenceException, when constructing the error saying that unmapped class is not supported, is fixed

Entity Developer

Command-line interface is implemented in a standalone Entity Developer
The new property Context Name is added to Model Properties in EF Core Model
The new property Target Framework is added to Model Properties in EF Core Model
The provider registration is improved: requirement to put provider registration entry in the config file is not obligatory anymore
Create Model Wizard is improved: now it allows installing multiple NuGet packages on the final step
Model file tree in .NET Core / .NET Standard projects is improved: all generated code files and model files are nested under the same node in Solution Explorer

Entity Framework support

Entity Framework Core 3.1.3 is supported
The .ToString() call for numbers, DateTime/DateTimeOffset properties and values in LINQ queries in EF Core is supported
The call of Convert.ToString(value) in LINQ queries in EF Core is supported
The bug with using collections with more than 1000 items in a .Contains() method in EF Core 3 is fixed
The bug with the AlterColumn operation in EF Core Code-First Migrations, when data type is being changed but oldType is not specified, is fixed
The bug with generating EXCEPT instead of MINUS in SQL produced by EF Core 3.1 is fixed

9.11.951 20-Feb-20

SQL Server Integration Services 2019 (SSIS 2019) is supported
SSL/TLS is supported in the Direct mode
The new connection string parameters SSL Cert and SSL Server CertDN are added
The new properties WalletMethod and WalletLocation are added to the DirectUtils class
The new class OracleCredential is implemented to provide a more secure way to specify the password while opening connection in the OCI mode on Windows
The new overload OracleConnection(string connectionString, OracleCredential credential) is added
The new overload ChangePassword(SecureString newPassword) is added
The new property DefaultExpressionCacheSize (by default, 100) is added to the OracleLoader class to specify the number of default expressions that are evaluated at a time
The new property DefaultExpressionBehavior is added to the OracleLoader class to specify how the direct path API handles default expressions for columns that are not explicitly being loaded
OCI Multiple Homes is supported in .NET Standard 2.1
The OracleDataTable and OracleDataSet classes are supported in .NET Standard 2.0/2.1
Connection pool performance counters are supported in .NET Standard 2.0/2.1
.NET Standard 2.1 compatible assembly is added to the Devart.Data.Oracle NuGet package
The new class OracleShardingKey is implemented to store one or more key values for sharding in the OCI Session Pooling mode with Oracle Client 12g Release 2 and higher
The new methods SetShardingKey(OracleShardingKey shardingKey) and SetShardingKey(OracleShardingKey shardingKey, OracleShardingKey superShardingKey) are added to the OracleConnection class
Query Result Change Notification (QRCN) is supported
The new column QueryId is added to DataTable stored in OracleNotificationEventArgs.Details
The new properties GroupingNotificationEnabled, GroupingType, GroupingInterval are added to the OracleNotificationRequest class
The new properties RegisteredQueryIds, RegisteredResources, RegId are added to the OracleDependency class
The new connection mode OracleConnectMode.SysRac is supported for managing Real Application Clusters in Oracle Server 12c Release 2 and higher
The new property OracleUtils.ParameterValueTrimming (by default, false) is added to trim value that exceeds OracleParameter.Size
The behavior is changed: OCIStmtPrepare2() is used now instead of OCIStmtPrepare() in the OCI mode to support the use of Application Continuity in an HA infrastructure
The behavior is changed: pool is automatically cleared when AppDomain is being closed
The bug with inserting Unicode N-prefixed string literal when using the "Unicode=true" connection string parameter in the Direct mode is fixed
The bug with getter of OracleParameter.OracleValue, when it returns an empty array, is fixed
The bug with initializing NHibernate configuration on .NET Standard 2.0 is fixed

LinqConnect (formerly known as LINQ to Oracle)

The bug with case insensitive comparison via string.Compare() is fixed

Entity Developer

The bug with returning multiple result sets in code generated by the EF Core template is fixed

Entity Framework support

Entity Framework Core 3.1.1 is supported
The bug with using a discriminator in EF Core 3 is fixed
The bug with querying types in inheritance hierarchy via EF Core 3 is fixed
The bug with generating a subselect within the CASE clause in EF Core 3 is fixed
The bug with using .All in the .Where expression in EF Core 2 and EF Core 3 is fixed
The bug with detecting string parameter data type in EF Core 3 expressions is fixed
The bug with paging in EF Core 3, when using JOINs and subqueries to Oracle 11.2 and below, is fixed
The bug with missing GENERATED BY DEFAULT AS IDENTITY in the script created by EF Core Migrations for the property with .HasColumnType(@"NUMBER").ValueGeneratedOnAdd() is fixed
The bug with using nullable enum properties with default mapping to integers in LINQ query in EF Core 3.1 is fixed
The bug with using value converters detected automatically by .HasConversion<string>() in EF Core 3 is fixed
The bug with using NULL constant values in EF Core 3 is fixed
The bug with using binary operators AND, OR in EF Core 3 is fixed

9.10.909 23-Dec-19

Visual Studio 2019 version 16.5 Preview is supported
The bug with using the OracleDbType.VarChar parameter with length greater than 1333 symbols on Oracle 12.1 with NLS_CHARACTERSET=AL32UTF8 in the Direct mode is fixed
The bug with using Toolbox component OracleDataSource in web projects of Visual Studio 2013, 2015, 2017, 2019 is fixed
The bug with enabling Devart DataSet Editor in Visual Studio 2017 and Visual Studio 2019 is fixed

LinqConnect (formerly known as LINQ to Oracle)

The bug with using Toolbox component DbLinqDataSource in web projects of Visual Studio 2013, 2015, 2017, 2019 is fixed

Entity Developer

The 12cR2 option is added to the list of available Oracle versions in Model Synchronization Settings
The bug with truncating long names to 30 symbols for Oracle Server 12.2 and higher by Update To Database Wizard / Generate Database Script Wizard is fixed
The bug with creating one-to-one association basing on an optional FK in EF Core Model is fixed
The bug with code generation for oneOrZero-to-one and one-to-many associations based on an optional FK in EF Core Model is fixed
The bug with generating a mapping for a unique constraint specified in owned type property of EF Core Model is fixed

Entity Framework support

Entity Framework 6.4 is supported
Entity Framework Core 3.1 is supported
Views are supported via Scaffold-DbContext in EF Core 3
The new \Entity\EFCore3\Devart.Data.Oracle.Entity.EFCore.dll assembly compiled with EF Core 3.1 and .NET Framework 4.6.1 is added
The new config.CodeFirstOptions.TruncateAllLongNames option (default value is False) is added to use EF Core 2/EF Core 3 implementation for truncating long names of columns and PK/FK/IX/UX
The config.DatabaseScript.ForeignKey.IndexCreation configuration option is supported in EF Core 1/EF Core 2/EF Core 3
The config.DatabaseScript.ForeignKey.IndexTablespace configuration option is supported in EF Core 1/EF Core 2/EF Core 3
The bug with creating a unique constraint in the database via EF Core Code-First Migrations is fixed
The bug with throwing System.NullReferenceException on SaveChanges() when inserting a new entity with value generated by the database in EF Core 3 is fixed
The bug with applying .ValueGeneratedOnAdd() to the string, guid, byte[] properties with .Key() and without .HasDefaultValueSql() in EF Core is fixed
The bug with redundant CASTs when working with NUMBER, DATE and TIMESTAMP columns in EF Core 1/EF Core 2 is fixed
The bug with detecting implicit database column type, when model mapping and migration mapping are different, via EF Core Code-First Migrations is fixed
The bug with generating SQL when using explicit cast in LINQ queries in EF Core 1/EF Core 2 is fixed
The bug with throwing the "Null TypeMapping in Sql Tree" error by methods in LINQ query in EF Core 3 is fixed

9.9.887 21-Nov-19

The "Optimize rendering for screens with different pixel densities" feature of Visual Studio 2019 is supported by Devart DataSet Editor

Entity Developer

The Self-Contained Entity Configuration property is added to VB.NET version of EF Core template
The Entities Configuration Output property is added to VB.NET version of EF Core template
The code generation for the class properties with Alternate Key=True by VB.NET version of EF Core template is supported in EF Core model
The bug with code generation, when Raw SQL Query is initialized in class properties, in EF Core 3 model is fixed
The bug with generating .HasNoKey(), when Self-Contained Entity Configuration is set to True in properties of EF Core template, in EF Core 3 model is fixed
The bug with generating alternate keys, when Self-Contained Entity Configuration is set to True in C# version of EF Core template, in EF Core model is fixed

Entity Framework support

The config.DatabaseScript.PrimaryKey.IndexTablespace configuration option is added to specify the tablespace for implicit PK indices created via the Code-First approach
Support for changing NULL/NOT NULL constraint for LOB columns in the AlterColumn operation of EF Core Code-First Migrations is added
The SQL generation in case of config.QueryOptions.UseCSharpNullComparisonBehavior=true in EF1/EF4/EF5/EF6 is improved
The bug with using Scaffold-DbContext in EF Core 3 is fixed
The bug with the redundant empty ORDER BY clause in a subquery, when paging is used, in EF Core 3 is fixed
The bug with generating invalid SQL when calling members of owned type in EF Core 2 is fixed
The bug with throwing "ORA-12704: character set mismatch" in case of UNION ALL over OUTER APPLY/CROSS APPLY in EF1/EF4/EF5/EF6 is fixed
The bug with using .Contains within .Select of LINQ query in EF Core 2 is fixed

9.9.872 31-Oct-19

Visual Studio 2019 version 16.4 Preview is supported
Long object names support in Oracle 12.2 and higher is added
The bug with calling overloaded stored procedures and functions is fixed

Entity Developer

The DbContext template is improved: precision and scale for database types are generated now in EF4/EF5/EF6 models when Fluent Mapping=True and Mapping Generation Strategy=UseAttributes
The bug with throwing the EntityFrameworkCoreVersion error in Create Model Wizard in a standalone Entity Developer is fixed
The bug with incorrect detecting DatabaseGeneratedOption.Identity for the properties with DEFAULT NULL in a database, when "Detect function-based column default value" is selected in Create Model Wizard, is fixed in EF4/EF5/EF6

Entity Framework support

Entity Framework Core 2.2.6 is supported

9.9.867 24-Oct-19

The "Optimize rendering for screens with different pixel densities" feature of Visual Studio 2019 is supported by Devart DataSet Manager
The bug with executing stored procedure or function with Out/InOut parameter, when its type is CHAR and the parameter precision is determined by the length of a target column, is fixed

Entity Developer

The DbContext template is improved for using Entity Framework 6.3:

The "Configuration Type Name" property, which specifies the descendant of DbConfiguration class that should be used for code-based configuration, is added
The "Use DbConfigurationType Attribute" property, which determines whether to register the configuration type specified in the ConfigurationTypeName property of the DbConfigurationType attribute, is added
The DbProviderFactories.RegisterFactory method is generated when UseDbConfigurationTypeAttribute=true and ConfigurationTypeName='%Default%'
With UseDbConfigurationTypeAttribute=false, the static constructor for registering factory and the new partial method OnStaticConfigured are generated

The "Optimize rendering for screens with different pixel densities" feature of Visual Studio 2019 is supported
The compatibility issue with JetBrains ReSharper is fixed

Entity Framework support

Entity Framework Core 3.0 is supported
Entity Framework 6.3 is supported
The lock for Microsoft.EntityFrameworkCore dependency is added to the NuGet package Devart.Data.Oracle.EFCore

9.8.838 12-Sep-19

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

9.7.805 25-July-19

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

9.7.790 04-July-19

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

Entity Developer

The ability to disable generation of the byte order mark (BOM) in the beginning of code files in a standalone Entity Developer is implemented
The bug with design time copy/cut/paste functionality for entities is fixed
The bug with invalid integer to enum conversion by a generated method, which is based on SQL query and returns a collection of entities, in EF Core 2 is fixed

Entity Framework support

The bug with applying a filter to the nullable property with implicit EnumToStringConverter via LINQ queries in EF Core 2 is fixed
The bug with missing brackets around SELECT inside the generated CASE statement in EF Core 2 is fixed
The bug with nullable parameters in EF Core 2 is fixed
The bug with reopening connections in EF Core 2 is fixed
The bug with incorrect exception message on opening connection, when ConnectionString is not set, by .NET Standard compliant assemblies is fixed
The bug with generating SQL query for paging operations with .GroupBy() in EF Core 2, when working with Oracle 11g/10g/9i, is fixed

9.7.770 06-Jun-19

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

9.7.734 11-Apr-19

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

9.6.725 28-Mar-19

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

9.6.696 14-Feb-19

The ChangePassword functionality is supported for Oracle 12c in the Direct mode
The bug with using OracleParameter with OracleDbType.Long for a Long column in Oracle 12.2.0.1 in the Direct mode is fixed
The bug with using the 'Q' literal when ParameterCheck is true, is fixed
The bug with OracleLoader.LoadTable(IDataReader) for .NET Standard 1.3 and .NET Standard 2 is fixed

LinqConnect (formerly known as LINQ to Oracle)

The bug with executing incorrect SQL request (cached during one of the previous calls), when .Contains() is invoked in the multithreaded application, is fixed

Entity Developer

The bug with generating fluent mapping for the one-to-one association by the DbContext template in EF4/EF5/EF6 is fixed

Entity Framework support

The translation of single-char literal into SQL statement in EF Core is supported
The bug with using .FirstOrDefault() against Oracle Server 10.2 is fixed
The bugs with constructing the COALESCE clause in EF Core 2 are fixed
The bug with projecting the pagination column into the outer query for Oracle 11 and below in EF Core is fixed
The bug with using value converters in the Code-First CreateDatabase() functionality via EF Core 2.2 is fixed
The bug with paging in EF Core 2.2, when connecting to Oracle 11.2 and below, is fixed
The bug with using a value converter for the property used in .Contains() in EF Core 2 is fixed
The bug with translating String.IndexOf() into SQL statement in EF Core is fixed
The bug with updating a null value of the concurrency check column with some non-null value in EF Core is fixed
The bug with sorting by CLOB/NCLOB column in EF Core is fixed
The bug with throwing Devart.Common.LicenseException when using config.Workarounds.ProviderManifestToken in EF Core is fixed

9.6.675 10-Jan-19

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 for the CreateTable operation 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

9.6.646 29-Nov-18

Implicit statement results are supported for Oracle 12c in the Direct mode
Returning of affected row count for each array element when using array binding in the Direct mode for Oracle 12c is supported
The implementation of OracleCommand.CommandTimeout in the Direct mode is improved: now the provider sends Break to Oracle Server instead of closing TCP/IP socket
The list of supported cryptographic algorithms, that are available in the Direct mode, is extended in .NET Standard 2 compliant assemblies
The behaviour is improved: now the ORA-01013 error is generated instead of ORA-03113 after command timeout is reached in the Direct mode
The bug with not working OracleDataTable RefreshRowMode values except the default None value when a column has an alias is fixed
The bug with not working command timeout for some long running queries with user-defined functions in the OCI mode is fixed
The bug with reading INTERVAL DAY TO SECOND value via out parameters, created by OracleCommandBuilder for OracleDataTable, incorrectly, without taking into account the actual precision of hours and seconds, is fixed
The bug with generating SQL by Roles.AddUserToRole in ASP.NET 2.0 is fixed

LinqConnect (formerly known as LINQ to Oracle)

The bug with throwing "Operation could destabilize the runtime." during materialization of result set, when query includes a cast to the base unmapped class, is fixed

Entity Developer

The new Generate GeneratedCode Attributes option (by default, False) is added to the DbContext template in EF4/EF5/EF6 and the EF Core template
The new Generate Dummy Comments option (by default, False) is added to the DbContext template in EF4/EF5/EF6
The code formatting is fixed in the DbContext template in EF4/EF5/EF6 and the EF Core template
The code generation of a default value for the String property mapped to the column with a default value, that contains a unicode literal with N-prefix, is supported in EF and EF Core
The code generation of DateTime.UtcNow for the DateTime property mapped to the column with the default value SYS_EXTRACT_UTC(CURRENT_TIMESTAMP) or SYS_EXTRACT_UTC(SYSTIMESTAMP) is supported in EF and EF Core
The code generation of DateTimeOffset.UtcNow for the DateTimeOffset property mapped to the column with the default value SYS_EXTRACT_UTC(CURRENT_TIMESTAMP) or SYS_EXTRACT_UTC(SYSTIMESTAMP) is supported in EF and EF Core
The bug with generating fluent mapping for the TPC inheritance by VB.NET version of DbContext template in EF4/EF5/EF6 is fixed

Entity Framework support

The bug with quoting the table alias, that includes an invalid character, in the SQL query generated by EF Core is fixed
The bug with generating a subquery within the IN clause in EF Core 2 is fixed
The bug with generating a subselect within the CASE clause in EF Core 2 is fixed
The bug with comparing columns, that use a value converter, to parameters and constants in EF Core 2 is fixed
The bug with throwing "ORA-00936: missing expression" in EF Core is fixed
The bug with using parentheses in binary expressions in EF Core is fixed
The bug with loading both Devart.Data.Oracle.Entity.EF4.dll and Devart.Data.Oracle.Entity.EF5.dll in the process of EF4 application is fixed

9.6.621 25-Oct-18

The bug with truncating time for DATE columns in a SSIS package is fixed

LinqConnect (formerly known as LINQ to Oracle)

The bug with updating the existing entities that participate in FK associations is fixed in .NET Standard 2 compliant assemblies
The bug with filtering by the DateTimeOffset property is fixed

Entity Developer

The bug with throwing "Custom tool error: bufferAdapter is not a VsTextDocData" in .NET Standard projects is fixed

Entity Framework support

Entity Framework Core 2.1.4 is supported
The bit-wise functions OR, AND in EF Core are supported
The bug with throwing "Collection was modified; enumeration operation may not execute" by EF Core provider in multithreaded applications is fixed
The bug with removing an empty __EFMigrationsHistory table by EnsureDeleted() in EF Core is fixed
The bug with inserting data into XMLTYPE column via EF Core is fixed

9.6.597 20-Sep-18

The more detailed error text about unsupported data type when working with parameters and when loading data via the OracleLoader class is supported
Establishing a connection in the Direct mode when the Server connection parameter contains DESCRIPTION_LIST is improved
The bug with absent Devart.Data.Oracle.NHibernate.NHibernateOracleConnection and Devart.Data.Oracle.NHibernate.NHibernateOracleCommand classes in the .Net Core NuGet package is fixed
The bug with InitialLobFetchSize not applied when a result set is returned as a cursor from a stored procedure or function or when a SELECT statement returns a nested cursor is fixed
The bug with freezing when describing a procedure on Oracle 18c is fixed
The bug with the ORA-64219 error when a CLOB parameter is used in the Direct mode for Oracle 18c is fixed
The bug with the ORA-01461 error when a LONG parameter is used in the Direct mode for Oracle 12 is fixed
The bug with the ORA-03106 error when assigning a value to the OracleCommand InitialLobFetchSize property in the Direct mode is fixed
The bug with the error when reading a char primary key from Oracle 9.2 when the "Unicode=true" connection string parameter is used in the Direct mode is fixed
The bug with the error when connecting to Oracle 8.1.7 in the Direct mode is fixed

Entity Developer

Using an extended property of type OutputInfo is supported
Code generated for nullable properties is simplified: now T? is generated instead of System.Nullable<T>
An additional constructor that accepts DbContextOptions as an argument is added to the DbContext class descendant in the VB.NET version of the DbContext template for EF Core
The bug with "No database provider has been configured for this DbContext." in the DbContext template for EF Core is fixed
The bug with code generation for nullable properties for EF1/EF4/EF5/EF6 is fixed

Entity Framework support

Entity Framework Core 2.1.3 is supported
The bug with throwing an error by context.Database.Migrate(), when the __EFMigrationsHistory table already exists but tables being mapped by model classes are not created yet, in EF Core 2 is fixed
The bug with a memory leak in EF Core 2, when a connection is set for DbContext as an OracleConnection instance, and not via a connection string, is fixed
The bug with creating database objects in the same schema by several EF Core contexts in Code-First approach is fixed

9.6.584 30-Aug-18

The returning of the actual number of records, processed by the ExecuteArray and ExecuteNonQuery methods is supported in the Direct mode for a MERGE query
The bug with throwing "ORA-02089: COMMIT is not allowed in a subordinate session" when working with distributed transactions in the OCI mode via .NET Standard 2 assemblies is fixed
The bug with describing synonym of a stored procedure in OracleCommand with CommandType.StoredProcedure is fixed
The bug with OracleObject having the ANYDATA attribute is fixed

Entity Developer

The bug with setting password as clear text in connection string when "Persist Security Info=False;" is fixed
The bug with creating and opening the model in .NET Core project after VS 2017 upgrade to v15.8 is fixed (Entity Framework, LinqConnect)

Entity Framework support

Entity Framework Core 2.1.2 is supported
The misleading "The current provider does not support ambient transactions." warning, generated by TransactionScope in EF Core 2.1, is disabled
The bug with the DropPrimaryKey operation, when the schema name of a table is set via a separate Schema parameter, in EF Core Code-First Migrations is fixed
The bug with using Scaffold-DbContext against multicolumn PK, FK, IX, UX in EF Core 2 is fixed
The bug with using collections with more than 1000 items in a .Contains() method in EF Core 2 is fixed
The bug with missing projected column in the result SQL query generated by EF Core 2.1 provider is fixed
The bug with using non-initialized nullable properties in data seeding in Code-First Migrations in EF Core 2 is fixed

9.6.570 09-Aug-18

Entity Framework support

The new static method SetDefault is added to the EntitySpatialServices class in EF5/EF6
The performance in case of the CROSS APPLY/OUTER APPLY operations is improved: only one database query is sent to the server now instead of many SELECTs with executing part of operations locally
The behavior is changed: the default value of config.QueryOptions.UseCSharpNullComparisonBehavior is true now in EF Core
The bug with the IS NULL clause in SELECT projection in EF Core is fixed
The bug with quoting a stored function name, when the FunctionName argument of the DbFunction attribute includes package and/or schema names, in EF Core 2 is fixed
The bug with using the RenameIndex operation, when index name exceeds a max length allowed by the server and has to be transformed to a shorter name, in EF Core Code-First Migrations is fixed
The bug with incorrect generation of shortened PK/FK/IX/UX names in EF Core when using .NET Standard provider assemblies is fixed
The bug with using ORDER BY to sort by constant or parameter instead of column in EF Core is fixed
The bug with SQL generation for comparing column with parameter in EF Core 2 is fixed

9.6.558 19-Jul-18

The IDbColumnSchemaGenerator interface and the OracleDataReader.GetColumnSchema() method are implemented in .NET Standard provider assemblies
The bug with retrieving TIMESTAMP WITH TIMEZONE values with negative timezone in the Direct mode is fixed
The bug with reseting values of the OracleConnection PassParametersByName, TrimFixedChar, and NumberMappings properties when another property is assigned is fixed
The bug with the DeriveParameters method of OracleCommandBuilder when command text includes a colon character in a string literal, quoted using the alternative quoting mechanism is fixed
The bug with the DeriveParameters method of OracleCommandBuilder when command text includes a commented colon character after a tab character is fixed

Entity Framework support

The bug with paging in EF Core 2.1 is fixed
The bug with using the aggregate functions in EF Core 2.1 is fixed
The bug with processing arguments of functions mapped via .HasDbFunction in EF Core 2 is fixed
The bug with applying a filter with implicit EnumToStringConverter via LINQ queries in EF Core 2 is fixed
The bug with using the String.CompareTo method via LINQ queries in EF Core is fixed
The bug with applying aliases in the generated SQL, when config.Workarounds.DisableQuoting is set to true, in EF Core is fixed

9.6.540 21-Jun-18

The bug with using the OracleDbType.TimeStampTZ parameter when working with Oracle 12.1 in the Direct mode is fixed
The bug with the "Index was outside the bounds of the array" error when an attempt to establish a connection in the Direct mode failed is fixed
The bug with creating a package via Package Wizard when a procedure from this package has a parameter of ANYTYPE type is fixed

Entity Developer

Entity Framework Core 2.1 is supported

Query type support is added: classes now have the Query Type property, and if it is set to true, this class is generated as a query type
Lazy loading for Entity Framework Core 2.1 is supported:

Model now has the Use Lazy-Loading Proxies property, which enables lazy loading on the model level
Navigation properties now have the Lazy property, which enables lazy loading for a specific navigation property

Properties now have the Constructor Parameter property, for configuring a parameterized constructor of the class

The "Include Environment Variables" property, determining whether context configuration will be extended with environment variables when a connection string from the appsettings.json file is used, is added to the EF Core template
The "Json File Base Path" property, specifying the base path for file-based providers when a connection string from the appsettings.json file is used, is added to the EF Core template

Entity Framework support

Entity Framework Core 2.1.1 is supported
The bug with the "ORA-00923: FROM keyword not found where expected" error in EF Core 2 is fixed
The bug with applying the updated provider behavior after changing connection string options in EF Core 2 is fixed
The bug with generating incorrect SQL when using IndexOf expression in EF Core is fixed

9.5.520 24-May-18

The returning of the actual number of records, processed by the ExecuteArray and ExecuteNonQuery methods is supported in the OCI mode for a MERGE query

LinqConnect (formerly known as LINQ to Oracle)

A destructor for DataContext is added

Entity Framework support

Entity Framework Core 1.1.5 is supported
Entity Framework Core 2.0.3 is supported
The generation of the idempotent script in EF Core 2 Code-First Migrations is supported
The behavior is changed: now the EF Core Code-First Migrations script checks the existence of the MigrationHistory table not to try to create it if not necessary
The bug with the "ORA-00920: invalid relational operator" error in the WHERE clause in EF Core 2 is fixed
The bug with missing Devart.Data.Oracle.Entity namespace in *.Designer.cs generated by EF Core 2 Code-First Migrations via Devart NuGet package is fixed
The bug with the DateTime? properties, when config.CodeFirstOptions.UseDateTimeAsDate is set to True, in EF Core is fixed

9.5.502 27-Apr-18

The bug with opening connection by .NET Standard 2.0 compliant assemblies on Linux is fixed

Entity Developer

The new Controller Area extended class property is added to EF Core Model (Entity Framework models)
The check of conditions for setting optionsBuilder.Use... in the generated OnConfiguring method by the EF Core template is improved (Entity Framework models)

Entity Framework support

The bug with the AlterColumn operation for the column named SCOPE is fixed in EF6 / EF Core Code-First Migrations
The bug with generated LIKE operator within CASE statement in EF Core 2 is fixed
The bug with generating the CASE clause, that returns a Boolean value, in EF Core is fixed
The bug with sorting by CLOB/NCLOB columns in EF Core is fixed
The bug with retrieving the DateTimeOffset and TimeSpan data in EF Core is fixed

9.5.483 29-Mar-18

Sending AUTH_TERMINAL, AUTH_PROGRAM_NM, AUTH_MACHINE, and AUTH_SID information in the Direct mode for .NET Core 2.0 applications is supported
RAC connection in the Direct mode is improved
The behavior is changed: the License Key connection string parameter value is not sent to the dbMonitor instance when "Persist Security Info=false;"
The bug with changing a type of a command parameter and re-executing the command in the Direct mode is fixed
The bug with loading LOB data with length greater than 32767 via OracleLoader in the Direct Path Load mode is fixed
The bug with executing the GRANT statement in the Direct mode is fixed
The bug with throwing the "IDE not supported" exception by DataSet Manager in Visual Studio 2017 of versions 15.6.* is fixed
The bug with reading strings with a zero length by OracleDataReader in the Direct mode is fixed

LinqConnect (formerly known as LINQ to Oracle)

The XmlMappingSource.FromResource method is supported in .NET Standard provider assemblies
The behavior is changed: all existing overloads of the method DataContext.Query() are replaced with DataContext.Query(String,params Object[])
The behavior is changed: the License Key connection string parameter value is not sent to the LinqMonitor instance when "Persist Security Info=false;"

Entity Developer

The new SQL Type, Size, Precision, Scale options are added to the Parameters tab in Method Editor of EF Core Model (Entity Framework models)
The process of synchronizing methods and parameters with database stored procedures in EF Core Model is improved (Entity Framework models)
The bug with adding entry to appsettings.json, when "Use the following connection string from App.Config" and "Rewrite connection string during regeneration" in Model Settings are turned on, is fixed (Entity Framework models)
The bug with throwing the "Multiple constructors accepting all given argument types have been found in type '...'. There should only be one applicable constructor." error by the code generated with the MVC Controller template in ASP.NET Core Web Application is fixed (Entity Framework models)
The bug with missing DataMember attribute on the Many end of an association, when using the EF Core template with "Generate Data Contracts=True", is fixed (Entity Framework models)
The bug with the Retrieve Data functionality on the base class of TPH inheritance is fixed
The bug with the Find Next functionality of T4 Editor embedded into Visual Studio is fixed
The bug with throwing the "IDE not supported" exception by Entity Developer in Visual Studio 2017 of versions 15.6.* is fixed

Entity Framework support

Entity Framework Core 2.0.2 is supported
The new overload of the OracleJsonFunctions.ValueAs... methods is added for turning off generation of the RETURNING clause
The bug with missing aliases in SQL generated by EF Core 2 engine for Oracle 12.1 is fixed
The bug with throwing the "Index was outside the bounds of the array." error in EF Core 2 is fixed

9.5.454 15-Feb-18

The bug with the error in the OracleDataReader.GetSchemaTable method when table name in Oracle 12c Release 2 is longer than 30 characters is fixed
The bug with RAC connection in the Direct mode is fixed

LinqConnect (formerly known as LINQ to Oracle)

The bug with throwing MethodAccessException by .NET Standard provider assemblies when referencing them to a project, targeting Full .NET Framework, is fixed

Entity Developer

Support for ASP.NET Core MVC is added to the Data Annotations Metadata template (Entity Framework models)
The bug with applying the DevartEFCoreGenerator custom tool in Visual Basic .NET Core projects is fixed (Entity Framework models)

Entity Framework support

The new methods OracleJsonFunctions.ValueAs... are added for getting nonstring values returned by the JSON_VALUE Oracle function
The config.CodeFirstOptions.UseDateTimeAsDate option is supported in EF Core
The behavior is changed: by default System.String is mapped to NVARCHAR2(2000) in EF Code-First when config.CodeFirstOptions.UseNonLobStrings=true
The behavior is changed: the MoveTable operation is ignored now if either config.Workarounds.IgnoreSchemaName=true or config.Workarounds.IgnoreDboSchemaName=true and MoveTable is generated for Migration History table to move it into / from a schema dbo
The bug with using bool properties in the .Any() clause of LINQ query in EF Core 2 is fixed
The bug with generating SQL query when translating paging operations with .OrderBy().Skip().Take() in EF Core is fixed
The bug with explicit specifying .HasColumnType for PK property, when the entity has Owned Type, in EF Core 2 is fixed
The bug with using the CLOB column as a parameter of the JSON_VALUE Oracle function is fixed
The bug with building a query for class properties mapped to columns with more than 30 characters is fixed

9.5.429 11-Jan-18

SQL Server Data Tools (SSDT) 2017 is supported - SSIS projects only
The performance of reading data in the Direct mode is improved
The type of the Offset and Length properties of the ScriptProgressEventArgs class is changed from Int32 to Int64
The bug with assigning a UInt32 value larger than Int32.MaxValue to a parameter, for which DbType or OracleDbType property is not set explicitly, is fixed
The bug with MethodAccessException in .NET Standard 1.3 compatible assemblies when linking them to a project, targeting Full .NET Framework, is fixed

Entity Developer

The ModelNameAsFilesPrefix property is implemented in the RepositoryAndUnitOfWork template
Support for ASP.NET Core MVC is added to the MVC Controller template (Entity Framework models)
The code generation for async method calls in the EF Core template is improved (Entity Framework models)
The behaviour is changed: a base class in TPT Inheritance is allowed to be abstract now (LinqConnect models)

Entity Framework support

Entity Framework Core 1.1.4 is supported
Entity Framework Core 2.0.1 is supported
The bug with using bool properties in the Where() clause of LINQ query in EF Core 2 is fixed
The bug with the "ORA-00920: invalid relational operator" error in the WHERE clause in EF Core 2 is fixed
The bug with the "ORA-12704 (character set mismatch)" error EF Core is fixed
The bug with Oracle function-based index when using Scaffold-DbContext in EF Core is fixed
The bug with incorrect result set when using both Skip() and Take() in EF Core LINQ query is fixed
The bug with omitting semi-colons between statements generated by Script-Migration in EF Core is fixed
The bug with ignoring the maxLength, precision, scale property settings by update-database in EF Core is fixed
The bug with using enumerations in EF Core model is fixed
The bug with LIKE (.StartsWith/.Contains./EndsWith) is fixed
The bug with case-insensitive comparison is fixed

9.5.399 23-Nov-17

The CancelEditRowIfUpdateFailed property, determining whether to call CancelEdit for the row after update of the row is failed when data binding is used, is added to OracleDataTable
The bug with getting information about parameters for stored procedures with long names via OracleCommandBuilder.DeriveParameters for Oracle 12c R2 is fixed

LinqConnect (formerly known as LINQ to Oracle)

The performance of generating complex queries is improved
The bug with exceeding a length of duplicated column aliases in the generated SQL is fixed

Entity Developer

The new "Detect function-based column default value" option is implemented in Model Settings of EF Core model
The code generation for async method calls is added to the EF Core template
The usage of long identifiers (up to 140 symbols) for naming model objects is supported

Entity Framework support

Entity Framework 6.2 is supported
The SQL generation for subselects, when using Distinct(), in EF1/EF4/EF5/EF6 is optimized
The Code-First Migrations functionality in EF Core is improved:

the operations InsertData / UpdateData / DeleteData (introduced in EF Core 2), AlterSequence are supported

The bug with using UseOracle(DbConnection) extension method of DbContextOptionsBuilder in EF Core is fixed
The bug with Database.ExecuteSqlCommand(), when the second parameter passed is a collection of the OracleParameter objects, in EF Core is fixed
The bug with generating SQL aliases in EF Core 2 is fixed
The bug with using collections in a .Contains() method in EF Core 2 is fixed
The bug with JOIN conditions in SQL generated from LINQ query in EF1/EF4/EF5/EF6 is fixed
The bug with using multiple .Include() in EF Core 2 is fixed
The bug with processing conditions in LINQ queries with joins in EF Core is fixed

9.5.381 30-Oct-17

.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

9.4.348 06-Sep-17

The integration with Visual Studio 2017 is improved: the installation is now silent, without VSIX Installer prompt window
The bug with the "A call to SSPI failed, see inner exception" error when connecting under Microsoft Windows account in the Direct mode is fixed

Entity Developer

The Devart Visual Studio packages registration into Visual Studio 2017 is improved: the packages are now available for all Windows accounts
The bug with losing Toolbar and docking customizations of a standalone designer during reinstall is fixed

Entity Framework support

The bug with throwing ORA-01747 by LINQ query in EF Core is fixed
The bug with using a variable with null value in LINQ query in EF Core is fixed
The bug with reading TIMESTAMP WITH TIME ZONE values via EF Core is fixed
The bug with constructing a subquery from DUAL when translating LINQ queries in EF Core is fixed

9.4.326 03-Aug-17

The bug with inability to use existing performance counters without having administrator privileges is fixed
The bug with not inserting correct unicode N-prefixed string literal to NCHAR/NVARCHAR fields of a non-unicode database is fixed

Entity Developer

The new Raw SQL Query class property and SQL method property with the corresponding editors are implemented in EF Core
The bug with generating code for the PropertyChanging event is fixed
The bug with applying Custom Tool by Devart Entity Model (*.edml) in VS 2017 .NET Core projects is fixed
The bug with quoting default table and column names in EF Core is fixed
The bug with registering DevartEntityDeploy on the workstation with just Build Tools for Visual Studio 2017 installed is fixed

Entity Framework support

The possibility to set DEFAULT for a table column via the DefaultValue annotation in EF6 Code-First Migrations fluent mapping is implemented
The possibility to create database objects with names up to 128 characters long in Oracle 12c Release 2 is supported
The bug with using Contains() in multiple LINQ queries in EF Core is fixed
The bug with comparison and binary operations in EF Core is fixed

9.4.314 13-Jul-17

The bug with the "ORA-03113" error when a Windows account is not in a domain in the Direct mode is fixed

Entity Developer

The behaviour is changed: IsRequired(false / true) for navigation properties is always generated in EF Core fluent mapping now
The bug with throwing "Can't load provider assembly." by EF6 model in a standalone Entity Developer is fixed
The bug with serializing user defined extended properties for associations is fixed
The bug with a Devart provider not found in Entity Developer as a standalone application when the provider is installed without placing Devart assemblies to the GAC is fixed

9.4.299 22-Jun-17

The compatibility with Visual Studio 2017 Updates is improved
The bug with using the 'Do not install assemblies in the GAC' install wizard functionality for Visual Studio 2017 is fixed
The bug with applying the License Key connection string parameter (concerns .NET Standard 1.3 compliant assemblies only) on Linux is fixed
The bug with applying the License Key connection string parameter (concerns .NET Standard 1.3 compliant assemblies only) in .NET Framework projects is fixed
The bug related to numeric type conversion in Oracle Object Wizard with "Use Nullable types" enabled is fixed
The bug with adding Devart SSIS components to the project with TargetServerVersion=SQLServer2014 is fixed

Entity Developer

The bug related to the conflict of Entity Developer with dbForge SQL Complete is fixed
The bug with generating .NET Core code by EF Core and LinqConnect templates for the "Use the following connection string from App.config" option in Model Settings is fixed

Entity Framework support

The behavior is changed: now a DBMS_LOB.COMPARE call is generated for comparing CLOB/NCLOB columns
The bug with throwing "ORA-00918: column ambiguously defined" while joining tables with duplicate column names in Oracle 12c when using EF Core is fixed
The bug with generating SQL statements for NUMBER(1) columns mapped to bool properties in EF Core is fixed

9.4.280 25-May-17

.NET Core is supported
The NuGet packages with .NET Standard 1.3 (.NET Core) compliant assemblies are uploaded to www.nuget.org
The Default Fetch Size connection string parameter, which specifies the number of rows that will be transferred across the network at a time, is added
The possibility to assign a value of the DateTimeOffset type to OracleParameter.Value is added
The bug with the "ORA-01017" error when connecting to an Oracle user account with PASSWORD_VERSIONS equal to 10g only in the Direct mode is fixed
The bug with setting an InputOutput parameter to DBNull.Value instead of preserving its previous value if its value is not changed in the command in the Direct mode is fixed
The bug with incorrect behaviour of method OracleIntervalYM.Parse() when leading characters of the year part were ignored for some values is fixed
The bug in OracleCommandBuilder.RefreshingFields with handling of quoted column names has been fixed
The bug with previewing a DataSet is fixed
The bug with AccessViolationException when FetchSize is specified explicitly for a command and records of the result set have large size, and thus, too large prefetch buffer is required, is fixed
The bug with OracleDataReader, returning null values for Object, Array, Table, Xml, AnyData columns instead of returning an empty value of the corresponding type in the Direct mode is fixed

Entity Developer

The .NET Core projects in Visual Studio 2017 are supported
The Snake case in both Model and Database naming rules is supported via the new "Add underscore" option
The bug with setting parameter prefix in command text generated for calling pipelined function via EF Core is fixed

LinqConnect (formerly known as LINQ to Oracle)

The bug with running LINQ queries, which invoke .NET methods on client side during materialization of result set, is fixed
The bug with materializing scalar value collection when converting values on the client side is fixed

Entity Framework support

Entity Framework Core 1.1.2 is supported
The CreateSequence and DropSequence operations in EF Core Code-First Migrations are supported
The support of EF Core models with string columns, which are defined without length limit and participate in PKs, FKs, indices, is improved
The possibility to use command interception for EF6 commands executed within batch updates is implemented
The compatibility with ASP.NET Core Identity is improved
The bug with using config.CodeFirstOptions.TruncateLongDefaultNames in EF Core is fixed
The bug with using the ForOracleHasColumnName and ForOracleHasColumnType modelBuilder methods with the value-type properties in EF Core is fixed
The bug with paging in subselect within EXISTS generated for Oracle 12c using EF1/EF4/EF5/EF6 is fixed
The bug with paging in EF Core is fixed

9.3.230 16-Mar-17

Visual Studio 2017 is supported
The bug with throwing NRE when connecting to Oracle 7.3 in the Direct mode is fixed
The bug when default output of OracleDestination did not include server-generated primary key column values after insertion has been fixed
The bug with obfuscation of the DirectUtils.SecurityLevel enum in the Mobile Edition is fixed

Entity Developer

The bug with generating the virtual keyword when Inheritance Modifier=None is fixed (Entity Framework models)

Entity Framework support

Entity Framework Core 1.1.1 is supported

9.2.220 02-Mar-17

Visual Studio 2017 Release Candidate 4 is supported
Oracle 12c authentication in the Direct mode is supported
The resource usage by connections when working with failover functionality in the OCI mode is optimized
The bug in Oracle Lookup component with parameter names in generated conditions has been fixed

Entity Developer

The bug with throwing the "Stack empty" error after stopping validation before code generation in a standalone version is fixed (Entity Framework models)
The bug with a workability of the "Validate on Build" option in Model Settings is fixed (Entity Framework models)
The bug with compilation of the EF Core template after copying it to model folder is fixed (EF Core models)

Entity Framework support

The translation of collection's Contains method in LINQ query to SQL statement in EF Core is supported
The bug with using bool properties in the WHERE clause in EF Core is fixed

9.2.205 09-Feb-17

Visual Studio 2017 Release Candidate 3 is supported
The bug with inserting null values via OracleLoader in the Direct mode to a UTF8 server is fixed
The bug with throwing NRE when using the GetBytes method of an OracleDataReader object is fixed

LinqConnect (formerly known as LINQ to Oracle)

The bug with using DataLoadOptions.LoadWith is fixed

Entity Framework support

The bug with using the .FromSql() functionality in EF Core is fixed

9.2.200 02-Feb-17

Entity Framework support

The AddUniqueConstraintOperation and DropUniqueConstraintOperation operations are supported in EF Core Code-First Migrations
The bug with creating a predefined Migrations History table in EF Core, when config.Workarounds.DisableQuoting = true, is fixed

9.2.187 16-Jan-17

Visual Studio 2017 Release Candidate is supported
The bug with an AccessViolationException when a LOB value is written to OracleAnyData in the OCI mode is fixed

Entity Framework support

The config.Workarounds.ProviderManifestToken option is added for setting provider manifest token for all contexts within application domain
The SQL generation for subselects, when using paging and aggregate functions, in EF Core is optimized
The bug with throwing "ORA-00932: inconsistent datatypes" within EXISTS clause of the SQL statement generated by EF Core is fixed
The bug with ignoring MaxLength set via fluent mapping for the explicitly specified data type in EF Core is fixed
The bug with duplicating conditions when using paging in EF Core for Oracle 11g and below is fixed
The bug with comparing non-nullable properties in LINQ query when config.QueryOptions.UseCSharpNullComparisonBehavior=true is fixed
The bug with using AddForeignKeyOperation and DropForeignKeyOperation in EF Core Code-First Migrations is fixed
The bug with throwing the "Operation is not valid due to the current state of the object" error with Batch Updates in EF1/EF4/EF5/EF6, if the previous SaveChanges() failed, is fixed

9.2.172 22-Dec-16

The behaviour is changed: the OracleArray constructor now verifies that OracleArray is not created for a UDT that is not VARRAY
The bug with throwing NRE in the OracleObject and OracleArray classes is fixed

Entity Framework support

The bug with grouping by constant expression in EF1/EF4/EF5/EF6 when using DevExpress.XtraGrid.GridControl is fixed
The bug with creating indices by EF Core Code-First migrations is fixed
The bug with setting parameter type when generating the IN expression with subselect in EF Core is fixed

9.2.162 08-Dec-16

The 'Do not install assemblies in the GAC' check box that allows disabling placing the provider assemblies to the GAC is added to the Install Wizard
Oracle ANYDATA type is supported in the Direct mode
The InitialLobFetchSize property of OracleCommand is supported in the Direct mode
The bug with generating an error when using OracleMonitor on Linux is fixed
The bug with losing Errors of an OracleException object when performing binary serialization is fixed
The bug with not using parameters value in ParentRelation data in OracleDataTable.SelectCommand is fixed

LinqConnect (formerly known as LINQ to Oracle)

The exception message for invoking CreateDatabase() for the model which includes an association with missing end is improved

Entity Developer

The possibility to choose whether to add new entities to a diagram or not in Update From Database Wizard is implemented
The behaviour is changed: now the DbContext template generates an additional partial class for the context class when "File Per Class" and "Generate Partial Class" are set to True (Entity Framework models)

Entity Framework support

Entity Framework Core 1.1.0 is supported
The Scaffold-DbContext NuGet command of Package Manager Console for generating a model basing on the existing database schema is supported in EF Core
Batch Updates support in EF Core is added
The OracleJsonFunctions class is implemented in EF4/EF5/EF6 to use JSON functions and operators in LINQ to Entities queries
Signed versions of NetTopologySuite GIS library are supported in EF5/EF6
NetTopologySuite 1.14 is supported in EF5/EF6
GeoAPI 1.7.4 is supported in EF5/EF6
The NetTopologySuiteSigned and NetTopologySuiteUnsigned members are added to the SpatialServiceType enum in EF5/EF6
The config.DatabaseScript.Schema.DeleteDatabaseBehaviour option is supported in EF Core
The behaviour is changed: the functionality of SpatialServiceType.NetTopologySuiteSigned is moved to Devart.Data.Oracle.Entity.EF5.dll / Devart.Data.Oracle.Entity.EF6.dll
The behaviour is changed: the errors thrown by executing SQL statement CREATE/DROP USER are ignored
The bug with shortening PK, FK, IX, UX names in the Code-First CreateDatabase/CreateDatabaseScript functionality when config.CodeFirstOptions.TruncateLongDefaultNames=True is fixed
The bug with comparison in LINQ query when config.QueryOptions.UseCSharpNullComparisonBehavior=true is fixed
The bug with creating database objects in the same schema by several EF6 contexts in Code-First approach is fixed
The bug with adding all available objects to the model (instead of the selected ones) by Entity Data Model Wizard is fixed
The bugs with logical expressions in EF Core are fixed

9.1.131 20-Oct-16

The Data Encryption and Data Integrity feature in the Direct mode is supported
The EZCONNECT format is supported in the Direct mode
The bug with inserting a collection of Guid when using array binding in the OCI mode if Size is not explicitly set for the corresponding parameters of the OracelDbType.Raw type is fixed

Entity Framework support

The bug with materializing object, which includes the DbGeometry or DbGeography properties, when executing SQL query via DbContext.Database.SqlQuery<> in EF5 and EF6 is fixed

9.1.121 06-Oct-16

The performance of retrieving data in the Direct mode is improved
The output of the domain to the "machine" column and output of the "process" column values in the Direct mode are supported
The bug with not executing a procedure on the server side when the query text is "CALL procedure_name()" in the Direct mode is fixed

LinqConnect (formerly known as LINQ to Oracle)

The bug with reading columns of the base type in TPT inheritance via .OfType() of LINQ query
The bug with loading objects via association which targets to the base class of an inheritance with the materialized child class is fixed
The bug with throwing "Sequence contains more than one element" when reading objects of TPT hierarchy is fixed

Entity Developer

The generation of static methods by the EntityObject template is supported via the new property Direct Call of EntityMethod (Entity Framework models)

Entity Framework support

The bug with throwing ORA-00918 by .Include() and .Take() in EF Core when working with Oracle 12c is fixed
The bug with comparing bool class property with some value in EF Core is fixed

9.1.111 22-Sep-16

The binary serialization is added to OracleString, OracleBinary, OracleNumber, OracleDate, OracleIntervalDS, and OracleIntervalYM structures
The bug with losing Offset of an OracleException object when performing binary deserialization is fixed

Entity Developer

The bug with moving mapping from abstract base class to child classes of TPH inheritance in the fluent mapping generated by the DbContext template is fixed (Entity Framework models)

LinqConnect (formerly known as LINQ to Oracle)

The bug with materialization in the multithreaded application is fixed

Entity Framework support

Entity Framework Core 1.0.1 is supported
The config.SpatialOptions.ReadAs2D configuration option (default value is False) is implemented for EF5 / EF6 to treat 3D SDO_GEOMETRY objects as 2D
The new optional parameter Action is added to UseOracle() extension method of DbContextOptionsBuilder in EF Core
The behaviour is changed: FK constraints within CREATE TABLE are named now in Code-First Migrations
The bug with using Take(0) with the entity, which includes the DbGeometry or DbGeography fields, in EF5/EF6 is fixed
The bug with paging in EF Core, when working with Oracle 11g and below, is fixed
The bug with processing IN expressions in EF Core is fixed
The bug with retrieving objects of TPH hierarchy in EF Core is fixed

9.1.97 01-Sep-16

New CharLength and CharUsed columns have been added to the Columns collection of the OracleConnection.GetSchema method
The execution of OracleScript with the PL/SQL declaration sections in the WITH clause in Oracle 12c is supported
The performance of retrieving metadata for stored procedures in the Direct mode is improved
The bug with data preview in the OracleDataTable designer when the command text was changed is fixed
The bug with the OracleIntervalDS.Parse() method is fixed
The bug with incorrect number mapping for Oracle connection in SSIS project is fixed
The bug with losing precision when retrieving Oracle NUMBER, mapped to Decimal via the Number Mappings connection string parameter, into Double/Single values in the OCI mode is fixed

Entity Framework support

The DatabaseFacade.GetOracleConnection() extension method, which returns OracleConnection, is implemented in EF Core
The bug with using the DatabaseFacade.UseTransaction() method in EF Core is fixed
The bug with nullable parameters in EF Core is fixed
The bug with throwing System.NullReferenceException when using TPH inheritance in EF Core is fixed
The bug with not throwing concurrency check exception on invoking DbContext.SaveChangesAsync() is fixed

9.1.82 11-Aug-16

The bug with authentication in Mobile Edition is fixed

Entity Developer

The bug with setting value of the Value Generated property attribute in the EF Core model is fixed
The bug with generating name, which contains a key word, of a class property in EF Core is fixed

Entity Framework support

The bug with executing the UseOracle(DbConnection connection) extension method of DbContextOptionsBuilder in EF Core is fixed
The bug with using the DbContext(DbConnection connection) overload in EF Core is fixed
The bug with using EF Core logging is fixed
The bug with using enum values in EF Core is fixed
The bug with throwing DbUpdateConcurrencyException in EF Core is fixed
The bug with using comparisons in LINQ queries in EF Core is fixed
The bug with long parameter names in EF Core is fixed

9.1.67 21-Jul-16

The bug with the error "Unable to load oraclient.dll" for Oracle Instant Client when working with data of the XMLType datatype is fixed

Entity Framework support

OracleCSharpMigrationCodeGenerator and OracleVisualBasicMigrationCodeGenerator for code-based migrations are implemented for EF4, EF5, EF6
The CheckConstraintColumnRestriction property of the OracleAddColumnConfiguration class for customization of the AddColumn operation in EF4, EF5, EF6 Code-First Migrations is implemented
The OracleColumnAnnotations class for customization of creating columns in the CreateTable operation in EF6 Code-First Migrations is implemented
The bug with using the CurrentDateTimeOffset canonical function is fixed
The bug with generating triggers for Oracle 9/10/11 by EF Core Code-First migrations is fixed
The bug with convertation of enum values in parameters when using EF Core is fixed

9.1.55 07-Jul-16

The performance using a default value (changed to 8192) of DirectUtils.PacketSize in the Direct mode via VPN connection is improved
The performance of inserting CLOB data is improved

Entity Developer

Entity Framework Core 1.0 RTM is supported
The possibility to set values of stored procedure parameters for getting metadata to generate automatically the corresponding complex type is implemented
The behaviour is changed: the ObservableCollection navigation properties are initialized now in a default class constructor (Entity Framework models)

Entity Framework support

Entity Framework Core 1.0 RTM is supported
The SqlFunctions.DatePart method is supported in LINQ to Entities for the following modifiers: year, month, day, hour, minute, second, millisecond, tzoffset
The bug with generating size of the VARCHAR2 and NVARCHAR2 columns in Oracle 12c using the Code-First/Code-First Migrations functionality is fixed

9.1.45 23-Jun-16

The IEnumerable<OracleSqlStatement>, ICollection<OracleSqlStatement>, and IList<OracleSqlStatement> interfaces are implemented in the OracleSqlStatementCollection class
The alternative quoting mechanism for string literals (string literals with the Q prefix) of Oracle 10g and higher is supported in the OracleScript class
The bug with generating OverflowException when retrieving data via OracleDataReader using the x64 version of Oracle client is fixed
The bug with generating OutOfMemoryException when retrieving data via OracleDataReader using the x86 and x64 version of Oracle client is fixed
The bug with not adding records to the RSPreviewPolicy.config and RSReportDesigner.config files for correct work in Reporting Services(SSRS) projects is fixed

Entity Developer

The bug with applying the ON DELETE CASCADE option by Create Model Wizard and Update Model From Database Wizard is fixed

Entity Framework support

The OracleConventionSetBuilder class is implemented in the Entity Framework Core support

9.1.35 09-Jun-16

Microsoft SQL Server Data Tools Business Intelligence (SSDT-BI) project templates for Analysis Services, Reporting Services, and Integration Services (mapping wizards) in Visual Studio 2015 are supported
Microsoft SQL Server 2016 is supported in SSIS DataFlow components
The bug with reading BLOB data in the Direct mode from an Oracle 11.2.0.4 server, running on Linux, is fixed
The bug with returning a wrong SQL query in the Description property of MonitorEventArgs class, when MonitorEventType is equal to Execute, and the ExecutePageReader method of OracleCommand is called, is fixed
The bug with signing assemblies in Mobile Edition is fixed

LinqConnect (formerly known as LINQ to Oracle)

The bug with setting string parameter data types in SQL statements generated basing on the Contains LINQ operator is fixed

9.0.26 26-May-16

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 support

Entity Framework Core RC2 is supported

9.0.17 12-May-16

The bug with array binding memory usage by calculating the size of the Raw parameters is fixed

9.0.12 05-May-16

Oracle objects in array binding in the Direct mode are supported
The implementation of DML arrays in output parameters in the Direct mode is improved
The OracleHomeCollection class 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: number mappings in the connection string now influence the code generated by Oracle Package Wizard
The bug with throwing NRE when selecting a connection in the OracleDataSource component in Visual Studio 2010 is fixed
The bug with method and property naming in code generated by the Oracle Object wizard, when the names of this method or property are the same as class name, is fixed
The bug with NumberMappings for OracleDataReader that is retrieved from a REF CURSOR is fixed
The bug with reading OracleXml via Oracle Client of versions 10 and 11 is fixed

LinqConnect (formerly known as LINQ to Oracle)

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

Entity Framework support

Upgrade Wizard is improved for upgrading projects with the Entity Framework functionality
The bug with generating INSERT statements for the tables with identity column is fixed

9.0.7 21-Apr-16

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
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
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
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
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 bug with cast for numeric values in code generated by the Oracle Object wizard is fixed

Entity Framework support

Entity Framework Core RC1 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
The bug with generating 'GENERATED BY DEFAULT ON NULL AS IDENTITY' for non-EntityKey identity properties in Oracle 12c using the Code-First/Code-First Migrations functionality is fixed

8.5.616 17-Mar-16

The bug with generating "ORA-19025: EXTRACTVALUE returns value of only one node" in Oracle Workflow Instance Store implementation is fixed

8.5.602 25-Feb-16

The exception message in the OCI mode when Oracle Client is not found is improved
The bug with an AccessViolationException when using a long password or user id is fixed

8.5.592 11-Feb-16

The bug with returning zero value for the ColumnSize column in a schema table in the Direct mode is fixed

LinqConnect (formerly known as LINQ to Oracle)

The bug with the Devart.Data.Oracle.Linq.Provider.OracleDataProvider initialization when working with a custom data provider is fixed
The bug with the DatabaseExists(), CreateDatabase(), DeleteDatabase() methods when working with a custom data provider is fixed
The bug with executing queries with parameters when working with a custom data provider is fixed

Entity Developer

The code generation by the DbContext template (fluent mapping) for navigation properties is fixed (Entity Framework models)

Entity Framework support

The spatial constant functionality is implemented

8.5.583 21-Jan-16

The bugs with memory leak and performance loses when using OCI session pooling are fixed
The bug with ineffective usage of memory and OCI resources in multithreaded applications is fixed
The bug with selecting data from a LONG VARCHAR column when using the "Unicode=true" connection string parameter in the OCI mode is fixed

8.5.563 24-Dec-15

Entity Framework support

The bug with the wrong SQL query generation for comparison with the string which includes fullwidth apostrophe is fixed

8.5.558 17-Dec-15

The bug with connecting via Oracle Client of versions 7 and 8 with the Unicode connection string parameter set to true is fixed

LinqConnect (formerly known as LINQ to Oracle)

The bug related to the "Unable to cast object of type 'Devart.Data.Linq.Engine.SqlColumnRef'" error when using a TPT inheritance is fixed

Entity Framework support

The bug with throwing OverflowException, when removing a large number of records via BatchUpdates with BatchSize > 2000, is fixed
The bug with availability of the config.SpatialOptions.AlwaysUseGeometryDefaultSrid option in \Entity\EF5\Devart.Data.Oracle.Entity.dll and \Entity\EF6\Devart.Data.Oracle.Entity.dll is fixed
The bug related to the exception being thrown when using some OracleFunctions (i.e. ToChar, ToNchar, ToClob, ToNclob, RawToHex, ToDate, ToTimestamp, ToTimestampTz) is fixed

8.5.543 26-Nov-15

The possibility to create an unsafe pointer to an OracleIntervalDS structure is added

LinqConnect (formerly known as LINQ to Oracle)

The bug related to the "Index was out of range. Must be non-negative and less than the size of the collection." error when enumerating an IQueryable collection is fixed
The bug with materializing objects having EntitySet<T> fields via non-anonymous class that is not included in the model is fixed

Entity Framework support

The bug with applying config.QueryOptions.CaseInsensitiveComparison for non SELECT queries is fixed
The bug with some OracleFunctions within LINQ queries is fixed

8.5.535 12-Nov-15

The bug with a connection via DNS name in the IPv6 network in the Direct mode is fixed
The bug with throwing the "Unknown connection string parameter" exception is fixed

Entity Framework support

The bug with using extension methods Take and Skip with Concat/Except/Intersect when talking to Oracle 12c is fixed

8.5.521 22-Oct-15

The bug with wrong column size for NCHAR and NVARCHAR columns in a schema table in the Direct mode is fixed
The bug with uploading BLOB data in Oracle 12c using the Direct mode is fixed

LinqConnect (formerly known as LINQ to Oracle)

The bug related to the "Collection is read-only" error when loading mapping of a stored procedure/function that returns a class, mapped as Table, but not related to the DataContext class, is fixed
The bug related to using IQueryable<T>.Count() is fixed

Entity Developer

The bug with applying naming rules for model properties is fixed
The bug related to the "Sequence contains no matching element" error in Update Wizards when working with TPH inheritances and many-to-many associations is fixed (LinqConnect models)
The bug related to the StackOverflowException when deleting method from model in Model Explorer is fixed (LinqConnect models)

8.5.506 01-Oct-15

The bug with the "OCI invalid handle" exception and AccessViolationException when disposing an OracleDependency object is fixed

Entity Framework support

The config.QueryOptions.TrueValueNumber configuration option is added to specify SQL generation for True values (either equal to 1 or not equal to 0)
The bug with visibility of bin objects in Entity Data Model Wizard / Designer is fixed

8.5.497 17-Sep-15

The bug with Oracle errors raising on connection closing in the Direct mode is fixed

LinqConnect (formerly known as LINQ to Oracle)

The Parent property is added to the IInheritanceConfiguration interface
The bug related to working with TPH inheritances and fluent mapping approach is fixed

Entity Developer

The bug with wrong diagram layout is fixed
The bug with checking the evaluation period in the trial version is fixed

8.5.492 10-Sep-15

The largest possible value of DirectUtils.PacketSize is increased to 32768
The bug with throwing the "IDE not supported" exception by DataSet Manager in Visual Studio 2015 is fixed

Entity Framework support

The bug with generating binary literal of the BLOB data type is fixed
The bug with comparing BLOB values is fixed
The bug with skipping every thousandth element in the SQL query generated by Entity Framework 6 is fixed

8.5.478 20-Aug-15

LinqConnect (formerly known as LINQ to Oracle)

The possibility to use .IsRowVersion() method for properties with non-binary data types when using the fluent mapping approach is added
The bug with the materialization of anonymous types is fixed

Entity Developer

The Use ObservableCollection property of the DbContext template is implemented (Entity Framework models)
The behaviour is changed: now the 1:1 and 1:0..1 associations are displayed differently on the diagram (LinqConnect models)
The bug with adding LinqConnect template for C# after adding the WCF RIA Domain Service template (Visual Basic) in Visual Basic projects is fixed (LinqConnect models)
The bug with non-generated .IsRowVersion() method for entity properties with IsVersion = True when using the fluent mapping approach is fixed (LinqConnect models)

Entity Framework support

The overloads for Contains and Matches methods are added to the OracleTextFunctions class for using full-text search with the binary columns
The bug with generating extra CASE statement in SQL when using string concatenation within LINQ query is fixed
The bug with throwing System.NullReferenceException when applying logical OR operator to the results of several IEnumerable<T>.Contains(T t) is fixed

8.5.464 30-Jul-15

Visual Studio 2015 is supported
The type of the "details" and "sessionitems" columns of the "aspnet_webevent_events" and "aspnet_sessions" tables respectively is changed from LONG to CLOB in the InstallWebTables.sql file
The bug with processing negative Oracle NUMBER values using the x64 mode in .NET Framework 4.6 is fixed

LinqConnect (formerly known as LINQ to Oracle)

The bug with CreateAssociationConvention when working with the fluent mapping approach is fixed
The bug with ManyToManyNamesConvention when working with the fluent mapping approach is fixed

Entity Developer

The support for materialized views is implemented
The bug with generating namespace for the IsExternal enum is fixed

8.4.457 16-Jul-15

LinqConnect (formerly known as LINQ to Oracle)

The bug related to the "Object reference not set to an instance of an object" error on SubmitChanges() is fixed

Entity Developer

The possibility of setting default values for enum properties is implemented (LinqConnect models)
The bug with freezing Visual Studio when using the Find dialog in large models is fixed

Entity Framework support

The performance of generating SQL for Enumerable.Contains in LINQ queries is improved by supporting a new expression type, DbInExpression, in Entity Framework 6
The bug with converting 'Y' to True when retrieving CHAR(1) values from database to the bool property is fixed

8.4.447 02-Jul-15

The bug with the "ORA-01741: illegal zero-length identifier..." exception when creating a synchronization scope with a filter based on a template is fixed

LinqConnect (formerly known as LINQ to Oracle)

The bug with materialization of classes with the same names, which are located in the different namespaces or which are the nested classes of the different classes, is fixed
The bug related to wrong SQL generation when using Count(condition)/ LongCount()/ LongCount(condition) methods in the LINQ query is fixed

Entity Framework support

The SQL generation for LINQ queries with comparison based on the RAW(16) column is improved: explicit cast to RAW(16) is used now to make Oracle Server employ an existing index created for the RAW(16) column in Oracle execution plan

8.4.437 18-Jun-15

The IPv6 protocol is supported in the Direct mode
dotConnect for Oracle is now FIPS compliant on .NET Framework 3.5 in the Direct mode
The bug with reading tnsnames.ora by OracleHome.GetServerList() is fixed

LinqConnect (formerly known as LINQ to Oracle)

The OpenConnection() method is added to the DataContext class
The bug with not calling the InitializeConnection() method for a newly created connections while performing query or stored procedure is fixed

Entity Framework support

The bug with loosing elements within the IN clause of the generated SQL for the LINQ Contains clause is fixed

8.4.422 28-May-15

Visual Studio 2015 Release Candidate is supported
The bug with ignoring the value of the third OracleLob constructor parameter, which is of a boolean type, is fixed
The bug with throwing "NET: Unknown error 1" in the Direct mode for Oracle 11.2.0.4 is fixed

Entity Developer

The bug with detecting the default values of attributes added via the Attributes menu is fixed
The bug with generating code by MVC Controller template is fixed (Entity Framework models)

Entity Framework support

The behaviour is changed: Code-First/Code-First Migrations generate BINARY_FLOAT / BINARY_DOUBLE columns for the Single / Double class properties correspondingly for Oracle 10g and higher

8.4.407 07-May-15

LinqConnect (formerly known as LINQ to Oracle)

The bug related to not submitting new records, when EntityRef of the corresponding entity class is set to null, is fixed
The bug related to re-materialization of objects of the same type when performing methods that are mapped to different stored procedures is fixed
The bug with loading metadata and query performing when ITable<TEntity> is used instead of Table<TEntity> is fixed
The bug with the materialization of UInt32 values greater than Int32.MaxValue is fixed

Entity Framework support

The config.DatabaseScript.Index.Tablespace configuration option is added to specify the tablespace for indexes created via the Code-First approach

8.4.397 23-Apr-15

The performance of the Update method of the OracleDataAdapter and OracleDataTable classes when using the UpdateBatchSize property is improved

LinqConnect (formerly known as LINQ to Oracle)

The bug related to the odd ESCAPE character in a generated SQL query after LIKE condition is fixed
The bug related to re-materialization of objects of the same type when performing various SQL-queries via ExecuteQuery() method in multi-threading applications is fixed

Entity Developer

The support of ID generators for primary keys in the Fluent Mapping template is added (LinqConnect models)

Entity Framework support

The bug with generating columns in subqueries of a complex LINQ to Entities query containing limit expressions is fixed

8.4.389 09-Apr-15

Entity Developer

The bug with ignoring the "Delete Cascaded" property of the association when performing the Update Database From Model and Update Model From Database wizards is fixed (Entity Framework models)

8.4.379 26-Mar-15

Microsoft SQL Server Data Tools Business Intelligence (SSDT-BI) project templates for Analysis Services and Integration Services in Visual Studio 2013 are supported
SSIS DataFlow Source and Destination components are supported in SSDT-BI for Visual Studio 2013
The bug with executing ExecuteArray, when one of parameters is array of System.Guid, is fixed
The bug with redundant describing of stored procedures in OracleCommand with CommandType.StoredProcedure and with parameters, containing the '$' characters in their names, is fixed
The bug with throwing the "Unknown connection string parameter" exception in a multithreaded application is fixed

LinqConnect (formerly known as LINQ to Oracle)

The dependency on the System.Windows.Forms.dll assembly is removed
The bug related to the wrong SQL generation (setting value for primary key column in UPDATE statement) when using the Attach(TEntity, asModified) method is fixed
The bug related the CompiledQueryCache locking issue is fixed
The bug related to working with the columns of the BINARY_FLOAT/BINARY_DOUBLE data type is fixed

Entity Developer

The behaviour is changed: now the default values are not set for string properties, that correspond to fields with the default values like expressions (Entity Framework models)
The bug with missing settings for the LazyLoadingEnabled property in the generated code when working with the Self-Tracking Entity template is fixed (Entity Framework models)
The bug related to working with the Table Per Type (TPT) and abstract entity classes when synchronization is enabled is fixed (Entity Framework models)

Entity Framework support

The config.DatabaseScript.Table.Tablespace configuration option is added to specify the tablespace for tables created via the Code-First approach
The compatibility with SQL*Plus is improved: binary literals are now divided into fractions with 2000 symbols each when inserting data into MigrationHistory table
The bug with reading the second and consequent result sets, returned by stored procedure, is fixed
The bug with generating SQL for the INSERT / UPDATE / DELETE operations when using bool property mapped to Number(1,0) is fixed

8.4.359 26-Feb-15

The bug with using System.Runtime.CompilerServices.ExtensionAttribute in Devart.Data.Synchronization.dll for the projects with 3.5 and higher versions of .NET Framework is fixed

8.4.352 12-Feb-15

LinqConnect (formerly known as LINQ to Oracle)

The bug related to the "Cannot convert the value to GUID: System.Byte[]" error when working with eager loading and GUIDs is fixed

Entity Developer

The bug with the wrong code generation for Table Per Concrete Type (TPC) hierarchy when DbContext template is used with Fluent Mapping=True and Mapping Generation Strategy=UseConfigurationClasses (or UseOnModelCreatingMethod) options is fixed (Entity Framework models)

Entity Framework support

The bug with parsing the types of stored procedure parameters in Code-First mapping is fixed

8.4.344 02-Feb-15

Entity Developer

The bug with "Trial period expired" is fixed

8.4.342 29-Jan-15

The behaviour is changed: the data are inserted in the config_data column of the scopeconfig table via the CLOB parameter (instead of dynamic SQL) in Sync Framework
The bug in Sync Framework support with synchronization scopes, having a filter based on a template, is fixed
The bug with modifying the tracking table when creating an additional OracleSyncScopeProvisioning for the same set of tables in Sync Framework is fixed

Entity Developer

The bug with generating code by the MVC Controller template for multiple self-associations is fixed (Entity Framework models)

Entity Framework support

The bug with using the Hour, Minute, and Second canonical functions with DATE arguments is fixed

8.4.333 15-Jan-15

The InitialLobFetchSize property, that specifies the amount of data OracleDataReader initially fetches for LOB columns, is added to the OracleCommand
The behaviour is changed: OracleDataReader now returns ReadOnly=True in the schema table for the GENERATED ALWAYS AS IDENTITY columns (for Oracle 12c)
The bug with wrong data in a LONG parameter when using the "Unicode=true" connection string parameter in the Direct mode is fixed
The bug with throwing System.InvalidOperationException by Devart connection pooling in multithreaded applications under high loads is fixed
The bug with parsing the EDITIONABLE and NONEDITIONABLE keywords by OracleScript is fixed
The bug with '\r' characters when OracleScript is created using a stream is fixed
The bug with losing the '\r' character in string literals when executing a script via OracleScript is fixed
The bug with output parameters in DML arrays in the Direct mode is fixed
The bug with the ToString() method of the OracleTimeStamp class, occurring for dates that cannot be presented as System.DateTime, is fixed

Entity Developer

The bug with generating connection string supplied to constructor in case of placing the model in a subfolder of the project is fixed (Entity Framework models)

8.4.313 18-Dec-14

The bug with wrong data in a LONG parameter when using the "Unicode=true" connection string parameter in the OCI mode is fixed

Entity Developer

The bug with opening nodes of views in Update Model Wizard is fixed

Entity Framework support

The bug with generating incorrect value for the DbGeometry SRID parameter is fixed
The bug with SQL generation for unicode string properties initialized using concatenation of string constants is fixed

8.4.303 04-Dec-14

The behaviour is changed: SYS_EXTRACT_UTC(SYSTIMESTAMP) is used now in WF Services scripts for the date columns
The bug with using the same parameter several times in a MERGE statement in the Direct mode is fixed

LinqConnect (formerly known as LINQ to Oracle)

The bug related to memory leak errors when working with the disabled compiled query cache is fixed

Entity Developer

The bug with saving and reading the CodeFirstOptions.ColumnTypeCasingConventionCompatibility setting in the Provider Manifest Token attribute of the model is fixed (Entity Framework models)
The bug with the incorrect code generation, when the "Enable WinForms Data Binding" property of the DbContext template (Visual Basic) is set to True, is fixed (Entity Framework models)
The bug with missing attributes for the enum members when generating code with the DbContext template is fixed (Entity Framework models)

Entity Framework support

The Devart.Data.Oracle.Entity.INDEX_HINT function for specifying Oracle INDEX hint without the explicitly specified table's alias in EntitySQL is added
The OracleFunctions.IndexHint method for specifying Oracle INDEX hint without the explicitly specified table's alias in LINQ to Entities is added
The bug related to working with the customized Migration History table and Entity Framework 6 is fixed

8.4.293 20-Nov-14

ADO.NET implementation of ASP.NET Identity 2.0 support is improved

The new IQueryableUserStore interface is implemented in the UserStore class
The new IQueryableRoleStore interface is implemented in the RoleStore class

The enableExpiredSessionAutoDeletion and expiredSessionAutoDeletionInterval options for deleting expired sessions are added to the session-state store provider definition in the web.config file
The behaviour is changed: the OracleMonitor now hides information about the password connection string parameter
The bug with displaying the "Describe Stored Procedure" connection string parameter in the Connection Editor is fixed
The bug with the conflict between versions of Devart.Data.Oracle.Web.dll assembly for ASP.NET 2 and ASP.NET 4 is fixed

Entity Developer

The bug with displaying the "Describe Stored Procedure" connection string parameter in the Connection Editor is fixed
The bug related to script generation by the "Generate Database Script" wizard with the "Include Drop" option is fixed
The bug related to resetting enum arguments of custom attributes in the standalone version is fixed
The bug with incorrect execution of the "Create Storage and Mapping" command for an association is fixed (Entity Framework models)

8.4.283 06-Nov-14

The new \Web\ASP.NET 45\Devart.Data.Oracle.Web.dll assembly (its revision number is 5) is added to the provider installation folder to support SimpleMembership in MVC5
The bug with Oracle objects when connecting via Oracle Instant Client Light with the "Unicode=true" connection string parameter is fixed
The bug with creating invalid triggers during provisioning for Oracle 10g is fixed
The bug with committing transactions when using Windows Authentication and "OraMts=true;" connection string option is fixed

LinqConnect (formerly known as LINQ to Oracle)

The bug related to the InvalidOperationException when working with IMultipleResults is fixed

Entity Developer

The bug with reading all constructor parameters for attributes when opening model is fixed
The bug related to disappearance of the foreign key property when performing "Create Storage and Mapping" from the context menu of the association is fixed (Entity Framework models)
The bug related to the "'End Class' must be preceded by a matching 'Class'" error when adding stored procedure to the model and using DbContext template in Visual Basic projects is fixed (Entity Framework models)

8.4.274 23-Oct-14

The bug with ignoring the offset parameter of the OracleLob.Write method in the Direct mode is fixed
The bug with the OracleLob.Close() method in the Direct mode is fixed
The bug with committing automatically the Merge statement executed via OracleCommand in the Direct mode is fixed

Entity Framework support

The config.SpatialOptions.PrecisionModel configuration option is added to specify the NetTopologySuite precision model scale factors
The bug with assigning -1 (instead of null) to SRID of the DbGeometry object is fixed

8.4.264 09-Oct-14

The Enterprise Library 6 support is added; all previous versions of Enterprise Library are no longer maintained

8.4.254 25-Sep-14

Entity Developer

The behaviour is changed: Generate Database Script From Model saves the output in ASCII format if there are no unicode symbols in the script; UTF-8 is used otherwise
The behaviour is changed: now the default value for the 'File Per Class' option of the DbContext template is True (Entity Framework models)
The bug with model creation when using multiple naming rules (suffixes, prefixes) is fixed
The bug with generating .HasPrecision for decimal types when using non-attribute fluent mapping (DbContext template) is fixed (Entity Framework models)

8.4.244 11-Sep-14

Entity Framework support

The bug related to the "Index was out of range. Must be non-negative and less than the size of the collection" error when working with OracleFunctions.Like(value, pattern) method is fixed

8.4.239 04-Sep-14

The bug with Unicode characters (surrogate pairs), which are not included to Basic Multilingual Plane when using the "Unicode=true" connection string parameter in the OCI mode is fixed
The bug with throwing the "Index was outside the bounds of the array" exception when working with OracleObjects in multithreaded mode is fixed
The bug with ignoring of the assigned DbType/OracleDbType when using array binding is fixed
The bug with columns mapping in the SSIS DataFlow Destination component when table has a composite primary key is fixed
The bug with invalid script when table has only primary key columns for Sync Framework support is fixed

LinqConnect (formerly known as LINQ to Oracle)

The bug related to the NullReferenceException on SubmitChanges, when working with association between classes involved in complex TPT hierarchy, is fixed

Entity Developer

The Remove Invalid Characters option (by default, True) is added to the Model Naming rules; if it is set to False, all invalid characters will be replaced with underscores
The Enable WinForms Data Binding property of the DbContext template is implemented (Entity Framework models)
The Property Change Partial Methods property of the DbContext template is implemented for generating partial methods On%PropertyName%Changing and On%PropertyName%Changed for each primitive property of entity classes (Entity Framework models)
The behaviour is changed: now partial configuration classes are generated when DbContext template is used with Fluent Mapping=True and Mapping Generation Strategy=UseConfigurationClasses options (Entity Framework models)
The bug with the wrong code generation for associations when DbContext template is used with Fluent Mapping=True and Mapping Generation Strategy=UseAttributes options is fixed (Entity Framework models)
The bug with generating DatabaseGeneratedAttribute for non-EntityKey properties when using attribute mapping (DbContext template) is fixed (Entity Framework models)
The bug with generating DatabaseGeneratedAttribute for all EntityKey properties when using fluent mapping (DbContext template) is fixed (Entity Framework models)
The bug related to the "An error occurred during an attempt to compile the template 'LinqConnect'." error in Windows Store applications is fixed (LinqConnect models)

Entity Framework support

The bug related to working with OracleFunctions.RegexpLike is fixed

8.4.225 14-Aug-14

The bug with parameters of type array of strings, containing strings longer than 1800 characters, when connected in the Direct mode to a unicode server with the Unicode connection string parameter set to false, is fixed

Entity Developer

The possibility to use relative paths to assemblies in code generation templates is implemented
The Implement Equals property is added to the DbContext, ObjectContext, and POCO Entity templates (Entity Framework models)
The bug related to detecting nullable foreign key as non-nullable is fixed (Entity Framework models)

8.4.215 31-Jul-14

The Managed ODP.NET support is added to Migration Wizard
The bug with ignoring the offset parameter of the OracleLob.Write method in the OCI mode is fixed
The bug with throwing "Unspecified error" by Migration Wizard when working with Windows Store (WinRT), XNA, Windows Phone, and Silverlight projects is fixed
The bug in the DeriveParameters method with determining parameter type for a stored procedure with parameters of NCHAR/NVARCHAR2/NCLOB data types in the OCI mode is fixed

Entity Developer

The bug with a format of generated DataAnnotations.RegularExpression for Numeric validate format is fixed
The bug with displaying Entity Set in the Class Editor dialog is fixed (Entity Framework models)
The bug with applying changes after editing the list of the extended properties via the Model Settings dialog is fixed (Entity Framework models)
The bug with adding references to both EntityFramework.dll and System.Data.Entity.dll assemblies simultaneously by Create Model Wizard, when Entity Framework version is set to Entity Framework 6 in the wizard, is fixed (Entity Framework models)

Entity Framework support

The support of boolean properties, when the corresponding column is NUMBER(1, 0), is improved
The bug with using spatial parameters is fixed
The bug with generating DDL for creating TPH tables, when the value of discriminator is not set, in the Code-First/Code-First Migrations functionality is fixed
The bug with applying custom HistoryContext settings is fixed

8.4.201 10-Jul-14

The bug with the DateFormat property for OracleLoader column with OracleDbType.TimeStamp type is fixed
The bug with untimely resource freeing when calling the InfoMessage event of the OracleConnection class is fixed
The bug with processing PL/SQL block labels in the OracleScript class is fixed

LinqConnect (formerly known as LINQ to Oracle)

The bug with the missing "ASP.NET Dynamic Data LinqConnect Web Application" project template in Visual Studio 2013 is fixed

Entity Developer

The View Generation option of the model with Entity Framework version = Entity Framework 6 is supported for the DbContext (only with XML mapping), EntityObject, POCO, and Self-Tracking Entities templates (Entity Framework models)
The bug with "DevartEntityDeploy" task, when .NET Framework 2.0 and .NET Framework 3.5 are not installed on the target workstation, is fixed (Entity Framework models)

8.4.191 26-Jun-14

The bug with AccessViolationException when finalizing an open OracleDataReader in the OCI mode is fixed

LinqConnect (formerly known as LINQ to Oracle)

The bug related to the memory leak issue when working with EntityCachingMode = StrongReference is fixed
The bug related to the NullReferenceException when performing queries and working with EntityCachingMode = StrongReference is fixed
The bug related to the "There is no tables to process" error when using the CreateDatabase() method with the DataContext object, that is based on the empty model, is fixed
The bug related to the error when creating XmlMappingSource via the FromReader() method is fixed

Entity Developer

The bug with storing custom settings in stored procedure mapping is fixed (Entity Framework models)
The bug with ordering properties in the .HasKey configuration mapping in case of composite primary key is fixed (Entity Framework models)

Entity Framework support

The bug with DatabaseExists Code-First functionality when working with TimesTen 11g Release 1 is fixed
The bug with generating CLOB/NCLOB/BLOB columns instead of VARCHAR2/NVARCHAR2/VARBINARY columns for TimesTen 11g Release 1 in the Code-First/Code-First Migrations functionality is fixed
The bug with creating BLOB (instead of VARBINARY) binary parameters of commands when talking to TimesTen 11g Release 1 is fixed
The bug with printing a correct name of database in the head of DDL script generated by "update-database -script" in Package Manager Console for the Code-First Migrations functionality applied with TimesTen is fixed

8.4.181 12-Jun-14

ADO.NET implementation of ASP.NET Identity 2.0 support is improved

The new IUserStore<T>, IUserClaimStore<T>, IUserLoginStore<T>, IUserPasswordStore<T>, IUserRoleStore<T>, IUserEmailStore<T>, IUserPhoneNumberStore<T> interfaces are implemented in the OracleUserStore and OracleUserStore<TIdentityUser, TIdentityRole> classes
The new IRoleStore<T> interface is supported in the OracleRoleStore and OracleRoleStore<TIdentityUser, TIdentityRole> classes

LinqConnect (formerly known as LINQ to Oracle)

The bug related to using properties of the enum data type (Byte, SByte), that are used in the complex entity key, is fixed

Entity Developer

The bug with resetting value of the extended properties for associations after reopening the model is fixed (LinqConnect models)

Entity Framework support

The bug with throwing System.NullReferenceException when disposing an ObjectResult is fixed
The bug with performing "Generate Database from Model" wizard when working with Entity Framework 6.1.0 Tools for Visual Studio 2012/Visual Studio 2013 is fixed

8.4.171 29-May-14

Oracle TimesTen 11g Release 1 and Oracle TimesTen 11g Release 2 are supported in the OCI mode on 32-bit and 64-bit platforms
The ServerType property of the OracleServerType type is added to the OracleConnection class
A enum OracleServerType is added; it contains the following elements: Oracle, TimesTen, Undefined
The Oracle TimesTen-specific data types are supported: TT_TINYINT, TT_SMALLINT, TT_INTEGER, TT_BIGINT, TT_DATE, TT_TIMESTAMP, TIME, BINARY and VARBINARY
New elements are added to the OracleDbType enum for better support of the Oracle TimesTen-specific TT_TINYINT, TT_SMALLINT, and TT_BIGINT data types: Byte, Int16, and Int64
Getting metadata with the GetSchema() method of OracleConnection, connecting to an Oracle database using Windows Authentication, is supported
Server Explorer integration for Windows Authentication connections to Oracle database is supported
Server Explorer integration for Oracle TimesTen is supported
The bug with deserialization of a license resource in ASP.NET applications, running with medium or high trust level is fixed
The bug with not quoting a constraint name when OracleLoader is used in array binding mode is fixed
The bug with persisting credentials in reopened proxy connection is fixed
The bug with primary key constraints not disabled by OracleLoader in the array binding mode, when a foreign key refers to all the primary key columns, is fixed
The bug with disabling NOT NULL constraint for Identity columns in Oracle 12c when using OracleLoader in the array binding mode is fixed
The bug with DEFAULT ON NULL column when using OracleLoader in the array binding mode is fixed

LinqConnect (formerly known as LINQ to Oracle)

The bug related to using properties of the enum data type, that are used in the complex entity key, is fixed

Entity Developer

The bug related to the opening of the *.edmx files is fixed (Entity Framework models)
The bug related to adding new entity properties with the spatial data type when using Model First approach is fixed (Entity Framework models)

Entity Framework support

Oracle TimesTen 11g Release 1 and Oracle TimesTen 11g Release 2 are supported in the run-time of Entity Framework provider versions for EF1, EF4, EF5, and EF6
Oracle TimesTen is supported in EDM Wizard/EDM Designer of VS 2008 SP1/VS 2010/VS 2012 and EF Tools for VS 2012/VS 2013 in the Database-First approach for creating Entity Framework models
Code-First CreateDatabase()/DatabaseExists()/DeleteDatabase() functionality is supported for Oracle TimesTen
Code-First Migrations feature is supported for Oracle TimesTen
Oracle TimesTen-specific data types are supported in Code-First / Code-First Migrations
The bug with using OracleFunctions and EntityFunctions against class properties, which are of the DATE type in SSDL, is fixed
The bug with throwing the "Unexpected query batch command" exception when using the Batch Updates functionality is fixed
The bug with generating extra condition for limiting subselect by one record in generated subqueries with grouping is fixed

8.3.161 15-May-14

The OracleScript.Cancel() method is added to stop query execution
The behaviour is changed: the Errors property of the OracleException class is never null now and always has at least one element
The behaviour is changed: the Message property of the OracleException class now contains all distinct error messages returned by Oracle when using OracleLoader in the array binding mode and when calling ExecuteArray
The behaviour is changed: when using OracleLoader in the array binding mode, the table constraints are disabled for the time of data loading and is enabled again only when closing the OracleLoader object
The bug with wrong type of a "sender" parameter in OracleLoaderErrorEventHandler is fixed
The bug with Error event of OracleLoader class not invoked if event handler is subscribed after CreateColumn() method call is fixed
The bug with not throwing exception when OracleLoader object is disposed without Close() method call is fixed
The bug with generating "ORA-19025: EXTRACTVALUE returns value of only one node" in Oracle Workflow Instance Store implementation is fixed
The bug with reading an object of the NCLOB type from Oracle 11.2.0.3.0 in the Direct mode is fixed
The bug with generating System.IndexOutOfRangeException in the Direct mode when using a quoted name of command parameter is fixed
The bug with not throwing exceptions on erroneous CREATE statements executed via OracleScript in the Direct mode is fixed

LinqConnect (formerly known as LINQ to Oracle)

The bug related to reading values of the string properties, that are database generated, when performing SubmitChanges() is fixed

Entity Developer

The bug related to performing queries via Query Editor/Retrieve Data when working with the 'Enterprise Library' validation framework is fixed
The bug related to the storage and mapping regeneration via the "Update Database from Model" wizard, or via the "Regenerate Storage and Mapping" option of the diagram shortcut menu, when changing one DBMS to another, is fixed (LinqConnect models)

Entity Framework support

The functionality of setting the CodeFirstOptions.ColumnTypeCasingConventionCompatibility option via provider manifest token for a particular Entity Framework model is implemented for possibility of using both Database-First/Model-First model with XML mapping and Code-First model with fluent/attribute mapping in the same AppDomain
The config.DatabaseScript.Column.MaxStringSize configuration option (default value is OracleMaxStringSize.Standard) is added to provide the possibility of determining a default size of the VARCHAR2 and NVARCHAR2 columns for Oracle 12c if it was not set explicitly in the Code-First CreateDatabase()/Code-First Migrations functionality
The NumericIdentityBehavior.ImplicitSequence enumeration value of config.DatabaseScript.Column.NumericIdentityBehavior for Oracle 12c is now deprecated and not recommended to use; use the new NumericIdentityBehavior.GeneratedAlwaysAsIdentity, NumericIdentityBehavior.GeneratedByDefaultAsIdentity, NumericIdentityBehavior.GeneratedByDefaultOnNullAsIdentity values instead
The behaviour is changed: now a slash after the very last statement is generated in the Code-First CreateDatabaseScript() functionality
The behaviour is changed: now the Code-First CreateDatabase()/CreateDatabaseScript()/Code-First Migrations functionality for Oracle 12c generates 'GENERATED BY DEFAULT ON NULL AS IDENTITY' instead of 'GENERATED ALWAYS AS IDENTITY' for autoincrement identity columns when config.DatabaseScript.Column.NumericIdentityBehavior = Default
The bug related to the "ORA-01790: expression must have same datatype as corresponding expression" error when trying to map RAW to Binary and using multiple Include() is fixed
The bug with setting the config.DatabaseScript.Column.NumericIdentityBehavior option via application config file is fixed
The bug with setting the default size (2000) of raw type with fluent mapping for Oracle 12c is fixed

8.3.146 24-Apr-14

The ADO.NET implementation of ASP.NET Identity 2.0 support is added

The new \Web\ASP.NET Identity 2\Devart.Data.Oracle.Web.Identity.dll assembly (its revision number is 2) is added to the provider installation folder
The new \Web\ASP.NET Identity 2\Install_identity_tables.sql and \Web\ASP.NET Identity 2\Uninstall_identity_tables.sql files are added to the provider installation folder
The new \Web\ASP.NET Identity 2\Upgrade_identity_tables_from_v1_to_v2.sql file is added to the provider installation folder
The new IUserEmailStore, IUserPhoneNumberStore, IUserTwoFactorStore, IUserLockoutStore interfaces are implemented in the UserStore class

The IDataReader interface is implemented in the OracleCursor class
The implementation of the OracleCommand.CommandTimeout property in the Direct mode is improved
The \Web\ASP.NET Identity 1\Install_identity_tables.sql file is updated: now user-friendly foreign key names are used
The bug with 'Load Test Editor' is fixed
The bug with the initialization of the OracleConnection.ShortServerVersion property, when connecting to Oracle 11g Release 2 or Oracle 12c, is fixed

LinqConnect (formerly known as LINQ to Oracle)

The behaviour is changed: the new "OUTER APPLY is not supported by Oracle Database 11g and lower. Oracle 12c or higher is required to run this LINQ statement correctly. If you need to run this statement with Oracle Database 11g or lower, rewrite it so that it can be converted to SQL, supported by the version of Oracle you use." exception is added
The bug related to wrong order of the insert/delete operations on SubmitChanges when the autogenerated primary keys are used is fixed

Entity Developer

The behaviour is changed: now a property in the generated code is initialized basing on the default value in CSDL only (instead of default values in any of SSDL and CSDL; Entity Framework models)
The bug related to the incorrect value setting for the "Has Stream" property when working with the WCF Data Services projects is fixed (Entity Framework models)

Entity Framework support

The database server version is added to the generated Code-First Migrations script
The behaviour is changed: now Database.Delete(DbConnection), when config.DatabaseScript.Schema.DeleteDatabaseBehaviour = AllSchemaObjects, removes sequences in the current schema of Oracle 12c only if config.DatabaseScript.Column.NumericIdentityBehavior = ExplicitTriggerAndSequence
The behaviour is changed: now Database.Exists(DbConnection), when config.DatabaseScript.Schema.DeleteDatabaseBehaviour = AllSchemaObjects, checks an existence of sequences in the current schema of Oracle 12c only if config.DatabaseScript.Column.NumericIdentityBehavior = ExplicitTriggerAndSequence
The behaviour is changed: now by default the Code-First CreateDatabase()/CreateDatabaseScript()/Code-First Migrations functionality generates the VARCHAR2(4000) and NVARCHAR2(2000) columns for Oracle 12c if the size of the corresponding columns is not set explicitly
The bug with generation of the XMLTYPE columns in Code-First Migrations is fixed
The bug with the explicitly named primary keys in Code-First Migrations, when the primary key is defined via the PrimaryKey() method of the CreateTable() operation, is fixed
The bug with generating SQL for EntitySQL ANYELEMENT is fixed
The bug with checking an existence of system-generated sequences by Database.Exists(DbConnection), when config.DatabaseScript.Schema.DeleteDatabaseBehaviour = AllSchemaObjects and config.DatabaseScript.Column.NumericIdentityBehavior = ExplicitTriggerAndSequence, is fixed

8.3.135 10-Apr-14

The ADO.NET implementation of ASP.NET Identity support is improved

The ICloneable interface is implemented in the IdentityUser and IdentityRole classes
The User_Id column in the AspNetUserClaims table is renamed to UserId

The possibility of assigning System.Guid to OracleParameter.Value without explicitly specified OracleParameter.OracleDbType is implemented

Entity Framework support

The UpdateDatabaseOperation operation in Code-First Migrations for Entity Framework 6.x is supported
The RenameIndexOperation operation in Code-First Migrations for Entity Framework 6.1 is supported
Multiple EntityContainers in the Code-First CreateDatabase()/CreateDatabaseScript()/DeleteDatabase() functionality are supported
The Database.Delete(DbConnection) functionality is supported: all objects in the current schema (specified in User Id or set with Initialization Command connection string parameter) are removed if DatabaseScript.Schema.DeleteDatabaseBehaviour = AllSchemaObjects
The Database.Exists(DbConnection) functionality is supported: the method returns true if DatabaseScript.Schema.DeleteDatabaseBehaviour = AllSchemaObjects and at least one table or sequence exists in the current schema (specified in User Id or set with Initialization Command connection string parameter)
Determining correct datatypes of data retrieved by EntitySQL queries with UNION ALL and similar constructions is improved
The compatibility with Hibernating Rhinos EntityFramework Profiler is improved
The bug with the Code-First DeleteDatabase() functionality for system-generated sequences in Oracle 12c, when DatabaseScript.Schema.DeleteDatabaseBehaviour = AllSchemaObjects, is fixed
The bug with throwing System.NullReferenceException when enumerating an ObjectResult returned by a stored procedure is fixed
The bug with comparing a string literal with a string function, which has a non-string parameter in its signature, is fixed
The bug with using reserved words in the names of ESQL parameters is fixed
The bug with using multiple .Include() with spatial columns is fixed

8.3.125 27-Mar-14

The OracleConnection.ClearAllPools(bool force) method is added
The behaviour is changed: the instance_id field of the wf_activity_info table in Workflow Tracking implementation is of varchar(1000) type now
The bug with clearing temporary tablespace when inserting multiple CLOB, NCLOB, or BLOB values using array binding in the OCI mode is fixed
The bug with using VARCHAR2/NVARCHAR parameters in the Unicode=True mode, when OracleParameter.Size is not set, is fixed

LinqConnect (formerly known as LINQ to Oracle)

The bug related to the incorrect detection of class type when working with the TPH inheritances and discriminators of the String/Decimal type is fixed

Entity Developer

The override modifier for DbSet class properties generated by DbContext templates is added (Entity Framework models)
The bug with setting nullable type for EnumType property by the Data Transfer Object template is fixed

Entity Framework support

Entity Framework 6.1.0 RTM is supported
Entity Framework 6.1.0 Tools for Visual Studio 2012 & 2013 are supported
The releasing of memory, which was allocated for commands and readers of ObjectContext / DbContext, is improved
The behaviour is changed: now SQL is generated without additional sorting in a subquery when working with Oracle 11g/10g/9i and during the work with paging operations with .OrderBy().Skip().Take()
The bug with the comparison operators (equality and inequality), where one or both of its arguments are the result of an expression based on the CLOB/NCLOB columns, is fixed
The bug with generating Code-First Migrations for the properties with DatabaseGeneratedOption.None for Oracle12c in Entity Framework 6 is fixed
The bug with generating DDL for the Identity property, which is a part of composite entity key, in run-time (Code-First CreateDatabase(), Code-First Migrations) and design-time (EDM Designer) is fixed
The bug with determining correct datatypes of data retrieved by some EntitySQL queries is fixed

8.3.115 06-Mar-14

The ADO.NET implementation of ASP.NET Identity support is added
The script for updating Workflow Instance Store schema from .NET Framework 4.0 to .NET Framework 4.5 is added to the provider installation folder
The implementation of the ConnectionTimeout parameter of connection string in the OCI mode is improved
The bug with truncating NVARCHAR2 strings when reading from a UTF8 server in the Direct mode is fixed
The bug with throwing NRE, when incorrect database user is specified in the connection string for Oracle 11g, in the Direct mode is fixed

LinqConnect (formerly known as LINQ to Oracle)

The CommandTimeout property is added to the DataProvider class
The bug related to the invalid generation of the foreign keys DDL for many-to-many associations when using CreateDatabase method is fixed
The bug with the query cache when performing several queries, having nullable parameters, sequentially is fixed

Entity Developer

The information message about availability of NuGet Package Manager on the workstation is added in the Entity Developer version integrated into Visual Studio (Entity Framework models)
The behaviour is changed: now paths to assemblies with attributes (Model Settings -> Model -> Attributes) are saved and used as relative paths
The bug with invalid code generation when different namespaces for context and entity classes are used in the VB.NET projects is fixed (LinqConnect models)
The bug with generating the entities namespace in fluent mapping configuration classes is fixed (Entity Framework models)
The bug with generating DatabaseGeneratedOption.Computed for non-EntityKey properties in fluent mapping is fixed (Entity Framework models)

Entity Framework support

SharpMap 1.1 is supported
NTS Topology Suite 1.13.2 is supported
The behaviour is changed: now the TIMESTAMP WITH TIME ZONE column is mapped to DateTimeOffset instead of DateTime by EDM Wizard / Lightswitch / Entity Framework 6 Tools
The bug with using the CreateDateTime and CreateDateTimeOffset canonical functions with expressions (not constants) as arguments is fixed

8.2.103 18-Feb-14

The bug with INSERT, UPDATE or DELETE statements, which contain returning clause and '\r\n' symbols, in the Direct mode is fixed
The bug with freezing when array binding fails in the Direct mode is fixed

Entity Developer

More information messages, when validating EF6 models basing on the EntityFramework.dll functionality, are added (Entity Framework models)
The bug with using Create Model Wizard for EF6 models is fixed (Entity Framework models)

8.2.100 13-Feb-14

The bug with the VARCHAR2, NVARCHAR2, CHAR, NCHAR parameters in the Unicode mode, when non-null value is assigned to the Size property of the OracleParameter instance, is fixed
The bug with cursor parameters of stored procedures used in OracleDataSource is fixed

LinqConnect (formerly known as LINQ to Oracle)

The behaviour is changed: now the script is generated with "ON DELETE NO ACTION" when using the CreateDatabase() method and the "Delete Rule" for the association is set to "NO ACTION"
The behaviour is changed: now the CreateDatabase() method uses the same algorithm for naming foreign keys as in Entity Developer
The bug with the compiled query cache when working with the DbLinqDataSource component when navigating through the pages of the DataGrid control is fixed
The bug with the wrong SQL query generation for Contains(), StartsWith(), EndsWith() methods when the string pattern includes '[' or '^' symbols is fixed
The bug with the wrong SQL query generation for LINQ queries with OrderBy and First()/Single()/Take() methods when working with Oracle 9/10/11 is fixed

Entity Developer

The "WCF DataMember Attribute on Navigation Properties" property is added to the Data Transfer Object template for pointing the end (-s) where the attribute should be generated (Entity Framework models)
The behaviour is changed: the validation of EF6 models depends on the EntityFramework.dll functionality only (.NET Framework 4.5 is not required any more) (Entity Framework models)
The bug related to the "Version string portion was too short or too long" error is fixed
The bug with dropping the UpdateCheck property value from Always to Never when re-opening the model is fixed (LinqConnect models)
The bug with parsing inheritances in *.edmx is fixed (Entity Framework models)

Entity Framework support

The bug with updating/deleting entity, when its primary key column or concurrency check column is of string type and config.QueryOptions.CaseInsensitiveComparison=True, is fixed
The bug with "Update Model From Database" wizard in Entity Framework 6 Tools for Visual Studio 2012 and Visual Studio 2013 is fixed

8.2.90 30-Jan-14

The performance of the Update method of OracleDataAdapter and OracleDataTable classes is improved
The performance when working with parameters is improved
The performance of reading and writing OracleObject attributes in the OCI mode is significantly improved
The behaviour is changed: IndexOutOfRangeException is generated now instead of InvalidOperationException when OracleDataReader.GetOrdinal(String name) finds nothing in the result set
The bug with retrieving the INTERVAL YEAR TO MONTH values on the x64 platform in OCI mode is fixed
The bug with the 'OCI invalid handle' error in the OCI mode when setting OracleObject attributes, having INTERVAL DAY TO SECOND or INTERVAL YEAR TO MONTH type, is fixed
The bug with OracleObject, having BINARY_FLOAT or BINARY_DOUBLE attributes, in the OCI mode is fixed

LinqConnect (formerly known as LINQ to Oracle)

The bug with handling complex types of the entity properties in the ServerDataTypeConvention class when working with fluent mapping is fixed
The bug related to the "Object reference not set to an instance of an object" exception on CreateDatabase() method when working with associations and fluent mapping is fixed
The bug with performing updates and deletes, when concurrency check is used for not-primary key columns, and the commands are combined to run in batches, is fixed
The bug related to re-materialization of objects of the same type when performing various SQL-queries via ExecuteQuery() method is fixed

Entity Framework support

The bug with generating IndexOutOfRangeException by the ObjectContext.ExecuteStoreQuery method when the result set of the SQL query does not include any mapped column of the entity being materialized is fixed

8.2.80 16-Jan-14

The functionality of starting and stopping an Oracle database instance is implemented in the OracleDatabase class (only in the OCI mode)
Working with XMLTYPE in the OCI mode when Unicode = True is fully supported
Specifying proxy connection via the connection string with the new connection string parameters "Proxy User Id" and "Proxy Password" is supported (only in the OCI mode)
DBMS_APPLICATION_INFO package features are supported via the new properties of the OracleConnection class: ModuleName, ActionName, ClientInfo, and the SetDbmsApplicationInfo method
OCI Statement Caching support is improved: caching is now also supported in case when Unicode = True or "Oci Connection Pool" = True
OCI Statement Cache cleaning when returning a connection to a pool is implemented via the new "Statement Cache Purge" connection string parameter (Default value is False)
OCI Statement Cache cleaning on user request is implemented via the new PurgeStatementCache() method of the OracleConnection class
The possibility to speed up the stored procedure execution with the ExecuteReader()/ExecuteScalar() methods of OracleCommand, when using CommandType.StoredProcedure, is implemented via the new connection string parameter "Describe Stored Procedure" (Default value is True) and the new ImplicitRefCursors and IsTableValuedFunction properties of the OracleCommand class
Execution of non-pipelined table function with CommandType.StoredProcedure is supported when the IsTableValuedFunction property of OracleCommand equals to True
The TableValuedResultType property of OracleCommand is now deprecated and not recommended to use. Use the IsTableValuedFunction property instead
Additional overloads of the OracleCommand constructor and CreateCommand method of OracleConnection class are added to decrease the code for creating an OracleCommand instance
Additional overloads of the GetValues(), GetOracleValues(), and GetProviderSpecificValues() methods that don't require the user to create an array of the required size beforehand are added to the OracleDataReader class to ease data retrieving, for example only a single record is read
The return type of the Clone() method of OracleConnection, OracleCommand, and OracleParameter classes is now the same as the type of the object, for which the method is implemented, instead of System.Object
DbType.Xml now can be assigned to the DbType property of OracleParameter (it means the same as oracleParameter.OracleDbType = OracleDbType.Xml) in order to ease working with XMLTYPE when using base ADO.NET without using provider-specific features
Retrieving version of the Oracle database, a connection is made to, is improved: the new ShortServerVersion property of the Version type is implemented in the OracleConnection class
The bug with retrieving the INTERVAL DAY TO SECOND values on x64 platform in OCI mode is fixed

Entity Developer

The bug with not including the namespace name in the XML mapping, when namespaces for entity classes and context class are different, is fixed (LinqConnect models)
The bug with creating models for Entity Framework 6 on the workstation without .NET Framework 4.5 installed is fixed (Entity Framework models)
The bug with association mapping in the DbContext template is fixed (Entity Framework models)
The bug with composite keys mapping in the DbContext template is fixed (Entity Framework models)

Entity Framework support

The Acos, Asin, Ascii, Atan, Atan2, Char, Cos, CurrentUser, DataLength, Exp, Rand, Sign, Sin, SoundCode, SquareRoot, StringConvert, Tan methods of the SqlFunctions class in LINQ to Entities are supported to be converted to Oracle-specific SQL statements in runtime
The generation of SQL literals for DateTimeOffset and TimeSpan values is improved: shortened form is used now if possible
The bug with generation of SQL literals for DateTimeOffset values is fixed
The bug with using the CreateTime canonical function with expressions (not constants) as arguments is fixed
The bug with changing the MigrationHistory table when migrating from EF4/EF5 to EF6, when config.Workarounds.DisableQuoting = True, is fixed

8.1.65 26-Dec-13

The bug with retrieving views in Business Intelligence Solutions projects is fixed

LinqConnect (formerly known as LINQ to Oracle)

The bug with wrong order for creation tables with the many-to-many associations via the CreateDatabase() method is fixed
The bug with the entity cache (EntityCacheMode.WeakReference) is fixed

Entity Developer

The predefined templates (POCO Entity and LinqConnect) are improved: new template setting, "Generate Dummy Comments", is added (LinqConnect models)
The bug with wrong script generation for System.Boolean when the default value is set, is fixed (LinqConnect models)
The bug related to detecting unique keys is fixed (LinqConnect models)
The bug related to the "Custom tool error: Unknown namespace or alias (NamespaceName.NamespaceName)" error when setting return type of the method to complex type is fixed (Entity Framework models)

Entity Framework support

The behaviour is changed: Code-First Migrations generates DEFAULT values for new NOT NULL columns of Boolean, Guid, DateTime, DateTimeOffset, TimeSpan types when adding them in the existing table
The bug with throwing NRE when updating database, if the CreateTable method in migration code does not include the PrimaryKey definition, is fixed

8.1.55 12-Dec-13

Reduced memory usage for some operations with CLOB/NCLOB/BLOB values
Reduced memory usage for CommandBehavior.SequentialAccess

LinqConnect (formerly known as LINQ to Oracle)

The bug with foreign keys not created for many-to-many associations via the CreateDatabase() method is fixed
The bug related to the "The type initializer for 'DefaultXmlMappingProvider'" exception when working with the xml mapping and result sets is fixed
The bug with the comparison of the entity key property with a nullable variable, which is equal to null, is fixed

8.1.45 28-Nov-13

The bug with disabling some properties in Devart components in Visual Studio Express is fixed
The bug with calling the RowUpdating event of OracleDataTable and OracleDataAdapter classes when no data is changed is fixed
The bug with unhandled exceptions in the GC finalizer thread, when an Oracle instance is shutting down/restarting, is fixed
The bug with installing provider assemblies for the x64 version of SQL Server Integration Services is fixed

LinqConnect (formerly known as LINQ to Oracle)

The possibility to inherit from the data provider classes is added

Entity Developer

The new "Provider Manifest Token" model property is implemented to identify the target server (Entity Framework models)
The behaviour is changed: the values of "Target Server" and "Server Version" can be reset via the Model Settings > Synchronization > Mapping dialog despite the fact whether connection is specified in Database Explorer or not

Entity Framework support

The compatibility of Entity Framework provider for EF v1, v4, v5 with medium trust level environment is improved
The bug related to the NRE on the CreateDatabaseScript() method, when the Code-First model is not configured completely, is fixed
The bug with generating Code-First Migrations for the DateTime/DateTimeOffset properties in Entity Framework 6 is fixed

8.1.36 14-Nov-13

Oracle Object Wizard is supported in Direct mode
Performance of the operation of assigning TIMESTAMP and INTERVAL values to In parameters is improved, and memory leak in this operation is fixed

8.1.26 31-Oct-13

Visual Studio 2013 is supported
The behaviour is changed: installation with the /VERYSILENT install parameter will uninstall the other version of the provider without any dialog box if it is installed
The behaviour is changed: there is no more max count for parameters for stored procedure in the Direct mode
The bug with Advanced Queuing on x64 platform when 'AsyncNotification=True' is fixed
The bug with parsing data for INTERVAL YEAR TO MONTH is fixed
The bug with using ExtendedMembership provider in a multithreaded application is fixed
The bug with data updating in OracleDataTable, when a query returns multiple columns with the same name, and UpdatingTable is specified, is fixed
The bug with setting OracleDataAdapter.UpdateBatchSize=0 during creation of an OracleDataAdapter instance by some constructors is fixed
The bug with persisting workflow instance in the database is fixed

Entity Developer

Entity Framework 6 is supported
The bug with IntelliSense when working with T4 Editor in Visual Studio 2012 is fixed

Entity Framework support

The 6.0.0 and 6.0.1 versions of Entity Framework are supported
The behaviour is changed: Entity Data Model Wizard shows a more detailed error message in case of connecting to unsupported database or using incorrect provider manifest tokens

8.0.17 17-Oct-13

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

LinqConnect (formerly known as LINQ to Oracle)

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

Entity Developer

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

Entity Framework support

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

7.9.333 23-Sep-13

Visual Studio 2013 Release Candidate is supported
OracleLoader is supported in the Direct mode
The behaviour is changed: OracleLoader now uses direct path load if columns of supported types are used and if the connection uses OCI mode; otherwise, array binding is used
The bug with rollback freezing after OverflowException in Direct mode is fixed

LinqConnect (formerly known as LINQ to Oracle)

The implementation for the DatabaseExists method, which checks the existance of the tables in the database, is added
The possibility of creating Oracle schemas (users) for mapped model classes via the CreateDatabase(false,true)/CreateDatabase(true, true) method of the DataContext class is implemented
The possibility of deleting Oracle schemas (users) for mapped model classes via the DeleteDatabase(false,true)/DeleteDatabase(true, true) method of the DataContext class is implemented

Entity Developer

The bug with releasing memory after closing the Retrieve Data window is fixed
The bug with the Overwrite.Merge template option is fixed
The bug related to the "Value cannot be null" error when selecting "Regenerate storage and mapping" from the shortcut menu in Model Explorer in Visual Studio is fixed

Entity Framework support

The bug related to the "ORA-12704: character set mismatch" exception is fixed

7.9.322 05-Sep-13

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

LinqConnect (formerly known as LINQ to Oracle)

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

Entity Developer

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 support

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

7.8.301 08-Aug-13

The bug with compatibility of Devart.Data.Oracle.Web.dll for .NET Framework 2 and 4 in Visual Studio 2010, that is automatically added to the project when adding the OracleDataSource component to the web form, is fixed
The bug with canceling regenerate parameters operation in OracleDataSource is fixed

Entity Developer

The "Model Name As Files Prefix" property is implemented for the templates which generate classes for model entities
The possibility of adding custom attributes to enum members is implemented
The behaviour is changed: the possibility to exclude the generation of keys (primary, foreign) in "Update Database From Model" and "Generate Database Script From Model " wizards is added
The behaviour is changed: the possibility to add one-to-one associations with nullable foreign key properties is added (LinqConnect models)
The behaviour is changed: now by default MVC Controller template generates files in the model folder, MVC View Advanced template creates files in the Views model subfolder
The bug with breaking the parameters order in Generator Parameters Editor is fixed (LinqConnect models)
The bug with an error during a compilation of the 'LinqConnect' template for VB.NET projects in Visual Studio 2008 is fixed (LinqConnect models)
The bug with breaking the IdGenerator configuration after closing the model is fixed (LinqConnect models)
The bug with generating code by Self-Tracking Entity template is fixed (Entity Framework models)
The bug with parsing *.edmx is fixed

Entity Framework support

The bug with converting data types when using Batch Updates is fixed

7.8.287 18-Jul-13

SQL Server 2012 Reporting Services is supported
The bug with parameter containing the '#' character in its name is fixed

LinqConnect (formerly known as LINQ to Oracle)

The bug related to the NRE on the CreateDatabase() method, when the navigation properties generation for one of the sides in one-to-one association is turned off, is fixed
The bug with wrong script generation on the CreateDatabase() method for one-to-one associations is fixed
The bug with materialization when converting decimal values is fixed
The bug related to the "Sequence contains no elements" exception when working with unmapped properties and PropertyChanging/PropertyChanged events is fixed
The bug related to materializing structs in the "select new" clause is fixed
The bug related to the "Method not found" exception when opening connection in LINQPad via LinqConnectDriver is fixed

Entity Developer

The behaviour is changed: a default value for the "Detect Table Per Type inheritances" option in Model settings is set to False
The bug with wrong script generation for several tables with autoincrement fields in the "Generate Database Script From Model" and "Update Database From Model" wizards is fixed
The bug with the "Recreate Database Tables" option for tables which use sequences is fixed
The bug related to the wrong Source values for foreign key properties when adding associations with the selected "Add foreign key properties to the child class" check box is fixed
The bug with applying RangeAttribute of the DataAnnotation validation framework for nullable properties is fixed
The bug with parsing *.edmx is fixed (Entity Framework models)

Entity Framework support

NetTopologySuite GIS library support in Entity Framework 5 and 6 is added
The OracleSpatialFunctions class for working with Oracle Spatials functions in LINQ to Entities is added
The config.SpatialOptions.AlwaysUseGeometryDefaultSrid configuration option (default value is False) is added to provide the possibility to use the config.SpatialOptions.GeometryDefaultSrid value instead of reading the actual SRID for the DbGeometry spatial from the database
The config.SpatialOptions.AlwaysUseGeographyDefaultSrid configuration option (default value is False) is added to provide the possibility to use the config.SpatialOptions.GeographyDefaultSrid value instead of reading the actual SRID for the DbGeometry spatial from the database
The config.Workarounds.UseInvariantProviderManifestToken configuration option (default value is False) is added to provide the possibility of returning the invariant string literal as the provider manifest token
The config.SqlFormatting.Identation option is renamed to config.SqlFormatting.Indenting
The bug with using delimiter when generating Code-First Migrations script via the ScriptUpdate method of the MigratorScriptingDecorator class in Entity Framework 6 is fixed

7.7.276 03-Jul-13

The bug with not working MissingSchemaAction property of the OracleDataAdapter is fixed

Entity Developer

The "Regenerate Storage and Mapping" option for regenerating model parts, specific to the database server, is added to the diagram shortcut menu
Storage Entity Editor is improved: the capability to edit extended columns settings, such as facets, is added (Entity Framework models)
The bug with reading facets of a stored procedure parameter is fixed
The bug with adding a new property to the base abstract class in Table Per Hierarchy inheritance is fixed (Entity Framework models)

Entity Framework support

The bug with a workability of configuration options set in the application config file when using Code-First Migrations via Package Manager Console of Visual Studio is fixed

7.7.267 20-Jun-13

The bug with the OracleDataSource component in design time is fixed
The bug with AccessViolationException in heavy load long-running applications is fixed
The bug with the IsDBNull method of the OracleDataReader method is fixed
The bug with generating typed Devart DataSet using a connection from *.config in the Visual Basic project is fixed

LinqConnect (formerly known as LINQ to Oracle)

The performance when working with the TPT-inheritance and retrieving descendants via OfType<> is improved
The bug with the CreateDatabase() method when "Delete Rule" is set for the association (not empty and not "NO ACTION") is fixed
The bug related to the "The non-nullable navigation property '...' was set to null in the entity object '...'" error when working with nullable composite foreign keys is fixed
The bug related to working with the WCF Ria Domain Service template is fixed
The bug with the TPT-inheritance and associations to the descendants of the inheritance is fixed
The bug related to the "Violation of PRIMARY KEY constraint" error on SubmitChanges(), when DataContext has only one added entity for insertion with a custom key generator and DbGenerated=False for its primary key, is fixed

Entity Developer

The behaviour is changed: DatabaseGeneratedOption is always generated for EntityKey properties when using fluent mapping (Entity Framework models)
The bug with wrong code generation for nullable enum properties is fixed
The bug with generating "Access Denied" error when using MVC templates is fixed
The bug with a serialization of stored procedures mapping to CUD operations in an association is fixed (Entity Framework models)
The bug with ordering parameters of a method when Update From Database Wizard adds/removes parameters to the method signature is fixed (Entity Framework models)
The bug with parsing *.edmx which includes an association, which has different values in a navigation property name and a role at the same end, is fixed (Entity Framework models)
The bug with removing stored procedure parameters in SSDL when using Update From Database Wizard is fixed (Entity Framework models)

Entity Framework support

The config.DatabaseScript.ForeignKey.Enabled option (default value is True) is added to turn on/off generation of foreign key constraints

7.7.257 06-Jun-13

The bug with receiving data from Oracle 8.0 is fixed
The bug with the ExecuteArray method when connecting to a database with KO16MSWIN949 NLS_CHARACTERSET in the Direct mode is fixed
The bug with throwing an exception during installation when the DbProviderFactories section is missing in the machine.config file is fixed

LinqConnect (formerly known as LINQ to Oracle)

The bug with the nullable properties in composite foreign keys is fixed

Entity Developer

Devart.Data.Linq.Binary type is added to the "Type Mapping Rule Editor" (LinqConnect models)
The behaviour is changed: auto-implemented properties are generated when DbContext template is used with ImplementINotifyPropertyChanged=False and ImplementINotifyPropertyChanging=False (Entity Framework models)
The bug with referencing a custom assembly in T4 template is fixed
The bug with a synchronization when adding new properties to the base abstract class in Table Per Hierarchy inheritance is fixed (Entity Framework models)
The bug with parsing *.edmx which includes the class with a self-association is fixed (Entity Framework models)
The bug with retrieving an association mapping when opening *.edmx is fixed (Entity Framework models)

Entity Framework support

Entity Framework 6 Beta 1 is supported
The behaviour is changed: CreateDatabase()/Code-First with DeleteDatabaseBehaviour.Schema does not try to create a schema (user) if it exists
The bug using Batch Updates in a multithreaded application is fixed
The bug with creating CHAR / VARCHAR2 / NCHAR / NVARCHAR2 / RAW datatypes without specified max length using CreateDatabase()/Code-First approach is fixed

7.7.252 30-May-13

The bug with WebSecurity.Login() used with wrong credentials is fixed

LinqConnect (formerly known as LINQ to Oracle)

The bug with inserting dependent entity when the main entity has a key generator for the primary key property and DbGenerated is set to False is fixed
The bug with duplicate columns in an ORDER BY statement when using eager loading for several tables is fixed
The bug related to working with unmapped class members is fixed

Entity Developer

The "WCF DataMember Attribute on Navigation Properties" property is added to the DbContext and POCO templates for pointing the end (-s) where the attribute should be generated
The bug with placing tables names in the root of the "Choose change action" page of Update From Database Wizard is fixed
The bug with generating NRE when setting the output of the template to the unloaded project is fixed
The bug with adding many-to-many associations when one of the sides of the association is involved in the inheritance is fixed (LinqConnect)

Entity Framework support

The complex type generation for a return result set of a stored procedure is supported in EDM Wizard / Designer

7.7.242 16-May-13

LinqConnect (formerly known as LINQ to Oracle)

The possibility to disable query cache via the DataContext's 'EntityCachingMode' property is added
Creation of auto-incrementing sequences and triggers for Oracle models is supported
The bug with inheriting an entity class from an unmapped type is fixed
The bug related to the 'Index was outside of the bounds of the array' error when using GroupBy in queries is fixed
The bug with the materializer cache and AssociateWith method is fixed
The bug with the CreatedDatabase() method for many-to-many associations is fixed
The bug with AddDays() method with negative parameters is fixed
The bug with inserting record with composite primary key is fixed
The bug related to the "ORA-22835: Buffer too small for CLOB to CHAR or BLOB to RAW conversion" error, when comparing CLOB/NCLOB columns or parameters, is fixed

Entity Developer

The Save and Refresh buttons for persisting and reloading changes to / from a database is added to the Retrieve Data grid
POCO Entity template is improved: new template setting, "Property Change Notifiers", is added (LinqConnect models)
The behaviour is changed: a string default value for the property can be set without quotes in the Properties window
The behaviour is changed: the validation error is not generated when an abstract class is used in Table Per Type inheritance (Entity Framework models)
The bug with wrong detecting many-to-many associations is fixed (LinqConnect models)
The bug with mapping nested complex data types in the MSL part of the model in the synchronization mode is fixed (Entity Framework models)

7.7.226 23-Apr-13

Entity Developer

The bug with incorrect work of the Update Model From Database wizard for models containing stored procedures with parameters is fixed (Entity Framework models)

7.7.224 18-Apr-13

The behaviour is changed: provider's build action is installed on the target workstation, on which .NET Framework is available, without Visual Studio integration
The bug with NRE when processing an Oracle error during array insertion is fixed
The bug with stored procedure having a parameter with the default value, and the ParameterCheck and PassParametersByName OracleCommand properties simultaneously equal to 'true' is fixed

LinqConnect (formerly known as LINQ to Oracle)

The bug with query cache issues when working with one DataContext instance and different data providers is fixed
The bug with method Any() when working with one DataContext instance and different data providers is fixed
The bug related to the issue with the OnListChanged() event when EntitySet collection is changed is fixed

Entity Developer

The bug with loading mapping rules for some datatypes under .NET Framework 4.5 is fixed
The bug with wrong database script generation for tables with several many-to-many associations is fixed (LinqConnect models)

Entity Framework support

The error messages about long identifiers when using CreateDatabase/DropDatabase are improved

7.7.217 04-Apr-13

Workflow Foundation 4.5 is supported
The bug with truncating the last character of Out/InOut parameters of the CHAR/NCHAR type in the OCI mode is fixed
The bug with defining delete statement in SqlStatementExecute event handler is fixed

LinqConnect (formerly known as LINQ to Oracle)

LINQPad integration is supported
The bug related to the NullReferenceException on SubmitChanges() method when working with isVersion properties is fixed
The bug with using blank fixed-length strings is fixed

Entity Developer

A new MVC Controller template, generating a ASP.NET MVC controller with data access code, is added
A new MVC View Advanced template, generating an ASP.NET MVC view based in Twitter Bootstrap, is added
A new Data Transfer Object template for DTO classes generation is implemented
A new Data Annotation Metadata template, generating Data Annotation metadata classes and decorating classes and properties with data annotation attributes for validation, presentation and defining metadata, is added
A new WCF RIA Domain Service template, generating a WCF RIA Services domain service class for a Devart Entity Framework model is added
A new WCF RIA Domain Service template, generating a WCF RIA Services domain service class for a Devart LinqConnect model is added
Add Template dialog box is improved
The Namespace property of class, complex type, enum is implemented
The Entity Container Namespace properties of the model is implemented (Entity Framework models)
The support for enums declared in external assemblies is implemented
The capability for setting special rules for generating default names of database objects when using the Model First approach is implemented (a new Advanced page is added to the Synchronization->Database Naming section of the Model Settings dialog box)
The capability to customize properties that are automatically added when creating a new entity, and options that are automatically set when creating a new property is added (a new Initialization page is added to the Model->General section of the Model Settings dialog box)
The Refresh option in the Attributes tab of the Model Settings window is implemented; it updates the list of available attributes types in the referenced assemblies
The capability to modify custom attributes for several selected entities or properties at the same time is implemented
Automatic adding of references to Entity Framework specific assemblies when adding a new Devart Entity model to a project is implemented
The capability to cancel metadata reading in wizards and Database Explorer is added
The "Recreate Database Tables" check box, which allows to drop and recreate database tables, is added to the "Update To Database" wizard
New setting "Detect Table Per Type inheritances", which enables automatic detection of TPT inheritances, is added for Create Model Wizard and model
The "Include Drop" check box for including DROP commands for database objects to the generated script is added to Generate Database Script Wizard
A new shortcut menu command "Include Related", which allows making a copy of the related objects in the specified diagram, is added
A new shortcut menu command "Add To Model with Related", which allows adding tables, related to the selected one, to the model, is added to the shortcut menu of tables in Database Explorer
A new shortcut menu command "Add On Diagram With Related", which allows creating an object and all the objects related to it on a diagram, is added to the shortcut menu of classes, complex types, and enums in Model Explorer
New "Simple" diagram skin is added for displaying a diagram in metro style
The "Default Width" diagram property for specifying the default width for newly created diagram shapes (entities, complex types and enums) is added
DbContext template is improved: a "WCF Data Contract Attributes" setting for generation of DataContract, KnownType, and DataMember attributes for classes and properties is added (Entity Framework models)
DbContext template is improved: "Implement INotifyPropertyChanging" and "Implement INotifyPropertyChanged" template settings are added (Entity Framework models)
DbContext template is improved: a new "Mapping Generation Strategy" property that determines the method of mapping generation is implemented (Entity Framework models)
POCO template is improved: a new "WCF Data Contract Attributes" setting for generating DataContract, KnownType, and DataMember attributes for classes and properties is added (Entity Framework models)
POCO template is improved: "Proxy Creation Enabled" setting is implemented (Entity Framework models)
POCO template is improved: new template settings, "Implement INotifyPropertyChanging" and "Implement INotifyPropertyChanged", are added (Entity Framework models)
Create Model Wizard is improved: it is now able to download and install the required 'EnityFramework' Nuget package for Entity Framework 6 models, and for models for Entity Framework 4 and 5 in case they use the DbContext template
The Storage Column Editor dialog box is improved: the possibility to specify different settings that were previously available only in the Properties docking window are implemented (Entity Framework models)
Class Editor is improved: the capability to edit extended property settings, such as validation, presentation, and facets, is added
Type Editor is improved: the capability to edit extended property settings, such as validation, presentation, and facets, is added
The "Rewrite connection string during regeneration" check box of Model Settings is implemented to determine whether to overwrite the connection string in the project config file with the one, currently set in Entity Developer for the model, each time when regenerating code for the model (LinqConnect models)
The behaviour is changed: "Save connection string in App.Config as" check box in Model Settings dialog box is renamed to "Use connection string from App.Config as" (LinqConnect models)
The behaviour is changed: now, when creating a new TPH discriminator column in Inheritance Editor, it has the string type by default
The behaviour is changed: the error is generated if the Abstract inheritance modifier is set for the class which is involved in the Table Per Type inheritance
The behaviour is changed: empty value is used in property editors instead of -1 for marking facets of class property without assigned value
The bug with the database script generation for the 'Delete Rule' association property is fixed (LinqConnect models)
The bug with closing connection in the generated method, which has multiple result sets, is fixed (Entity Framework models)
The bug with adding annotation:UseStrongSpatialTypes="false" automatically to CSDL of the model with Entity Framework version set to 5 or higher is fixed

7.6.202 14-Mar-13

The behaviour is changed: array with the length over 2000 bytes now is not automatically trimmed when sending a parameter value of the OracleDbType.Raw type
The bug with creating Relations in DataSet Wizard when tables reside in different schemas is fixed

LinqConnect (formerly known as LINQ to Oracle)

The bug with DataLoadOptions.AssociateWith() when working with several DataContext objects is fixed
The bug related to the "Specified cast is not valid" exception when working with auto-increment primary keys mapped to decimal entity property is fixed

Entity Developer

The bug with detecting changes in the Collation attribute of the column in SSDL by Update Model From Database wizard is fixed (Entity Framework models)
The bug with obtaining DebuggerService when working with T4 Editor is fixed (LinqConnect models)

Entity Framework support

Entity Framework 6 Alpha 3 is supported
The bug with the AddMonths and AddYears canonical functions is fixed
The bug with creating and removing primary key and index, which are built for the same set of columns, in Code-First Migrations is fixed

7.6.192 28-Feb-13

ExtendedMembership (SimpleMembership) provider support is added
The bug with memory leak when handling the errors that occur during command execution in the OCI mode is fixed
The bug with wrong data written to the NCLOB field with OracleObject in the Direct connection mode is fixed
The bug with using stored procedures with the XMLTYPE parameter in Oracle Package Wizard is fixed
The bug with quoted identifiers in Migration Wizard is fixed
The bug with creating Relations in DataSet Wizard is fixed

Entity Developer

The possibility of setting enum values via predefined dropdown list in the Retrieve Data window is implemented
The bug related to the stored procedures with miltiple resultsets is fixed (LinqConnect models)

Entity Framework support

The bug with generating ON DELETE CASCADE when adding foreign key constraint to the table with the CreateDatabase/CreateDatabaseScript functionality of ObjectContext is fixed

7.5.179 07-Feb-13

The bug with Oracle session hanging after AppDomain has been unloaded is fixed
The bug with setting a parameter of the Date type with value equal to empty PL/SQL Table in the Direct connection mode is fixed
The bug with generating ORA-01017 when the user id connection string parameter contains "@" or "." is fixed

LinqConnect (formerly known as LINQ to Oracle)

The bug related to creation of a new instance of DataContext when using fluent mapping with the 'Database Independent = true' property is fixed
The bug related to the "Cannot add query to cache. An item with the same key already exists" exception in multi-threading applications is fixed

Entity Developer

The behaviour is changed: the serializing property and corresponding methods are not generated when using 'Fluent Mapping'/'POCO Entity' templates and Unidirectional mode (LinqConnect models)
The behaviour is changed: warnings about tables/views without primary keys are written to Error List window when generating a model (Entity Framework models)
The behaviour is changed: the EntityKey attribute is not assigned to each property of the class if there is no primary key in the corresponding table/view (Entity Framework models)
The behaviour is changed: empty value is used in property editors instead of -1 for marking facets of Storage Column without assigned value (Entity Framework models)
The bug related to wrong script generating in "Update Database From Model" wizard when setting a property as 'Nullable=false' and setting the default value is fixed

7.5.164 17-Jan-13

The behaviour is changed: ORA-01403 is treated as an information message only for select statements
The bug that occurred when working with the Tables Type of the Object Type in the Direct mode is fixed
The bug with generating NullReferenceException when using four restrictions with the Columns collection of the OracleConnection.GetSchema method is fixed
The bug with the ExecuteArray method when connecting to the UTF8 (Unicode) database in the Direct mode is fixed

LinqConnect (formerly known as LINQ to Oracle)

The bug related to the "Cannot convert from 'string' to 'Devart.Data.Linq.Mapping.DeleteRule' " error when working with Fluent mapping is fixed

Entity Developer

The bug with generating "The Type ... is not qualified with a namespace or alias. Only primitive types can be used without qualification." error, when EntityFramework.dll is located in GAC v4.0, is fixed
The bug with duplicate entries in the Base Class Condition and Derived Class Condition dropdowns of Inheritance Editor is fixed (Entity Framework models)

Entity Framework support

Entity Framework 6 Alpha 2 is supported
Devart.Data.Oracle.Entity.dll assembly compiled with EntityFramework.dll 6.0 and NET Framework 4.0 is added
Devart.Data.Oracle.Entity.SharpMap.dll assembly compiled with EntityFramework.dll 6.0 and NET Framework 4.0 is added
Support for mapping CHAR(1) to System.Boolean is added
Support of custom filters when using the System.Data.Entity.Design functionality in the config.QueryOptions.AdvancedMetadataQuery mode is implemented
The behaviour is changed: the constraint name is ignored when a table primary key is deleted when running Code-First Migrations, that allows successful deletion of automatically named primary key

7.4.146 20-Dec-12

The bug with using an Oracle object from several connections to the same database in the Direct mode is fixed
The bug, that occurred when editing an existing Dataset in DataSet Wizard and which was associated with incorrect processing of 'Select command text' for Data tables having DataSource set to TableAdapter, is fixed
The bug with the Korean character set KO16MSWIN949 or KO16KSC5601 when a string parameter contains an empty string or DBNull in the Direct mode is fixed

LinqConnect (formerly known as LINQ to Oracle)

The bug related to the "Object does not match target type" exception when working with DbLinqDataSources and gridviews is fixed
The bug with the implicitly converting strings to integer type in queries when working with VB.NET projects is fixed
The bug related to the "Unsupported delete rule 'NO ACTION'" exception when creating DataContext is fixed
The bug with update commands for dependent entities that participate in Table Per Type inheritance is fixed

Entity Developer

Support for spatial data types in Entity Framework 5 models is added
Model Refactoring feature is implemented; it speeds up creating complex types and Table Per Type and Table Per Concrete Type inheritances from several model entities
Create Storage and Mapping command, that allows automatically creating of the corresponding storage part object and defining mapping, is added to the shortcut menu of classes, properties, and associations (Entity Framework models)
Select Storage Object command, that allows quick navigation to the corresponding storage part object, is added to the shortcut menu of classes, properties, associations, and methods (Entity Framework models)
The possibility to delete the corresponding storage part objects automatically when deleting conceptual model objects is added (Entity Framework models)
The functionality of ignoring columns in the database in the "Update To/From Database" wizards if they were omitted once before is implemented
The Property Editor dialog is improved: fast access to the editor of the corresponding storage object and the possibility to specify different settings that were previously available only in the Properties docking window are implemented (Entity Framework models)
The Inheritance Editor dialog is improved: specifying Discriminator column for Table Per Hierarchy inheritance in the editor is implemented (Entity Framework models)
The Class Editor dialog is improved: fast access to the editor of the corresponding storage object is implemented (Entity Framework models)
The Method Editor dialog is improved: fast access to the editor of the corresponding storage object is implemented (Entity Framework models)
The naming algorithm for the newly-created columns, which correspond to complex type's properties, when using the Model First approach is improved (Entity Framework models)
Warnings about objects that are not mapped are added
A SHIFT+DELETE keyboard shortcut for deleting entity, complex type, or enum from diagram only is added
An INSERT keyboard shortcut for creating a new entity, adding property to the selected entity/complex type or new member to enum is added
The possibility to view notes, added through the "Documentation" property, for all the diagram objects via hints is implemented
Hints for diagram objects are improved
The behaviour is changed: Configure Behaviour dialog is renamed to Stored Procedure Mapping; options for hiding inappropriate and mapped stored procedures are added (Entity Framework models)
The behaviour is changed: Table Editor dialog is renamed to Storage Entity Editor (Entity Framework models)
The behaviour is changed: Stored Procedure Editor dialog is renamed to Storage Procedure Editor (Entity Framework models)
The behaviour is changed: Configure Behaviour dialog is renamed to Stored Procedure Mapping (LinqConnect models)

7.3.132 29-Nov-12

Visual Studio 2005 support is discontinued

LinqConnect (formerly known as LINQ to Oracle)

The fluent mapping is improved: support of the ID generators for primary keys is added
The bug with the "Specified cast is not valid" exception when searching for an entity by its key is fixed
The bug with the failed updates to the database when using the Attach(TEntity,Boolean) method is fixed

Entity Developer

The possibility to set different namespaces for the context and its entities when using the DbContext template is implemented (Entity Framework models)
The bug with generating the using directives for redundant namespaces is fixed (Entity Framework models)
The bug with renaming the navigation property when using the Update Model From Database wizard is fixed (LinqConnect models)

Entity Framework support

Support for spatial data types in Entity Framework 5 is added
Oracle Spatial MDSYS.SDO_GEOMETRY support in Entity Framework 5 is added
SharpMap GIS library support in Entity Framework 5 is added (new Devart.Data.Oracle.Entity.SharpMap.dll assembly is added)
Devart.Data.Oracle.Entity.Migrations.dll assembly built with the 5.0 version of EntityFramework.dll is added
Devart.Data.Oracle.Entity.dll assembly built with the 4.5 version of .NET Framework is added
The config.QueryOptions.AdvancedMetadataQuery option (default value is False) is added to turn on the advanced metadata query mode like the one which is used by Visual Studio Entity Data Model Wizard
The bug with the IgnoreSchemaName and IgnoreDboSchemaName options when working with EdmFunction is fixed

7.2.122 15-Nov-12

The bug with the query containing the colon symbol inside single and double quotes is fixed
The bug with the NVARCHAR parameters in the Direct mode is fixed
The bug with using the OracleDbType.Char parameters in the Unicode mode is fixed

LinqConnect (formerly known as LINQ to Oracle)

The bug with using blank fixed-length strings is fixed
The bugs with using LinqConnect for Dynamic Data projects under .NET Framework 4.0 or higher are fixed

7.2.114 01-Nov-12

The bug with sending the commit and rollback events for connections in the distributed transaction to dbMonitor is fixed
The bug with retrieving data in the Direct mode, when the Unicode connection string parameter is True and NLS_CHARACTERSET of the database is ZHS16GBK, is fixed
The bug with using the OracleDbType.VarChar parameters in the Direct mode, when the Unicode connection string parameter is False and NLS_CHARACTERSET of the database is ZHS16GBK, is fixed
The bug with parameters having the string type and the KO16MSWIN949 or KO16KSC5601 charset in the Direct mode is fixed

Entity Developer

The bug with availability of the Yes/No/Cancel options when saving models created with previous versions of Entity Developer is fixed

7.2.104 18-Oct-12

The Lob Block Size connection string parameter is implemented to determine the size of a block (in megabytes) to read/write CLOB or NCLOB data in the OCI mode when working with Unicode server
The bug with the OracleScript.CommandTimeout property not changing its value when setting the DefaultCommandTimeout parameter of the connection string is fixed
The bug with the new line character in the connection string is fixed

LinqConnect (formerly known as LINQ to Oracle)

The bug with working with entities without INotifyPropertyChanging, INotifyPropertyChanged interfaces is fixed

Entity Developer

The bug with disposing EntityCommand in the code generated for calling stored procedure is fixed (Entity Framework models)

Entity Framework support

The SQL generation for the .Substring(startIndex) method is optimized
The bug with DropDatabase() and CreateDatabase(), when DeleteDatabaseBehaviour.ModelObjectsOnly is used, in EF v4.3 and higher is fixed
The bug with DropDatabase() and CreateDatabase(), when IgnoreDboSchemaName option is enabled and DeleteDatabaseBehaviour.Schema is used, in EF v4.3 and higher is fixed
The bug related to the "An item with the same key has already been added" exception when importing stored procedures with several parameters to the Entity Data Model is fixed

7.2.96 04-Oct-12

The possibility to send/retrieve XMLTYPE in Oracle Advanced Queue is implemented: the OracleQueueMessage.XmlPayload property is added
Array binding memory usage with VarChar/NVarChar parameters is reduced
The behaviour is changed: the quote symbols will be ignored in the password value in the Direct mode
The bug with using the OracleDbType.VarChar parameters in the Direct mode, when the Unicode connection string parameter is True and NLS_CHARACTERSET of the database is ZHS16GBK, is fixed
The bug with freeing temporary tablespace when creating multiple LOBs in the OCI connection mode is fixed
The bug with workability of the OracleGlobalization.ClientCharacterSet property is fixed
The bug with generating AccessViolationException when retrieving data via OracleDataReader using the x64 version of Oracle client is fixed
The bug with deploying Analysis Services Project when using the x64 version of SQL Server Analysis Service is fixed

LinqConnect (formerly known as LINQ to Oracle)

The bug related to the "An item with the same key has already been added" exception when working with DevExpress GridView is fixed
The bug with synchronization of the parent and child entities is fixed
The bug with update checks of CLOB columns is fixed

Entity Developer

Predefined template for generating Repositories and Unit of Work classes is added
Integration with Visual Studio refactoring for renaming model objects is implemented
The "Use Database Comments" option of Model Settings is implemented to determine whether comments for database objects, if supported by DBMS, will be used for model objects Documentation initialization and taken into account when executing model or database update operations
The "Implement IClonable" option for the generated classes based on the model entities is added to all templates
The behaviour is changed: the "Save connection string in App.Config as" option is available for LinqConnect models in the standalone version Entity Developer (the entry in App.Config must be added manually afterwards)
The bug with generating complex type for the method when adding procedure with SYS_REFCURSOR return parameter from store part of the model is fixed (Entity Framework models)

Entity Framework support

The config.CodeFirstOptions.UseDateTimeAsDate option (default value is False) is added to treat DateTime properties without an explicitly specified server data type as DATE
The bug with setting configuration options via the application config file is fixed
The bug with setting the configuration options for Entity Framework v1 is fixed
The bug with creating DATE parameters when using LINQ to Entities is fixed
The bug with Entity Data Model Wizard/LightSwitch when an access to the objects from the MDSYS schema was required is fixed
The bug with demanding extra permissions when running under restricted user account is fixed

7.2.77 06-Sep-12

Visual Studio 2012 is supported
The bug with getting 'ORA-01403' under recurrent execution of a select query is fixed
The bug with the ExecuteArray method when one of parameters is an empty NClob is fixed
The bug with setting a parameter value equal to empty PL/SQL Table in the Direct connection mode is fixed
The bug with Local Time Zone not applied for Timestamp With Local Time Zone columns in Direct mode is fixed
The bug with using the OracleDbType.VarChar parameters in the Direct mode is fixed

LinqConnect (formerly known as LINQ to Oracle)

The bug with getting entities from the cache by keys of type Int16 is fixed
The bug with getting entities directly from the cache for the command First (predicate) etc, is fixed
The bug with wrong parameters when loading dependent entities with two-level LoadOptions are set is fixed

Entity Developer

Support for ADO.NET Entity Framework 5 is added
The 'Entity Base' class property, which allows specifying the ancestor class/interface for a particular entity type, is implemented (LinqConnect models)
The behaviour is changed: when preserving schema name is disabled, schema name is no more saved for Oracle package functions/procedures (LinqConnect models)
The behaviour is changed: only particular (not all) property characteristics are regenerated when using Update Model From Database wizard after the metadata of the corresponding column have been changed (LinqConnect models)
The bug with quoting CURRENT_TIMESTAMP if it is specified in the defaultValue attribute of the property in the storage part of the model is fixed (Entity Framework models)

Entity Framework support

ADO.NET Entity Framework 5 is supported
The config.CodeFirstOptions.UseNonLobStrings option (default value is False) is added in order to treat string properties without an explicitly specified server data type as non-LOB
The behaviour is changed: Devart.Data.Oracle.Entity.Migrations.dll is built with the 4.4 version of EntityFramework.dll now
The bug with using command delimiters when generating the Code-First Migrations script in Package Manager Console of Visual Studio is fixed
The bug with using NULL values in Out/InOut parameters of stored procedures is fixed
The bug with using pipelined functions which are pushing out the RECORD objects is fixed

7.1.58 09-Aug-12

The bug with "invalid OCI handle" exception during a distributed transaction rollback is fixed
The bug with inserting a string with OracleUtils.OracleClientCompatible mode and 'Unicode=false' connection string parameter is fixed
The bug when connection to Oracle 8.0 database in Direct mode hangs is fixed
The bug with the OracleDbType.Char command parameter when using the "Unicode=true;" connection string parameter in the Direct mode is fixed

LinqConnect (formerly known as LINQ to Oracle)

The bug with creating DataContext with complex types having no default mapping is fixed
The bug with modifying the list of tracked entities when it is being enumerated is fixed
The bug with clearing the collection of depending entities is fixed
The bug with comparing nvarchar datatype strings is fixed
The bug related to the Oracle constants with empty strings is fixed
The bug with materializing result sets of Oracle procedures with single output cursor is fixed
The bug with datetime literals as default COALESCE arguments is fixed

Entity Developer

The possibility to unload assemblies from the main application domain by using separate application domain is implemented
The possibility to disable such Database First Settings as type mapping rules is implemented
The design time copy/cut/paste functionality for enum members is added
The bug with generating the "This model has been modified outside of the editor. Do you want to reload it?" error when Entity Developer is integrated into TFS is fixed
The bug with integration into TFS is fixed

Entity Framework support

The config.QueryOptions.UseCSharpNullComparisonBehavior configuration option for checking for NULL when comparing a nullable property (column) or an expression with a variable (parameter) in LINQ to Entities is implemented (by default, false)
The config.QueryOptions.CaseInsensitiveComparison option is implemented to manage the compare behaviour when using Linq to Entities comparison expression such as "a == b" (by default, false)
The behaviour is changed: Substring() in LINQ queries is now translated to DBMS_LOB.SUBSTR for LOBs
The bug with automatic setting of the ColumnTypeCasingConventionCompatibility configuration option to True when using EF Code-First 4.3 or higher and ObjectContext with XML mapping (the attributes of the EdmSchemaAttribute assembly level) simultaneously is fixed
The bug with comparing char fields in the non-unicode mode is fixed

7.1.40 17-Jul-12

The bug with ORA-01460 in the Direct mode when the Unicode connection string parameter equals true is fixed
The bug with the multiple usage of the same parameter in the query containing returning in the Direct mode is fixed
The bug with NullReferenceException under the transaction rollback of a connection placed into the pool is fixed

LinqConnect (formerly known as LINQ to Oracle)

The bug with enumerating queries that have empty result sets is fixed
The bug with materializing query results into invalid object properties is fixed
The query cache bug with distinguishing compiled queries that have nullable parameters is fixed
The bug with deleting many-to-many links of entity having multiple many-to-many associations is fixed

Entity Developer

The overloaded stored procedures and functions are supported
The behaviour is changed: the warning, related to the missing property setter, is disabled (LinqConnect models)
The behaviour is changed: for the association, in which the many-side entity hasn't the primary key, the code and the mapping are not generated (LinqConnect models)
The behaviour is changed: the properties, that correspond autoincrement fields, are generated with a ReadOnly keyword in VB.NET (LinqConnect models)

Entity Framework support

The support of the Oracle Text full-text search functionality is implemented
The OracleTextFunctions class for working with Oracle Text functions in LINQ to Entities is added
The OracleCtxDdlPackage class for working with Oracle Text stored procedures of the CTX_DDL package is added
The OracleCreateIndexConfiguration class for customizing the CreateIndex operation in Code-First Migrations is improved
The OracleDropIndexConfiguration class is added for customizing the DropIndex operation (deleting Oracle Text indexes) in Code-First Migrations
The existing configuration classes for customizing the Code-First Migrations operations are renamed - the "Oracle" prefix is added (for example, the CreateTableConfiguration class was renamed to OracleCreateTableConfiguration); derived classes with the old names are added for backward compatibility
Creating indexes for FK columns in Code-First CreateDatabase functionality is implemented
The config.DatabaseScript.ForeignKey.IndexCreation configuration option is added (default value is True)
The config.DatabaseScript.ForeignKey.IndexTablespace configuration option is added to provide the possibility of setting the TABLESPACE, in which the index, created for the columns being parts of the foreign key, should be placed
The option of setting ConcurrencyCheck for CLOB/NCLOB columns (for better support of LightSwitch) is implemented
Overloads for the ToChar/ToNchar methods of the OracleFunctions class are added
The possibility of setting configuration options via the application config file is implemented
The Devart.Data.Oracle.Entity.xsd file is added to the installation in order to simplify setting and validating the application config file settings when using the XML Editor
Code-First Migrations now supports specifying the schema (database) the table belongs to
The config.Workarounds.IgnoreDboSchemaName configuration option is added. The option is automatically set to True, if Code-First (Migrations) EF v4.x/5.x is used
The ColumnTypeCasingConventionCompatibility configuration option is moved from Workarounds to CodeFirstOptions (now it is config.CodeFirstOptions.ColumnTypeCasingConventionCompatibility). For the backward compatibility a wrapper property remains in Workarounds
The config.CodeFirstOptions.UseNonUnicodeStrings configuration option (default value is False) is added in order to treat string properties without an explicitly specified server data type, as non-unicode
The config.CodeFirstOptions.TruncateLongDefaultNames configuration option is added (default value is False) to provide the possibility of truncating long default names of indexes, primary keys, foreign keys, triggers, and sequences generated by Code-First Migrations
The overloaded stored procedures and functions are supported in Entity Framework runtime
CASE generation is improved
The behaviour is changed: the ColumnTypeCasingConventionCompatibility configuration option is automatically set to True for EF v4.3.x & 5.x. If you use DbContext with XML mapping (in EF v4.1 & v4.2), from now on you should explicitly set ColumnTypeCasingConventionCompatibility=False
The behaviour is changed: in case of using Code-First (Migrations) EF v4.x/5.x the schema name 'dbo' will be ignored by default
The bug with inserting data into MigrationHistory table when working with Oracle 10g is fixed

7.0.25 21-Jun-12

LinqConnect (formerly known as LINQ to Oracle)

The bug with deleting the entity and its many-to-many bunches outside the batch is fixed

Entity Developer

The "Pluralize collection navigation properties" option for the possibility to turn off the pluralization of the many-end names of associations is implemented
The "sealed override" inheritance modifier for methods based on stored procedures and functions is added (LinqConnect models)
The behaviour is changed: System.Int64 is mapped to Number(19) now when using Model First approach
The bug with copy/pasting entities having a common relation is fixed
The bug with generating redundant column in SSDL when setting one-to-one association in the designer is fixed (Entity Framework models)
The bug with generating the MSL mapping for one-to-one association is fixed (Entity Framework models)
The bug with the displaying many-to-many associations in the Association Editor is fixed (LinqConnect models)
The bug with specifying the custom tool for LinqConnect models being added to web sites is fixed (LinqConnect models)
The bug with mapping generation for associations with the 'Delete On Null' rule enabled is fixed (LinqConnect models)
The bug with mapping generation for entity types having multiple complex types is fixed (LinqConnect models)

Entity Framework support

The behaviour is changed: the generation for the comparison of a column and an empty string literal in LINQ to Entities (column == "") is translated into the check if the column is equal to NULL in SQL (column IS NULL) now

7.0.17 07-Jun-12

Visual Studio 2012 Release Candidate is supported
The Initialization Command connection string parameter is implemented
The behaviour is changed: the 'sender' parameter in MonitorEventHandler is a connection and the MonitorEventArgs.ExtraInfo property is filled with the connection string
The bug with auto-generation of UpdateCommand for OracleDataAdapter with OracleCommandBuilder when column name is "TYPE" is fixed
The bug with the Oracle Migration Wizard malfunction is fixed

LinqConnect (formerly known as LINQ to Oracle)

The CreateDatabase bug with creating a table for an entity type with multiple complex type fields is fixed
The CreateDatabase bug with creating a table for an entity type with no primary key is fixed
The bug with 'IS NULL' checks for non-nullable columns is fixed

Entity Developer

The bug with the failure to read the complex type's Access property value is fixed (Entity Framework models)
The bug with saving *.edml when importing data from *.edmx is fixed (Entity Framework models)

Entity Framework support

The config.CodeFirstOptions.RemoveSchemaFromDefaultConstraintName option for removing schema name from the default constraint name is implemented in Code-First Migrations (by default, true)
The config.CodeFirstOptions.AddTableNameInDefaultIndexName option for adding a table name to the default index name is implemented in Code-First Migrations (by default, true)
The config.CodeFirstOptions.DisableIndexQuoting option is implemented for a backward compatibility with migrations which use indexes, generated and applied in the 6.xx versions
The bug with quoting indexes in Code-First Migrations is fixed
The bug with HistoryTable in Code-First Migrations when using the DisableQuoting option is fixed
The bug with adding a schema prefix to default constraint name (PK and FK) in Code-First Migrations is fixed

7.0.6 22-May-12

The support for executing PL/SQL blocks using the OracleCommand.ExecuteArray method in the Direct mode is added
The support for the Batch Errors mode in the OracleCommand.ExecuteArray method in the Direct mode is added
The behaviour is changed: now the general exception is not added to the OracleException.Errors collection when executing a DML array
The behaviour is changed: an existing internal connection is used now if connections with the same connection string are opened and closed several times in scope of a distributed transaction for the case when there are several connections with different connection strings in the transaction
The behaviour is changed: the access modifier of the connectionString field of web provider classes is changed from private to protected
The bug with opening connection with multibyte or Unicode client character set when User Id contains non-ASCII symbols in the Direct mode is fixed

LinqConnect (formerly known as LINQ to Oracle)

References to System.Data.Linq are removed; now LinqConnect uses only its own classes
Upgrade wizard for upgrading projects to the new version of LinqConnect automatically is added
The possibility to choose cache mode (classic mode for cases when DataContext is used as a unit of work, and self-cleaning mode for cases when DataContext is a long-lived object) is added
The possibility to map stored procedure out parameters of the CURSOR type to IEnumerable parameters of the corresponding methods is added
Tracking of complex object graphs with chains of parent-child objects is optimized
Number of database calls required for managing objects with a many-to-many association is reduced
Delete rule performance is improved
Compilation performance is improved
Materialization performance is improved
Compiled query cache is improved

Entity Developer

The precision facet for DateTime and DateTimeOffset properties is supported
The sticker notes for adding comments to diagrams are implemented
The possibility to add a stamp, specifying diagram author, company, version, copyrights, project name, and date, to a diagram is implemented
New Collapse All and Expand All menu commands for collapsing and expanding diagram shapes are added
The behaviour is changed: context menu commands for working with diagram are grouped to the Diagram submenu of the context menu
The behaviour is changed: the possibility to change diagram shape color via the corresponding Shape -> Color context menu command is added
The behaviour is changed: when pasting a copied entity to a new diagram, a new entity is not created, the existing entity is added to this diagram
The behaviour is changed: when cutting an entity from the diagram, the entity is not cut from the model, only from the diagram
The behaviour is changed: "Update Model From Database" wizard places newly added properties to the base abstract class now instead of putting them into child classes where the mapping is (Entity Framework models)
The behaviour is changed: System.Double is mapped to Number now when using Model First approach (Entity Framework models)
The behaviour is changed: the CSDL property is left unchanged when the corresponding SSDL property is regenerated (Entity Framework models)
The behaviour is changed: the association names are generated basing on the database FK names when using Database First approach (Entity Framework models)
The behaviour is changed: when FluentMapping=true and DatabaseIndependent=false, the DbContext template generates the server types names which are compatible with the ColumnTypeCasingConventionCompatibility mode (Entity Framework models)
The bug with generating code using DbContext template, when template's Fluent Mapping property is set to True and one of the navigation properties of an association is turned off, is fixed (Entity Framework models)
The bug with reading one-to-many associations from the *.edmx file is fixed (Entity Framework models)
The bug with creating complex type for result set of function import is fixed (Entity Framework models)
The bug with "DevartEntityDeploy" task when only .NET Framework 4 is installed is fixed (Entity Framework models)
The bug with closing connection in the generated method of the context is fixed (Entity Framework models)
The bug with incorrect saving of method's extended properties is fixed (LinqConnect models)

Entity Framework support

Entity Framework 5.0 Release Candidate is supported
The support of fractional seconds for TIMESTAMP, TIMESTAMP WITH TIME ZONE, and TIMESTAMP WITH LOCAL TIME ZONE in Entity Data Model Wizard/Generate Database Wizard and Code-First CreateDatabase functionality is added
The behaviour is changed: by default in Model-First and Code-First approaches the DateTime property is not TIMESTAMP anymore, but TIMESTAMP(7), and the DateTimeOffset property is TIMESTAMP(7) WITH TIME ZONE
The bug with fractional seconds during SQL generation of DateTime and DateTimeOffset constant literal is fixed
The bug with stored procedure Out/InOut numeric parameters is fixed
The bug with incorrect XMLTYPE null value generation is fixed

6.80.350 26-Apr-12

The bug with NullReferenceException in the OracleDataReader.GetSchemaTable() method is fixed
The bug with truncating the last character in values of VARCHAR output parameters is fixed
The bug with the OracleCommand.ExecuteArray method when one of parameters has type equal to LONG or LONG RAW is fixed

Entity Developer

The multiline popup editor for the Documentation.Summary property is implemented
The bug with validation of column name length in "Update To Database" and "Generate Script" wizards is fixed
The bug with metadata processing in Visual Studio 11 Beta is fixed (Entity Framework models)
The bug with incorrect mapping of System.Int32 when using Model First approach is fixed (Entity Framework models)
The bug with generating the "String was not recognized as a valid Boolean" error in Defining Query Editor is fixed (Entity Framework models)

6.80.341 12-Apr-12

The OracleNotificationRequest.QueryBasedNotificationMode property for selecting the best-effort or guaranteed query result notification mode is added
The OracleNotificationRequest.Operations property for the selection of operations, for which notifications should come, has been added
The DirectUtils.OldAuthMode property for using the old password encryption algorithm during authentication in the Direct mode is added
Usage of any symbols in the OracleParameter.ParameterName property for the stored procedure is supported
The behaviour is changed: the best-effort query result notification mode is used by default in OracleDependency
The bug with ignoring the OracleDependency.Port value is fixed
The bug with using the OracleDataReader.GetTimeSpan method for INTERVAL DAY TO SECOND column is fixed
The bug with the InvalidCastException in the OracleCommand.ExecuteArray method when parameter value is an array with the first element DBNull.Value is fixed

LinqConnect (formerly known as LINQ to Oracle)

The bug with the performance issues when generating complex queries is fixed

Entity Developer

The behaviour is changed: the Migrate option is added to the context menu of property in Model Explorer
The behaviour is changed: entities and enums on the designer surface are more resizable now
The bug with creating LinqConnect models is fixed
The bug with detecting many-to-many associations is fixed (Entity Framework models)

Entity Framework support

The OracleFunctions.SysExtractUtc(DateTimeOffset?) overload is added

6.80.332 29-Mar-12

The handling of empty options in the connection string is improved
The bug with creating an invalid temporary NCLOB is fixed
The bug with OracleDataReader.Read() in Mobile Edition is fixed
The bug with setting an incorrect LockExpiration when creating a lock owner in Oracle Workflow Instance Store is fixed

LinqConnect (formerly known as LINQ to Oracle)

The bug with the generation of SQL queries including grouping by the whole entity is fixed

Entity Developer

The bug with model saving after performing copy/paste of an element with a custom attribute is fixed
The bug with incorrect generation of a create database script in the "Generate Database Script" wizard for Entity Framework models, which occurs when the Regenerate Storage check box is selected, is fixed
The bug with code generation for association basing on several EntityKey properties when using POCO Entity and Self-Tracking Entity Visual Basic templates is fixed (Entity Framework models)
The bug with the "Update Model From Database" wizard showing isVersion columns as changed is fixed (LinqConnect models)

Entity Framework support

Entity Framework 5.0 Beta 2 is supported
The behaviour is changed: Devart.Data.Oracle.Entity.Migrations.dll is built with the 4.3.1 version of EntityFramework.dll now
The bug with using expression aliases in complex queries is fixed

6.80.325 15-Mar-12

Visual Studio 11 Beta is supported
The performance of OracleDataAdapter when using MissingSchemaAction.AddWithKey is improved

LinqConnect (formerly known as LINQ to Oracle)

The bug with column order in queries including the UNION clause is fixed
The bug with InvalidOperationException on disposing data contexts is fixed

Entity Developer

The copy/cut/paste functionality is added for objects of the conceptual part of a model
The possibility to drag&drop properties between classes in Model Explorer is implemented
The "HeaderTimestampVersionControlTag" generation template option is added for improving integration with version-control systems
The bug with generating code when using stored procedures with multiple result set with the POCO Entity and Self-Tracking Entity templates is fixed (Entity Framework models)
The bug with parsing XML entries when using stored procedures with multiple result set is fixed (Entity Framework models)
The bug with setting StoreGeneratedPattern to Identity for foreign key property of the child class when creating an association is fixed (Entity Framework models)
The bug with generating mappings for many-to-many association of entity to itself is fixed

Entity Framework support

Entity Framework 5.0 Beta 1 is supported
SQL generation for .Any method in LINQ to Entities is improved
The possibility to specify the sequence and trigger names via CreateTableConfiguration and DropTableConfiguration classes in Code-First Migrations is implemented
The bug with validation of identifier name length in Code-First Migrations is fixed
The bug with removing table's sequence when invoking DropTable in Code-First Migrations is fixed

6.70.311 27-Feb-12

The promoted properties feature of Oracle Workflow Instance Store is implemented
The support for BINARY_DOUBLE and BINARY_FLOAT data types in Direct mode is added
The behaviour is changed: one internal connection is used now if connections with the same connection string are opened and closed several times in scope of a distributed transaction
The bug with CLOB data type in Direct mode, when NLS_CHARACTERSET of a server is set to AL24UTF8, is fixed
The bug with Arguments metadata table, that does not contain a row for return value of a function, is fixed
The bug with IndexOutOfRangeException on getting zero value using the OracleDataReader.GetByte method is fixed
The bug with adding records in ServiceDeploymentsTable of Oracle Workflow Instance Store is fixed

Entity Developer

The validation of method parameters in LinqConnect models is added
The context menu options for unchecking changed/added/dropped tables are implemented for the root nodes in the "Update To/From Database" wizards
The possibility to rename the storage part of the model in Model Explorer is implemented (Entity Framework models)
The diagram design is changed: an arrow (instead of a triangle) is used on the tip of an association now
The bug with setting comments for columns and tables in database is fixed
The bug with adding the MaxLength attribute to the NCLOB properties in SSDL is fixed (Entity Framework models)
The bug with adding redundant navigation properties by "Update Model From Database" wizard to the model with TPH inheritance is fixed (Entity Framework models)

Entity Framework support

Entity Framework 4.3 (Code First Migrations) is supported
The validation of identifier name length in Code-First Migrations is implemented
The conversion of .StartsWith, .Contains, .EndsWith to LIKE clause in the generated SQL for the case of expression-based condition is supported
The Code-First Migrations behaviour is changed: if the nullable value of the property in migration is not set explicitly, the corresponding column will be created nullable

6.70.302 09-Feb-12

The behaviour is changed: The Value property of PL/SQL array output parameters now returns an array with the length equal to the length of the value, returned by Oracle
The bug with OracleCommandBuilder.DeriveParameters method when executing procedure without parameters from package in Direct mode is fixed
The bug with parsing a value of the OracleNumberMappings connection string parameter for some languages of system locale is fixed
The bug with using SQL Server Analysis Services ("Index was outside the bounds of the array") is fixed
The bug with unicode user names in the Direct mode is fixed

Entity Developer

Materialized view support is added
The bug with preserving the Validate Required property when saving the model is fixed
The bug with Entity Developer tool windows being shown when debugging an application is fixed
The bug with diagram representation in x64 environment is fixed

6.70.293 27-Jan-12

The support for OBJECT, TABLE, VARRAY, REF, XMLTYPE data types in Direct mode is added
The support for Oracle 9i, Oracle 10g, and Oracle 11g authentication in the Direct mode is added
The support for username/password containing national characters in the Direct mode is added
The OracleTrackingBehavior and OracleTrackingElement classes for enabling Oracle Workflow Tracking using a configuration file are added
The bug with enabling Oracle Workflow Instance Store using a configuration file is fixed
The bug with NRE when using bookmark resumption tracking records in Workflow Tracking is fixed
The bug with OracleDataReader returning null value for Object, Array, Table, Xml, AnyData columns instead of returning an empty value of the corresponding type is fixed

LinqConnect (formerly known as LINQ to Oracle)

The bug with empty spaces in foreign key names generated by the CreateDatabase() method is fixed

Entity Developer

The documentation generation for navigation properties is implemented
The "Recreate Model" option, allowing to rebuild the model from a scratch, is added to the "Update Model From Database" wizard
The "GeneratePartialClass" template property to generate a partial class, which will not be overwritten by the designer, for each class in the model is added
The stored procedures support in DbContext template in case of XML mapping is implemented (Entity Framework models)
The behaviour is changed: database column comments are transfered to the Summary attribute of the Documentation property now
The bug with resetting the Validate Required property after reopening model is fixed
The bug with generating System.ComponentModel.DataAnnotations.KeyAttribute() for Primary Key columns is fixed
The bug with a workability of documentation links on Start Page is fixed
The bug with resetting the StoreGeneratedPattern attribute by the Update Model From Database wizard is fixed (Entity Framework models)
The bug with line breaks in default values of NUMBER columns is fixed (LinqConnect models)

Entity Framework support

Entity Framework 4.3 Beta 1 (Code First Migrations) is supported
Oracle-specific Code First Migration customizations are implemented
The bug with changing the default mapping for the 'Number' data type (with no precision and scale specified) is fixed

6.60.283 12-Jan-12

The bug with freeing parameter's NativeOracleObject right after query execution is fixed
The bug with the '-1' value of the MaxLength property for the columns with the string or varchar type, which are created by OracleDataAdapter, is fixed
The bug with NullReferenceException when executing a query with OracleObject, OracleArray, OracleTable parameters with Null value is fixed
The bug with OracleParameter array binding is fixed

Entity Developer

The documentation generation for Enum members is implemented
The "Detect function-based column default value" option for automatic setting StoreGeneratedPattern to Identity for corresponding columns is implemented for Entity Framework models (by default, false)
The algorithm for forming the Navigation Properties names, when there are several FOREIGN KEY constraints between the same tables, is changed
The behaviour is changed: the Navigation Property will not be displayed on the diagram and in Model Explorer if "Generate" is set to false for the appropriate association end
The behaviour is changed: the Validate Max Length attribute is synchronized with the Max Length attribute of Property by default now
The behaviour is changed: the Validate Required attribute is synchronized with the Nullable attribute of Property by default now
The behaviour is changed: when selecting a property in the Model Explorer, the corresponding entity on the diagram does not expand if it is collapsed
The bug with adding diagrams when the Notation parameter of the diagram "Property Details Level" is set to "Name And Type" is fixed
The bug with changing the Type property simultaneously for several inheritances is fixed
The bug with invalid Properties grid data refreshing for the selected attribute in the Attributes dialog box is fixed
The bug with constructing too long names when using Generate Database Script From Model is fixed
The bug with formatting indents when generating code is fixed
The bug with saving inheritance layout on the diagram is fixed
The bug with incorrect model diagram saving after deleting a complex type from a diagram is fixed
The bug with generating sequences and triggers for auto-incremented primary keys mapped to the properties of the System.Decimal type is fixed (LinqConnect models)
The bug with detecting result set parameters of stored procedures is fixed (Entity Framework models)
The bug when the names of constraints in the Store part of the model are not taken into account by Generate Database Script From Model wizard is fixed (Entity Framework models)
The bug with Retrieve Data when using DbContext template is fixed (Entity Framework models)
The bug with Table Per Hierarchy (TPH) when using abstract intermediate class between the base and derived classes is fixed (Entity Framework models)

Entity Framework support

The behaviour is changed: if an output cursor parameter of a stored procedure is not specified in the "Result Set Parameter" property, it will now be processed automatically
The bug with creating columns of national data types (NCHAR/NVARCHAR2/NCLOB) in Entity Framework Code-First CreateDatabase is fixed
The bug with using slashes in string parameters of the .Contains method is fixed

6.60.268 22-Dec-11

The bug with double attempt to connect in Direct mode is fixed
The bug with the 'ORA-01008: not all variables bound' error in Direct mode when working with NVarChar parameters is fixed
The bug with NVarChar parameters of OracleCommand in Direct mode is fixed
The bug with setting the PrimaryKey attribute of DataTable.Constraints when editing an existing DataSet using DataSet Wizard is fixed

Entity Developer

The bug with Visual Basic templates is fixed
The bug with duplicating EntitySet attribute when using entity return type is fixed (Entity Framework models)

Entity Framework support

The possibility of using Oracle optimizer hints in LINQ to Entities queries is implemented
The behaviour is changed: the BINARY_FLOAT and BINARY_DOUBLE data types are mapped to Single and Double correspondingly in Entity Data Model Wizard
The bug with generating CROSS JOIN statement when using LINQ to Entities is fixed
The bug with explicit usage of REF CURSOR parameters in stored procedures is fixed
The bug with config.DmlOptions.InsertNullBehaviour for non-EntityKey columns with initialized DefaultValue and StoreGeneratedPattern is fixed

6.60.258 08-Dec-11

Workflow Tracking support is implemented
Enabling Persistence for WAS-Hosted Workflow Services that use the WorkflowServiceHost using a Configuration File is supported
The bug with adding a unique constraint when fetching data more then from one table and using MissingSchemaAction.AddWithKey is fixed
The bug with trimming Oracle error messages is fixed
The bug in OracleScript with using BEGIN and DECLARE as a column name is fixed

LinqConnect (formerly known as LINQ to Oracle)

The bug with inserting both sides of a one-to-one relationship is fixed

Entity Developer

Capability for customizing the default Type Mapping Rules is implemented
Capability for setting diagram options either globally for all diagram documents or separately for a particular one is implemented: the Diagram Appearance and Printing options can now be set through the Options dialog box
Capability for setting such options as Environment, Diagram and Servers' to adjust the Entity Developer behavior, Model diagram behavior and Type Mapping Rules to your needs is implemented
Capability for setting and defining the class property validation rules based on different engines (Data Annotation, Enterprise Library, NHibernate Validator) is added
The 'Numeric Primary Key As Identity' Oracle option is added: if this option is checked, the "StoreGeneratedPattern" will be set to Identity by default for Number primary keys
The HasStream attribute of entity types, used retrieve binary data as a stream via Open Data Protocol, is supported (Entity Framework models)
The bug with code generation for foreign key fields in Entity Framework models with fluent mapping is fixed
The bug with code generation for default values of DateTime fields is fixed (LinqConnect models)
The bug with 'losing' additional diagrams when re-opening a model is fixed

Entity Framework support

The PL/SQL BOOLEAN parameters of stored procedures are supported in Entity Data Model Wizard
The behavior of the Database.Delete code-first method is changed: the constraints are now disabled when database objects are deleted
The config.QueryOptions.NoEscapeLike and CaseInsensitiveLike options are implemented to manage LIKE behaviour when using Linq to Entities extention methods .Contains() .EndsWith() .StartsWith()
The bug with generating SQL for EdmFunction is fixed
The bug with SQL generation for the EntityFunctions.DiffDays method is fixed

6.50.250 24-Nov-11

Query based notification for OracleDependency is implemented

Entity Developer

The bug related to Visual Studio crashes at query execution is fixed
The bug with removing associations when updating the model is fixed

Entity Framework support

The size of generated SQL is reduced by excluding redundant aliases

6.50.244 11-Nov-11

Behaviour is changed: pending operations on a connection are rolled back before returning the connection to pool
The possibility of choosing connections that are created with Oracle Object Wizard and Oracle Package Wizard is implemented for different project types
The bug with setting Port connection string parameter in Visual Studio connection editor to the value that is greater than 10000 is fixed
The bug with using Oracle Instant client is fixed
The bug with not freeing memory after command execution is fixed
The bug with returning invalid connections to pool is fixed

LinqConnect (formerly known as LINQ to Oracle)

The bug with updating explicitly attached entities is fixed
The bug with inserting null values into Oracle XMLType columns is fixed

Entity Developer

The default attribute mapping source for LinqConnect models is made static
Behaviour is changed: table is not marked as "Changed" in Update Wizard if DefaultValue is set for its expression column
The bug with NRE being thrown when an invalid connection is used is fixed
The bug with creating an association between classes participating in a TPC inheritance hierarchy is fixed (Entity Framework models)
The bug with creating methods with the same names for different stored procedures is fixed
The bug with setting the Concealed Function property in Stored Procedure Editor is fixed
The bug with the local settings used for the default value of DateTime fields is fixed (LinqConnect models)
The bugs with storage synchronization for TPC inheritance classes is fixed

Entity Framework support

The REGEXP Oracle functions for working with regular expressions are supported
Changed behaviour: the CHAR and VARCHAR2 columns are created with the CHAR semantics for EF Code-First CreateDatabase()
The bug with determining correct data types in columns of descendants in TPT and TPC hierarchies is fixed
The bug with the TimeSpan parameters is fixed
The bug with the Group By expression is fixed
The bug with Database.Exists() when there is no entities with DatabaseGeneratedOption.Identity in model is fixed
The bug with character set mismatch when UNION is used for CASEs is fixed
The bug with the DateTimeOffset parameters is fixed

6.50.237 19-Oct-11

Devart.Data.Oracle.DurableInstancing assembly was renamed to Devart.Data.Oracle.WorkflowFoundation
The bug with filtering Oracle clients depending on their capacity is fixed
The bug with parameters binding in OracleCommand.Parameters collection in Direct mode is fixed
The memory leak when working in the OCI connection mode is fixed
The bug with getting incorrect description of package procedures with unsupported table parameters is fixed (an exception is thrown now)
The bug with license check in ILMerged assembly in Mobile Edition is fixed
The bug with reading LONG using x64 version of Oracle client is fixed

LinqConnect (formerly known as LINQ to Oracle)

The bug with getting wrong query from the compiled query cache is fixed
The bug with ordering results of a query with eager loading options enabled is fixed
The bug with inserting entity objects having multiple relations to other entity type with auto-generated primary key is fixed
The bug with updating navigation properties based on a composite foreign key which intersects with the primary key is fixed

Entity Developer

The possibility of specifying the name of the connection string to be saved in the application configuration file is implemented
The code generation is improved to distinguish DATE from TIMESTAMP when using database independent fluent mapping
The bug with saving the IsFlags property of enum types in Entity Framework models is fixed
The bug with detecting whether Devart Entity Model is changed or not is fixed

Entity Framework support

The bug with config.Workarounds.DisableQuoting behaviour with checking DatabaseExists is fixed
The bug with setting GRANT REFERENCE when creating FK between tables from different schemas for config.DatabaseScript.Schema.DeleteDatabaseBehaviour.Schema is fixed
The bug with using Distinct and Take simultaneously in Linq to Entities is fixed
The bugs with character set mismatch are fixed
The bug with InsertNullBehaviour.InsertDefaultOrOmit is fixed

6.50.228 29-Sep-11

The bug with licensing WinForms projects in Delphi Prism is fixed
The bug with OracleDataReader.IsDBNull() for DATE columns is fixed
The bug with using OracleInstanceStore when Pooling=false is fixed
The bug with silent truncation of NVarChar and Varchar2 parameters in Direct mode is fixed
The bug with reading Oracle Objects via OracleDataReader is fixed

LinqConnect (formerly known as LINQ to Oracle)

The bug with ordering queries with eager loading options is fixed
The bug with update operations on Oracle XMLType fields is fixed
The bug with .Equals(null) conditions in LINQ queries is fixed
The bug with caching queries performed via the ExecuteQuery method is fixed
The bug with conversion of System.Char to integer is fixed

Entity Developer

Disabling facets that are not applicable to the current field type is implemented (LinqConnect models)
Default behaviour changed: now the Update To Database Wizard does not drop foreign keys of a table if the 'master' one is not represented in the LinqConnect model
The bug with saving a new solution provided that the Visual Studio option for 'Projects and Solutions -> Save new projects when created' is unchecked is fixed
The bug with pluralization algorithm is fixed when Naming rules are defined
The 'The given key was not present in the dictionary' error in the Entity Developer version integrated into Visual Studio 2010 is fixed
The bug with incorrect determining of association multiplicity (redundant 'many-to-many') in LinqConnect models is fixed
The bug with setting Extended Properties for RelationProperty is fixed

Entity Framework support

The code generation is improved to distinguish DATE from TIMESTAMP when using database independent fluent mapping
The bug with executing Function Imports with enabled BatchUpdates is fixed
The bug with Entity Data Model Wizard when creating a model is fixed
The bug when OracleEntityProviderWorkaroundConfig.IgnoreSchemaName does not affect stored procedures is fixed

6.50.214 06-Sep-11

The 'OraMts' connection string parameter for distributed transactions support through OraMTS is added
The bug with filling OracleDataTable with queries that include the RowId pseudocolumn is fixed
The bug with parameter names when OracleUtils.OracleClientCompatible=true in Direct mode is fixed
The bug when ORA-01036 is not sent to dbMonitor is fixed
The bug with the resource file in Mobile Samples which are shipped with provider is fixed

LinqConnect (formerly known as LINQ to Oracle)

Fluent Mapping support is added
The bug with inserting a TPT 'child' entity in case its primary key column names differ from the 'parent' entity ones is fixed
The bug with deleting dependent entities when other changes were made is fixed
The bug with entity materialization for queries with multiple eager loading options is fixed
The bug with saving (inserting or updating) System.Data.Linq.Binary objects is fixed
The bug with long sequence of IN operator arguments is fixed
The bug with null comparison for DateTime properties is fixed

Entity Developer

Fluent Mapping template for LinqConnect models is added
Support for enumerated types ("enums") in LinqConnect and Entity Framework June 2011 CTP models is implemented
Import for selected stored procedures into the context model for Entity Framework models is implemented
New skins to improve the apllication appearance are implemented
Selection driven highlighting is implemented
Capability for changing the shape color for entities, complex types and enums is implemented
Capability for selecting the diagram skin type is implemented
Changed behaviour: when the FirstLetterUpperCase / FirstLetterLowerCase option is enabled in Naming rules, each letter after underscore will be capital/lower
The bug with saving custom attribute properties with default values in .edml files is fixed
The bug with changing property names ("Index was outside the bounds of the array") is fixed
The bug with an incorrect generation of the private variables names in Entity Framework models is fixed

Entity Framework support

The generation of DATE/TIMESTAMP parameters in LINQ queries is improved
The possibility to turn off generation of fake updates for parent entities is implemented
The 'Character type mismatch' bug for queries with the null-coalescing operator is fixed
The bug with redundant CASTs when working with NUMBERs is fixed

6.30.202 11-Aug-11

The support of events which occur when connections are taken and returned to pool for processing OracleMonitor.TraceEvent is added
The INullable interface is supported in OracleArray, OracleAnyData, and OracleObject

LinqConnect (formerly known as LINQ to Oracle)

The bug with deleting dependent entities when the 'main' one is modified is fixed
The bug with update commands for Table Per Type inheritance is fixed

Entity Developer

The pluralization algorithm is improved when Naming rules are defined

6.30.196 28-Jul-11

The bug with batch insert in NHibernate support is fixed
The bug with not closed connections by OracleInstanceStore is fixed

LinqConnect (formerly known as LINQ to Oracle)

The bug with columns named as Oracle keywords is fixed

Entity Developer

The Entity Key handling for Views in Update From Database Wizard in Entity Framework models is improved
The bug with XML comments generation in Entity Framework models is fixed
The bug with wrong error placing in Model Explorer in Entity Framework models is fixed
The bug with renaming the stored procedure parameter in Entity Framework models is fixed
The bug with regeneration of the ed:Guid attribute of navigation properties after Update From Database wizard completes is fixed (Entity Framework models)

Entity Framework support

The "raw guid as string" SSDL type is implemented for text presentation of binary Guids
The processing of LINQ expressions which work with literals is improved
The bug with insert into Identity single-column table is fixed

6.30.185 07-Jul-11

The bug with 28-th digit in the OracleDataReader.GetDecimal method is fixed
The bug with reading CLOB value with multibyte character set in OCI mode is fixed
The bug with OracleCommand.ExecuteArray() for nullable value types is fixed
The bug with securityTrimmingEnabled option of Site Map provider is fixed
Freezing of the GC finalizer thread at unexpected connection closure while reading XMLType is fixed
The Workflow Instance Store bugs with workability on Oracle server of versions prior to 11, GetExpirationTime and LoadRunnableInstance functions are fixed

LinqConnect (formerly known as LINQ to Oracle)

The bug with the 'Cannot remove an entity that has not been attached' error when using compiled queries is fixed

Entity Developer

The possibility to export the diagram into an image file was added
The possibility to restrict adding the connection string information to the application configuration file is added
The changes in the Entity name are now preserved by Update From Database Wizard (Entity Framework models)
The bug with default value quotation in Entity Framework models is fixed
The bug with Save All for the Read Only model files in Entity Framework models is fixed
The bug with Primary Key naming in case of many-to-many associations in Model First is fixed (LinqConnect models)

Entity Framework support

Entity Framework 4.2 June 2011 CTP is supported

6.30.172 15-Jun-11

LinqConnect (formerly known as LINQ to Oracle)

The 'IsReference' mode of entity serialization is supported
The bug with querying entity tables having no primary key is fixed
The bug with ArgumentException on accessing DataContext.Table when the TEntity class has user-defined properties is fixed

Entity Developer

The bug with Extended Properties handling is fixed
The bug with setting the multiplicity of updated constraint in Entity Framework models is fixed

Entity Framework support

The update functionality for default values is improved
The bug with NUMBER Mappings in Entity Data Model Wizard is fixed
The bug with Default Value and the Identity columns is fixed

6.30.165 01-Jun-11

The OracleConnectMode.SYSASM privilege is supported
The bug with license check in ILMerged assembly is fixed
The bug with redundant setting of isolation level to READ COMMITTED on transaction opening is fixed
The bug with installation on machines with Turkish regional settings is fixed
The bug with AccessViolationException in severely loaded applications is fixed
The bug with retrieving LOB values in Direct mode is fixed

LinqConnect (formerly known as LINQ to Oracle)

Implemented fetch mode customization for eager loading of related entities
Improved performance of ordered queries with the Skip() and Take() methods: the 'rownum' pseudo-column is now used instead of the 'row_number' function
The bug with NullReferenceException when selecting non-entity types is fixed
The bug with type mismatch when using null parameters in LINQ queries is fixed
The bug with refreshing entities with a changed entity reference is fixed
The bug with updating entities that have associations based on unique (not primary) keys is fixed
The bug with parameters of compiled queries not being refreshed is fixed
The bug with redundant subqueries in queries that use the Take method is fixed

Entity Developer

Behaviour is changed: string entity fields are now mapped to varchar2(4000) by default
The bug with recognizing associations between tables from different schemas is fixed
The bug with configuring a sequence ID generator in LinqConnect models is fixed
The bug with LinqConnect external mapping file in case entity classes belong to non-default namespace is fixed
The bug with persisting associations between LinqConnect entity classes inherited from the same base class is fixed
The bug with adding package functions to the model is fixed
The bug with column aliases in queries with several nested subqueries is fixed
The bug with Unicode symbols in template is fixed

Entity Framework support

Processing of Edm.StartsWith, Edm.Contains, and Edm.EndsWith is improved
Redundant casts for the DATE and TIMESTAMP columns are excluded from the generated query

6.30.160 17-May-11

Oracle Workflow Instance Store is implemented
Support for the Oracle TimesTen database is implemented
DbTransactionBase class is added
TransactionStateChanging and TransactionStateChanged events are added to the DbConnectionBase class
Policy file for the Devart.Data.Oracle.Entity assembly is added
The License Information Wizard is improved: it now generates licenses for projects that have Entity Framework models or refer to Devart.Data.Oracle.Web, but have no direct references to Devart.Data.Oracle.dll
The "Use schema name" checkbox is added to DataSet Wizard
The bug with Membership provider compatibility between .NET Framework 2.0 and 4.0 is fixed
The bug with launching Devart documentation via Start menu is fixed
The bug with OracleTimeStamp.Parse() for time format with AM/PM is fixed

LinqConnect (formerly known as LINQ to Oracle)

Implemented eager loading in case the related entities collection is referenced in the select clause of the query
The bug with incorrect operation order during SubmitChanges() calls is fixed
The bug with ArgumentExceptions thrown in background threads is fixed
The bug with using public properties when refreshing or materializing an entity is fixed
The bug with grouping a collection by a whole entity is fixed

Entity Developer

New Templates are added:
- LinqConnect: POCO template with XML mapping generation
- Entity Framework: POCO template, Self-Tracking template, DbContext template with fluent mapping generation
Templates usability is improved
Template Editor is significantly improved
Ability to declare additional properties for model objects is added
Ability to specify .NET attributes for model objects is added
Implemented runtime support for literals specified in the 'Default Value' entity field property for LinqConnect models
The "Preserve schema name in storage" option is added
The bug with code generation for the 'Delete Rule' association property in LinqConnect models is fixed
The bug with generation of attach/detach methods for many-to-many associations in LinqConnect models is fixed
The bug with external mapping for LinqConnect models is fixed
The bug with default values set via a function for string fields in LinqConnect models is fixed
The bug with the "Access" combobox of the Association editor in LinqConnect models is fixed
The bug with procedures that differ only by name in Database Explorer is fixed (Entity Framework models)
The bug with NVARCHAR2 data type not having MaxLength set is fixed (Entity Framework models)
The bug with output parameters (in case they are returned with a REF CURSOR out parameter) is fixed

Entity Framework support

Batch Updates support is added
Adjustable SQL Formatting for DML commands is added
Ability to configure the NULL values inserting behaviour is added
IgnoreSchemaName workaround (mainly for Code First) is added
DisableQuoting workaround is added
OracleFunctions.Like support (including LINQ to Entities) is added
Configurable schema deletion and creation support is added
Number Mappings support in Entity Data Model Wizard and Update From Database Wizard is added
Multiple Include support is improved
The handling of the StoreGeneratedPattern in Update From Database Wizard is improved
The bug with Entity Framework configurability is fixed
The bug with displaying Guid parameters in Entity Framework commands in DBMonitor is fixed
The bug with POCO code generation in case of many-to-many association is fixed

6.10.141 19-Apr-11

Fixed bug with TIMESTAMP WITH TIMEZONE in Direct mode when daylight saving time
Fixed bug with array type in the Oracle Package wizard
Fixed bug with OracleQueue.Listen() with single consumer

LinqConnect (formerly known as LINQ to Oracle)

Fixed bug with invalid aliases in queries that include the UNION clause
Fixed bug with simultaneous insert of both sides of a one-to-one association when the 'master' side has auto-generated ID

Entity Framework support

Entity Framework 4.1 RTW supported
Fixed bug with ROWSCN pseudo-column on update

6.10.135 06-Apr-11

Changed behaviour: OracleDbType.VarChar parameter's max size is increased from 4000 to 32767 symbols
Fixed bug with upgrading *.cs files in App_Code folder when using Upgrade Wizard
Fixed bug with exception in TransactionScope in case of enabled Microsoft Distributed Transaction Coordinator (MSDTC)
Fixed bug with out parameters in ExecuteArray

LinqConnect (formerly known as LINQ to Oracle)

Implemented the Attach(object entity, object original) method of the Devart.Data.Linq.ITable interface
Fixed bug with passing GUID parameters to compiled queries

Entity Developer

Changed behaviour: when retrieving metadata for Oracle servers 9.2.0.5 and prior, the JOIN syntax of Oracle 8 is used now
Fixed bug with multiplicity changing in the association editor (Entity Framework models)

Entity Framework support

Fixed bug with whitespace symbol not generated on update
Fixed bug with parentheses generation on Take
Fixed bug with CAST of the CLOB type
Fixed bug with adding unnecessary model objects in Entity Data Model Wizard

6.10.126 23-Mar-11

Supported Visual Studio 2010 Service Pack 1
Improved public interface of OracleNumberMappingCollection class
Fixed bug with OracleDataReader.GetBytes() method for RAW, LONG RAW, LONG datatypes
Fixed bug with upgrading *.ascx files when using Upgrade Wizard

LinqConnect (formerly known as LINQ to Oracle)

Fixed bug with inserting 'detail' entities together with 'master' ones for one-to-one associations

Entity Developer

Changed behaviour: when adding two related entities with the corresponding properties having different types, an invalid association is created now
Changed behaviour: when retrieving metadata, Oracle stored procedures and functions that don't return cursors are no longer executed
Fixed bug with generating incorrect code for models having one-to-one associations with a nullable property at the 'detail' side
Fixed bug with generating script with duplicate columns for entities having two fields of the same complex type

Entity Framework support

Supported Entity Framework 4.1 Release Candidate
Improved TPT inheritance support in case of updating the inherited entities
Added new column generation based on Unicode and non-Unicode columns union in queries
Fixed bug with incorrect column name generation on update in case of Timestamp column having Computed StoreGenerationPattern

6.10.121 11-Mar-11

Fixed bug with the "The message filter indicated that the application is busy" error during uninstall
Fixed bug with DataLink.Find() method
Fixed bug with inserting null into NVARCHAR columns on servers with German NLS settings (errors ORA-1400 and ORA-1483)
Fixed bug with reading OracleObject from OracleDataReader
Fixed bug with retrieving LOB values in Direct mode
Fixed bug with OracleConnection.ClientId property in Direct mode

LinqConnect (formerly known as LINQ to Oracle)

Implemented implicit sorting by the entity key in queries with defined LoadWith rules
Fixed bug with calling the base Devart.Data.Linq.DataContext constructor with the mapping argument

Entity Developer

Fixed bug with discarding changes in Navigation Properties names

Entity Framework support

Improved Skip/Take performance
Improved performance by removing the unnecessary CAST statements

6.10.111 24-Feb-11

Added DDEX support in Express Edition
Supported SQL Server Reporting Services x64
Fixed bug with resetting CopyLocal property of Devart references to False after using Upgrade Wizard
Fixed bug with unicode characters when using Upgrade Wizard
Fixed bug with compatibility with Microsoft Team Foundation Server 2010 Power Tools (broken designers for WPF, Silverlight, etc)
Fixed Visual Studio integration conflict with Windows Phone Developer Tools

LinqConnect (formerly known as LINQ to Oracle)

Fixed bug with deserializing LinqConnect exceptions
Fixed bug with attaching entities as modified to DataContext

Entity Developer

Added sorting in the 'Return Type' ComboBox for methods in the Properties window
Fixed code generation for many-to-many associations when the Unidirectional serialization mode is enabled (LinqConnect models)
Fixed bug with adding Oracle procedures declared inside packages to the model
Fixed some bugs in Table Per Concrete Type (TPC) design time support in Entity Framework models
Fixed bug with wrong Metadata Artifact Processing setting for Web Site projects in Entity Framework models

Entity Framework support

Microsoft Generate Database from Model Wizard: Changed Date type to Timestamp type for DateTime properties

6.10.103 09-Feb-11

Implemented generation of UDT method wrappers in the Oracle Object wizard
Added the OracleObject.ExecuteMethod method for invocation of Oracle object methods
Changed behaviour: the isUnique property in the schema table is no longer set to true for columns participating in composite unique keys
Fixed bug with enabling OCI pooling for Unicode connections
Fixed bug with inserting NULLs into Oracle array and table data types
Fixed several bugs (mostly concerning Pooling) in the TransactionScope support

LinqConnect (formerly known as LINQ to Oracle)

Fixed bug with setting no reference to the Devart.Data.Linq.Web assembly when adding a DbLinqDataSource object to a web form
Fixed bug with generating methods for Oracle stored procedures with PL/SQL Boolean parameters
Fixed bug with retrieving entities participating in a many-to-many association with a composite key
Fixed bug with continuing identity tracking for deleted entities
Fixed bug with incorrect order of executing create/update/delete commands on SubmitChanges()

Entity Developer

Added ConstraintSet property for Constraints in the Store part of the Entity Framework model
Added mapping for Function Import result types (Entity Framework v4 only)
Changed behaviour: classes created with the Update From Database Wizard are now added to the current diagram
Changed behaviour: the 'Update Check' is now set to 'Always' and disabled for properties that form the entity key (LinqConnect models)
Fixed bug with wrong Complex Type properties in Stored Procedures
Fixed bug with mapping NUMBER fields to System.Double in LinqConnect models
Fixed bug with the 'Show Print Markup' button and 'Page Setup' menu item being disabled

6.10.96 27-Jan-11

Supported Oracle Database Resident Connection Pooling (DRCP)
Added 'Connection Class' connection string parameter and OracleConnectionStringBuilder.ConnectionClass property for DRCP support
Implemented support for the TIMESTAMP, INTERVAL, CLOB, and BLOB Oracle data types in the OracleLoader component
Implemented support for the OracleCommand.CommandTimeout and OracleConnection.ConnectionTimeout properties in the OCI connection mode
Added possibility to use overloaded stored procedures which do not return result set with ExecuteScalar()/ExecuteNonQuery() without setting a number of overload when parameters are added manually
Improved Oracle Objects Wizard: now it generates a constructor receiving non-typed OracleObject
Added BeginTransaction value to the MonitorEventType enum
Implemented the DbMonitor.EventQueueLimit property which allows to set the maximal allowed number of messages waiting for being processed by the dbMonitor application
Changed behaviour in OracleClient compatibility mode: stored procedures are called with named parameters now
Fixed bug with incorrect EventType passed to TraceEvent of DbMonitor
Fixed bug with cursor parameters of stored procedures in OracleDataSource
Fixed bug with starting transactions for a connection on which an error occurred
Fixed OCI_INVALID_HANDLE error when a command is reused after connection is reopened
Fixed bug with timezone passed to OracleTimeStamp constructors
Fixed bug with parameters order in OracleCommand.Parameters collection in Direct mode
Fixed bug with multi value parameters in SQL Server Reporting Services

LinqConnect (formerly known as LINQ to Oracle)

Fixed bug with repeated creation of DataContexts with external mapping
Fixed bug with many-to-many associations based on composite keys

Entity Developer

Added possibility to split model into several diagrams for better handling of large models
Supported automatic generation of sequences and triggers for Autoincrement properties
Implemented possibility to disable automatic recognition of many-to-many associations
Fixed bug with handling errors when accessing server via an invalid connection
Fixed bug with generating code for methods returning scalar result in Entity Framework models
Fixed bug with adding associated tables from the Store part of the model to designer in Entity Framework models
Fixed bug with MaxLength facet for Unicode servers
Fixed bug with opening models that have invalid connection strings

Entity Framework support

Improved performance for Visual Studio LightSwitch Beta 1 integration
Fixed bug with MaxLength facet for Unicode servers
Fixed bug with TruncateTime canonical function

6.00.86 12-Jan-11

Implemented the OracleLob.NullNClob property returning an empty OracleLob of the NClob type
Implemented possibility of changing the OracleLob.Cached property to disable buffering entire LOB into the memory
Supported connection in Direct mode with service name as an alternative to using database instance name (SID and Service Name connection string parameters have different meanings now)
Added ServiceName property to OracleConnectionStringBuilder class
Added Statement Cache Size connection string parameter and OracleConnectionStringBuilder.StatementCacheSize property
Added advanced connection string parameters to the connection dialogs of Object and Package wizards
Added the TryParse method to the classes and structures representing native Oracle data types
The OracleLob.Null property declared deprecated; it was left for the reason of compatibility with the System.Data.OracleClient data provider
Changed behaviour in OracleClient compatibility mode: it is no longer allowed to create update and delete commands via OracleCommandBuilder for a result set with no primary key
Changed behaviour in OracleClient compatibility mode: the colon is no longer removed from OracleParameter.ParameterName
Changed behaviour: setting the DbDataTable.Connection property sets the InsertCommand.Connection, UpdateCommand.Connection, and DeleteCommand.Connection properties
Changed default value of OracleCommand.Cached to true
Fixed bug with incorrect case of data sources shown in the DataLink.DataSource property when using the Interform technology
Fixed bug with inserting records to database after distributed transaction timeout is over
Fixed bug with caching commands in Direct mode
Fixed bug with FOR UPDATE clause in SELECT statement

LinqConnect (formerly known as LINQ to Oracle)

Fixed bug with incorrect detaching entities in the master/detail association
Fixed bug with VB code generation for models with Unidirectional serialization
Fixed bug with creating DataContext using external mapping
Fixed bug with using the Convert.ToDateTime function with Greek culture info in LINQ queries

Entity Developer

Fixed bug with many-to-many and Update From Database Wizard

Entity Framework support

Added support for Entity Framework CTP 5
Improved DatabaseExists functionality

6.00.70 23-Dec-10

Fixed bug with connecting in the Direct mode when the system time has negative timezone

6.00.69 16-Dec-10

Supported Visual Studio 2010 Service Pack 1 Beta
Supported OracleConnection.ChangePassword() in Direct mode
Added "Transaction Scope Local" connection string option that enables the support for non-distributed transactions in the TransactionScope implementation
Improved interface in DbLoader class - added string and integer indexers
Added overloads for methods of DbDataReaderBase class with column name parameter
Changed behaviour: when clearing the pool, the number of connections specified in 'Min Pool Size' is never removed
Fixed bug with using XMLTYPE as Output, InputOutput and ReturnValue parameters of stored procedures and functions
Fixed bug with freeing temporary tablespace when creating multiple LOBs
Fixed bug with creating TIMESTAMP with small negative timezone
Fixed bug with inserting TIMESTAMP into user-defined types
Fixed bug with OracleTimeStamp in multi-threaded applications

LinqConnect (formerly known as LINQ to Oracle)

Implemented support for custom type arguments in LinqConnect compiled queries
Fixed bug with redundant subqueries and Order By clauses in commands generated for entities with configured load options
Fixed bug with Visual Basic code generation for sequence-generated entity properties
Fixed bug with the DataContext.Query<TResult> method in the case when TResult is not an entity class
Fixed bug with the 'The process was terminated due to an unhandled exception' error on severely loaded applications
Fixed bug with queries with the OrderBy(...).Any() statement
Fixed code generation bug with functions having output parameters

Entity Developer

Fixed bug with the null-reference exception when adding LinqConnect model to web site folders other than App_Code

Entity Framework support

Entity Data Model Wizard and Update Model from Database Wizard in Visual Studio 2010 Service Pack 1 Beta supported
Improved SQL generation for IN (Entity SQL) and Contains (LINQ to Entities) clauses
Improved performance for DateTime literals
Fixed bug with charset mismatch
Fixed bug with Unicode characters in NVARCHAR2 and NCHAR columns

6.00.58 29-Nov-10

Implemented returning the error code of SocketExceptions thrown on network errors occurring when opening Direct connections
The NumberMapping and NumberMappingCollection classes renamed to OracleNumberMapping and OracleNumberMappingCollection
Implemented the OracleCommand.PassParametersByName property and the 'Pass Parameters By Name' connection string parameter
Added the 'Number Mappings' connection string parameter that allows to change default mappings of Oracle Number and Float types to .NET number types
Added the 'Validate Connection' connection string parameter to validate connection on its retrieving from pool
Fixed bug with validating connections in pool
Fixed bug with setting XMLTYPE fields of Oracle Objects
Fixed bug with creating timestamps with Timezone = 14
Fixed bug with WebSite projects in Delphi Prism
Fixed bug with DbType.String parameter for long strings (>4000)

LinqConnect (formerly known as LINQ to Oracle)

Ability to execute DML statements in batches on SubmitChanges added
Table Per Type inheritance supported
Supported ASP.NET Dynamic Data with ASP.NET Dynamic Data project templates
PLINQ support added (connection manager redesigned for thread safety)
Supported Visual Studio Debugger Visualizer with SQL syntax highlighting for the DataQuery objects
Changed behaviour: retrieving master entity from details one now generates left outer join instead of inner join

Entity Developer

Added Update Model From Database functionality
Update To Database with Storage Synchronization functionality added
Added possibility for changing the UpdateCheck property for several fields at once
Added multiselect support for properties
Improved large models handling
Fixed bug with IndexOutOfRangeException on code generation
Fixed bug with keyword quotation in the Source property
Fixed bug with Unknown parameter direction
Fixed "Cannot find column Position" bug
Fixed bug with Visual Basic code generation for stored functions
Fixed bug with not loading Master property in Detail entity of master/details associations
Fixed bug with mapping One-to-One associations to One-to-Many
Fixed bug with Default Value in Entity Framework models
Fixed bug with mapping Number parameters of stored procedures
Fixed bug with default editor in Visual Studio
Fixed bug with associations that crash Visual Studio
Fixed bug with Guid and inheritance
Fixed bug with pipelined functions
Fixed 'Model is not registered' bug
Fixed bug with Retrieve Data
Fixed some bugs in Team Foundation Server support

5.70.190 04-Nov-10

Implemented integration with Visual Web Developer 2008 and 2010 Express editions
Added support for user-defined types with sys.xmltype fields
Added Trim Fixed Char connection string parameter
Added additional overloads of OracleParameterCollection.Add() method

LinqConnect (formerly known as LINQ to Oracle)

Improved transaction behaviour in case when exception is thrown
Fixed bug with translating the IIf method in LINQ queries
Fixed bug with custom methods in the 'select new' clause of LINQ queries
Fixed bug with not loading associated entity when LoadWith is not used

Entity Developer

Fixed bug with associations adding

Entity Framework support

Model First support improved

Added more settings in Devart SSDLToOracle.tt file
DROP statements generation added
Schema name is not generated before each object
Generated scripts are now SQLPlus-compatible
Fixed bug with OnDelete association action in Model First

5.70.180 14-Oct-10

Implemented additional constructors for OracleParameter class
Implemented explicit disposing of OracleCommands used in the Enqueue/Dequeue methods of the OracleQueue components
Fixed bug with configuring OracleDataTable constraints in case of several multi-column unique keys that use common columns
Fixed bug with generating license resource for ILMerged assembly
Fixed bug with ReturnValue parameter for OracleCommand.ExecuteReader() and ExecuteScalar()
Fixed bug with OracleDbType.NVarChar parameters in Direct mode
Fixed bug with executing wrapped PL/SQL-code via OracleScript
Fixed bug with OracleCommand.Cancel() method

LinqConnect (formerly known as LINQ to Oracle)

DataContext class is now CLS-Compilant
Changed behaviour: Substring() in LINQ queries is now translated to DBMS_LOB.SUBSTR for LOBs
Fixed bug with DataLoadOptions not working when object tracking is disabled
Fixed bug with second-level details loading
Fixed bug with creating compiled query using more than three parameters
Fixed bug with select queries from tables with no primary key
Fixed bug with constraint violation on inserting details before master data
Fixed bug with ArgumentException when using System.Nullable.GetValueOrDefault in Visual Basic LINQ queries
Fixed bug with incorrect marking of changed fields when using several DataContexts
Fixed bug with creating constraints on executing the DataContext.CreateDatabase method
Fixed bug with incorrect ROWNUM function usage in generated SQL

Entity Developer

Added default bindings to entity fields in Insert(Update/Delete) MethodMappings
Fixed bug with serializing entities loaded using DataLoadOptions

Entity Framework support

Added implementation for the DatabaseExists method

5.70.170 23-Sep-10

Added possibility for handling the ORA-01403 informational message
Implemented host option for current process in dbMonitor
Added possibility for tracing the distributed transactions in DBMonitor
Changed behaviour: OracleParameter.OracleDbType will be set by default to OracleDbType.Clob for the values which are longer than 4000 symbols
Fixed the 'Retrieving the COM class factory for component ... failed' error during installation on x64 machines
Fixed bug with Minimal+LINQ installation
Fixed bug with determining DataType of BFile table columns
Fixed bug with executing GetData() method of TableAdapters returning cursors
Fixed bug with caching data for the connections placed to the pool
Fixed bug with reading parent fields from an object of an inherited type
Fixed bug with setting DirectUtils.PacketSize property
Fixed bug of Migration Wizard with converting OracleDbType.Byte
Fixed bug with reusing OracleCommand with other parameters set
Fixed bug with enlisting ASP.NET provider's activity to distributed transaction
Fixed bug with assertion failure on show call tree in dbMonitor

LinqConnect (formerly known as LINQ to Oracle)

Added the client NLS settings support in the TO_NUMBER function
Fixed bug with editing Entity Key values
Fixed bug with association names in Entity Data Model
Fixed bug with IndexOutOfRangeException on the DeleteOnSubmit call
Fixed bug on inserting new rows into a table with many-to-many association
Fixed bug with fetching records one-by-one from the 'detail' table in master/details relation
Fixed bug with retrieving entities of an inherited type
Fixed bugs with using the Contains method of empty arrays
Fixed bug with the RejectChanges method not working
Fixed bug with structs in queries
Fixed bug with Command Timeout

Entity Developer

Fixed bug with VB Code generation for Associations
Fixed bug with Unidirectional serialization mode
Fixed design time bug with Referential constraints
Fixed bug with generating code for stored procedures with out parameters

Entity Framework support

Fixed bug with the Guid output parameter

5.70.152 28-Jul-10

Implemented capability of extending base functionality of ASP.NET providers
Added support for Enterprise Library 5
Changed the primary key of the aspnet_sessions table for ASP.NET Web providers (the ApplicationName column added)
Fixed bug with setting the type of null OracleLob
Fixed bug with Oracle Advanced Queuing for Unicode connections
Fixed bug with the 'date format not recognized' error in Direct mode
Fixed bug with DataTable in design time when using DevExpress XtraReport
Fixed bug with creating connection in Server Explorer (connections are removed after uninstall now)

LinqConnect (formerly known as LINQ to Oracle)

Added implementation of the ITable interface for the Table class
Changed DataContext.Log output format for Microsoft compatibility reasons
Fixed bug with creating XmlMappingSource object when the File Per Class model property is set to true
Fixed bug with IndexOutOfRangeException on the Refresh call
Fixed bug with CompiledQueryCache
Fixed bug with InvalidCastException on selecting a new anonymous type
Fixed bug with FilePerClass and XMLMappingSource
Fixed bug with functions that return NVarchar values

Entity Developer

Added possibility of renaming associations in the model
Fixed bug with change tracking for inherited tables
Fixed bug with setting LinqConnect Entity Key when a table has both Primary and Unique keys

Entity Framework support

Improved select performance in case of specific double values
Fixed bug with association mapping in case of inheritance
Fixed bug with bool parameters of stored procedures

5.70.146 07-Jul-10

Added functionality for setting size of packets sent on command execution
Fixed bug with membership provider (connection is not opened on Initialize() now)
Fixed bug with model registration in web applications
Fixed bug with colons inside a string constant in the Direct mode
Fixed bug with replacing empty strings on OracleDataAdapter.Update
Fixed bug with stored procedure output VArray parameter for Oracle Server 11g R2
Fixed bug with OracleDataTable.Clear() method
Fixed bug with OracleTimeStamp.GetSysDate() not setting time
Fixed bug with reading from several cursors
Fixed bug with memory leak in TransactionScope
Fixed bug with OracleXML.Dispose()

LinqConnect (formerly known as LINQ to Oracle)

Improved select performance
Improved insert performance
Fixed bug with charset mismatch
Fixed bug with Concat()
Fixed bug with the CacheStoreReader and Cast

Entity Developer

Fixed bug with column Summary serialization
Fixed bug with Visual Basic code generation template
Fixed bug with associations between tables from different schemas
Fixed bug with INOUT cursor parameter

Entity Framework support

Fixed bug with the DevartEntityDeploy build action
Fixed bug with the unnecessary trigger and sequence generation

5.70.140 20-May-10

Supported password salt in ASP.NET membership provider
Added ClientId connection parameter
Improved Upgrade wizard
Changed generation of overloaded procedures names in Oracle Package Wizard
Changed default behaviour of OracleTransaction without explicit Commit/Rollback call (RollBack now)
Fixed bug with Upgrade Wizard on web sites
Fixed bug with disposing data table with InterForm ParentRelation
Fixed bug with lost InterForm connection
Fixed bug with executing a PL/SQL block with two parameters of the same name
Fixed bug with using Oracle Client 8
Fixed memory leak on selecting result sets containing geometry type
Fixed bug with opened cursors on dequeuing in Direct mode
Fixed bug with fetching large amount of rows of geometry type
Fixed bug with errors in ora log file in Direct mode
Fixed bug with hashed passwords in Membership provider

LinqConnect (formerly known as LINQ to Oracle)

LINQ to Oracle support is renamed to LinqConnect
Added support for Complex type
Added support for different configurable algorithms for primary key generation
Automatic configurable compiled query caching supported
Performance improved
DateTimeFormat is set in accordance with session parameters
Fixed bug with Union and Concat
Fixed bug with DbLinqDataSource and RadGrid paging
Fixed bug with 'Nop' node translation
Fixed bug with empty type in specific Group By clause
Fixed bug with ArgumentNullException on DataContext.Query().Contains()
Fixed bug with Cast() method
Fixed bug with binary primary keys

Entity Developer

Improved code generation for procedures returning several cursors
Fixed bug with Properties window
Fixed bug with Discriminator property drag&drop
Fixed bug on Customization window load
Fixed bug with property editor grid updating
Fixed error with RAW(16) to Guid automapping
Fixed bug with Document.Reload
Fixed bug with LINQ models on Windows XP 64-bit

Entity Framework support

Fixed bug with string concatenation
Fixed bug with data type mapping in function result set
Fixed bug with RAW parameters and BLOB values

5.60.124 15-Apr-10

Supported Visual Studio 2010

Entity Developer

Support for ADO.NET Entity Framework 4 added

Entity Framework support

Supported ADO.NET Entity Framework 4

5.60.120 31-Mar-10

Supported Visual Studio 2010 Release Candidate
Install Wizard improved (ability to automatically uninstall previous version added)
ADO.NET Data Services v1.5 CTP2 supported
Added possibility to avoid connecting to dbMonitor.exe when using DbMonitor ancestors
Transaction rollback timeout changed from ConnectionTimeout to DefaultCommandTimeout
Fixed bug with generating DbDirectMethods for TableAdapter of MS DataSet
Fixed bug with parameters on multiple runs of ExecuteArray
Fixed bug with licensing in Visual Studio 2010 Release Candidate projects
Fixed bug with exception in License Information window
Fixed bug with OracleDataSource parameters
Fixed bug with fixed-length symbols in Unicode tables
Fixed performance issue on select command execution via the ExecuteNonQuery method
Fixed bug with XML parameter of OracleCommand
Fixed bug with multiple rows constraint generation

LINQ to Oracle

Added support for specific dynamic expressions
Fixed bug with Refresh() method
Fixed bug with LoadWith() method
Fixed the 'Unable to cast object' problem
Fixed bug with Where() and nullable parameter
Fixed bug with multiple LoadWith() calls
Fixed bug with calling a method in the Select clause
Fixed "Cannot Refresh Entity" error
Fixed bug with nullable boolean and null comparison
Fixed "Cannot access a disposed object" error
Fixed bug with "select new"
Fixed bug with insert of autoincremented values
Fixed bug with NotImplementedException and IGrouping.Count
Fixed the problem with group by and ordering
Fixed bug with exception on the master-detail insert
Fixed bug with Int32 instead of Int64

Entity Developer

Support for ADO.NET Entity Framework 4 Release Candidate added
Support for multi-result set methods added
Improved dialogs for editing model objects
Full integration with Visual Studio implemented
Added full support for ModificationFunctionMapping
Improved Find in Model functionality
Strongly typed reference cursors supported
Improved One-To-One associations handling
Fixed bug with different namespaces and procedure code generation
Fixed bug with Unicode facet serialization
Fixed problem with DevartEntityDeploySplit
Fixed problem with metadata resources generation
Fixed bug with model containing specific procedures
Fixed bug with App_Code subfolders
Fixed bug with Many-to-Many associations
Fixed several bugs in VB.NET code generation templates
Fixed bug with "Trial period expired" on 64-bit Windows
Fixed the "MSL Parsing failed" problem on some model opening
Fixed bug with Read Only attribute
Fixed bug with Storage attribute setting
Fixed bug with OtherKey attribute setting
Fixed bug with model opening in case of manual association edit
Fixed bug with Generate related property check box
Fixed Number(1) with default values mapping to Int32
Fixed bug with systimestamp default value

Entity Framework support

Supported ADO.NET Entity Framework 4 Release Candidate
- Support for new Canonical aggregate and scalar functions added
- Ability to use standard DBMS functions in LINQ queries added
- Support for Model First (templates for DB generation) added
- Full support for Entity Data Model Wizard/Update Wizard added
Added support for methods creating and deleting the database (EF v1 and EF v4)
Fixed bug with Returning SQL
Fixed bug with exception on Generate Database from Model
Fixed bug with EndsWith method
Fixed bug with Double value exceeding the Decimal scale

5.35.79 14-Jan-10

Added functionality to catch the ORA-28002 exception
Supported parameterized commands in Reporting Services
Supported stored procedures with cursors in reporting projects
GetSchemaTable method is not invoked now when ParentRelation property is set and current position in master table is changed
Fixed bug with inability to "Copy data from one or more tables or views" in SQL Server Import and Export Wizard
Fixed bug with non-complete uninstall of dotConnect
Fixed bug with parameterized queries in Direct mode
Fixed bug with FindUsersByName method of Membership class
Fixed bug with WebParts Shared Scope state saving in Personalization Provider

LINQ to Oracle

Fixed the "Destabilize the runtime" problem

Entity Developer

Fixed bug with incorrect updating of the Project Explorer root node names

Entity Framework support

Fixed bug with EntitySQL BigCount function

5.35.62 16-Dec-09

Implemented Ping() method of OracleConnection class
Fixed bug with memory leak when working with Oracle client 11

LINQ to Oracle

Changed exception type on the Single method not returning value
Fixed bug with redundant quering of the nullable association end
Fixed bug with DataContext.CommandTimeout
Fixed bug with erroneous select function from dual

Entity Developer

Fixed bug with 'Generate Related property' serialization
Fixed bug with CR/LF in Oracle Comments as Summary

Entity Framework support

Added DateInterval function for date difference handling
Fixed the "Can not convert" bug

5.35.57 02-Dec-09

Fixed bug with XML parameter of OracleCommand class
Fixed bug with Char parameter of OracleCommand class
Fixed bugs with ExecuteArray method of OracleCommand class

Entity Developer

Fixed bug with the Custom.After.Microsoft.Common.targets file appending
Fixed bug with inheritance and primary keys

Entity Framework support

Added the rounding of double values
Fixed the LOB-parameters problem

5.35.54 19-Nov-09

Integration with improved dbMonitor added
Implemented DefaultCommandTimeout parameter in connection string (by default, set to 0)
Added orderid column for Site Map provider for custom map node ordering
Added some DataSet Wizard design-time improvements
Changed default value of OracleCommand.CommandTimeout (set to 0)
Fixed bug with OracleCommandBuilder when column name coincides with key word
Fixed bug with MembershipProvider.GetAllUsers() method
Fixed bug with using OracleDataAdapter in Butch update mode
Fixed problem with consecutive usage of local and distributed transactions on the same connection with Oracle XE
Fixed bug with OracleDataReader.GetInt32(int) and GetInt64(int) methods
Fixed bug with DataLink.DataSource property after regeneration of DataSet

LINQ to Oracle

Devart DbLinqDataSource component added
Linq performance improved
Supported navigation using properties (not only keys)
Fixed issue with removing entities from EntitySet
Fixed bug with EntitySet onAdd action
Fixed bug with updating the detached object
Fixed the security problem in medium trust environment

Entity Developer

New T4 like template engine with powerful editor added
Updated code generation
- Ability to generate separate files for classes added
- Entity Framework Pregenerated Views support added
- Improved null handling code generation
Ability to execute LINQ and Entity SQL queries with data and native sql preview added
Ability to preview and edit data displayed in Database Explorer added
Table splitting added (emulation of deferred loading for "large" datatypes in EF)
OnDelete support for associations added
Corrected the setting of Source and Table attribute for non-database objects
Fixed bug with attach_Entity methods
Fixed bug with access and inheritance modifiers for properties
Fixed bug with out-parameters of stored procedures
Fixed bug with LINQ to SQL code generation for out-parameters
Fixed bug with NUMBER to Double mapping in the stored procedure parameters
Fixed bug with procedures returning nullable types
Fixed bug with stored procedures returning System.DBNull

Entity Framework support

Added support for handling nulls as empty strings for character columns
DateTimeOffset data type supported
Fixed bug with CommandText in case of stored procedures
Fixed bug with out parameters in stored procedures
Fixed bug with the LONG RAW parameters

5.25.49 19-Oct-09

Added SchemaTable property to DbDataTable
Added Enlist parameter to connection string

LINQ to Oracle

Fixed bug with the Attach() method
Fixed bug with updating the associated entities
Fixed the "Constant cannot be sequence" error
Fixed bug with populating DataContext.GetCommand().Parameters collection
Fixed bug with Single() method
Fixed bug with columns of the "Timestamp with time zone" type

Entity Developer

Fixed bug with wrong IDE configuration path
Fixed bug with VS template
Fixed bug with model placed in non-root project folder

5.25.44 24-Sep-09

Implemented Rollback call when making Dispose for OracleTransaction
Fixed bugs in DataSet Wizard with Web Service projects
Fixed bug with licensing projects using wizard in nested folders of solution

LINQ to Oracle

Suported DeleteOnNull attribute of association and changed default behaviour (DeleteOnNull=false now)
Fixed bug with Contains() method

Entity Developer

Added support for EF Precision and Scale facets
Improved MS EDM Designer compatibility
Fixed bug with using Entity Developer in Web Site projects

Entity Framework support

Added support for Byte and SByte types
Increased performance for StartsWith, Contains and EndsWith methods
Fixed bug with ORA-00972 on long column names
Fixed bug with charset mismatch
Fixed bug with Take() and ordering

5.25.42 04-Sep-09

Fixed bug with licensing Startup projects
Fixed bug with using String.Format function computed at client side
Fixed bug with OracleDataSet and DataGridView on null values inserting
Fixed bug with packages and TableAdapter Configuration Wizard

LINQ to Oracle

Fixed bug with using objects from different contexts
Fixed bug with String.IsNullOrEmpty() function

Entity Developer

Added design time support for some EF facets
Enabled adding Schema name as prefix
Fixed bug with the connection reopen on refresh
Fixed bug with packages in different schemas

5.25.39 06-Aug-09

Added some installation command line options
Fixed bug with dotConnects and dbForge Fusion integration
Fixed bug with memory leak

Entity Developer

Fixed bug with Entity Set pluralization naming rule
Fixed bug with EntitySet property deserialization
Fixed bug with Source property for the added classes
Fixed bug with connection string quotation for the standalone projects
Fixed bug with the serialization of property accessors

Entity Framework support

Fixed bug with the Skip() method (redundant comma)
Fixed bug with associations' generation order in Update model from database model

5.25.37 14-Jul-09

Visual Studio 2010 Beta supported
ASP.NET Web Providers: Added requiresUniqueEmail functionality
Performance improvements in Direct mode when executing DML commands
Fixed bug with the SET command in OracleScript
Fixed bug with VarChar parameters in the Direct mode when Unicode=true
Fixed bug with ORA-01461 with Chinese charset in the Direct mode

LINQ to Oracle

Added support of the String.IsNullOrEmpty() method
Fixed bug with nested LoadWith() methods on the query level
Fixed bug with inserting parent and several child entities in one InsertOnSubmit() when keys are db-generated
Fixed bug with the AssociateWith() method and VB.NET
Fixed bug with Stored Procedure and out parameter types

Entity Developer

Advanced mapping with Entity Framework QueryView supported
Oracle packages supported
Displaying of Navigation properties on diagram and project explorer implemented
Ability to change properties order added
Ability to edit Referential constraints added
Ability to set OnDelete action added
Ability to set Rows Affected parameter added
Added dialogs for suitable storage model editing
Added advanced search on the model
Added support for storing connections in the configuration files
Added Entity Set Pluralization Naming Rule
Fixed bug with namespaces
Fixed bug with invisible OK button in Association Editor
Fixed bug with <edmx:*> tags
Fixed bug with XML Comments serialization

Entity Framework support

Fixed bug with ProviderManifestToken

5.20.33 21-May-09

Fixed bug with OracleLoader when Unicode mode is used
Fixed bug with parameters names in the Direct mode
Fixed bug with repeating parameters of OracleCommand in the Direct mode
Fixed bug with Dependency

LINQ to Oracle

Added support for CompiledQuery
Fixed bug with the ExecuteCommand() method
Fixed bug with Distinct and count symultaneous usage
Fixed bug with DevExpress 9 integration
Fixed bug with REF CURSOR as an out parameter in stored procedure
Fixed bug with the Long Raw and XMLType types mapping
Fixed bug with Guid Primary keys

Entity Developer

Fixed some code generation bugs

Entity Framework support

Fixed bug with functions from packages

5.20.29 28-Apr-09

LINQ to Oracle

Supported extended errors processing
Supported DataLoadOptions class and Include method for tuning data loading
Supported DeferredLoadingEnable functionality
Supported function import
Supported stored procedures as insert/update/delete behavior
Supported user-defined functions in selection part of a query
Supported CreateDatabase() and DeleteDatabase() methods
Supported SqlMethods class
Supported returning new Dictionary from query
Removed redundant TRIM() function calls
Fixed bug with OnValidate()
Fixed bug with associations based on non-Primary keys
Fixed bug with SingleOrDefault and BLOBs
Fixed bug with update of entities that declare a version member
Fixed bug with ArgumentException in the Contains() method
Fixed bug with the ExecuteQuery<PrimitiveType>() method

Entity Developer

Supported Entity Framework
Supported stored procedures and functions for LINQ to SQL
Added naming rules for database objects
Added Visual Studio integration
Validation schema improved
Entity Framework Complex Type supported
Entity Framework Storage Model editing supported
Many-to-Many associations retrieving added
Usability improvements
Stability and performance improvements

5.00.26 02-Apr-09

Added OracleCommand.PassParametersByName for stored procedure calls
Fixed bug with default format for OracleTimeStamp.ToString()
Fixed bug with functions from packages in DataSet Wizard
Fixed bug with TransactionScopeOption.RequiresNew
Fixed bug with DataSet stored procedures mapping
Fixed bug with serialization in C++ projects
Fixed bug with OracleLoader when Unicode mode is used

5.00.22 16-Feb-09

Fixed bug with DbDataTable in WPF applications
Fixed bug with binding DbDataTable to ComboBox in Mobile Edition
Fixed bug with Detail command in DbDataSet ParentRelation
Fixed bug with reading LONG columns in Unicode=true mode

LINQ to Oracle

Fixed bug with TransactionScope when read-only transaction is used
Fixed bug with default constructor of Devart.Data.Linq.DataContext
Fixed bug with Skip, Take methods on ordered query
Fixed bug with refreshing field values
Fixed bug with inserting several entities with autogenerated key in

5.00.20 14-Jan-09

Supported TransactionScope for Instance client in Direct mode
Fixed bug with .NET Compact Framework 3.5 support
Fixed bug with inserting CLOB values with national characters in Direct mode
Fixed bug with reading NVARCHAR fields in Direct mode
Fixed bug with Oracle objects in DbDataTable
Fixed bug with repeated parameters in SQL text in Direct mode

Entity Framework support

Forced SQL caching for all queries
Fixed bug with EdmGen support
Fixed bug with boolean parameters in stored procedures
Fixed bug with parameters in Top()
Fixed bug with incorrect MaxLength for string columns in the model

LINQ to Oracle

Fixed bug with implementation of Take() and Skip() methods
Fixed bug with Table.Attach function
Fixed bug with inserting and deleting entities with an associations
Fixed bug with supporting parameters IsDbGenerated, IsVersion, UpdateCheck, CanBeNull in ColumnAttribute
Fixed bug with refreshing key fields when an association is present

5.00.16 05-Dec-08

Fixed bug with Guid type in properties in LINQ to Oracle
Fixed bug with null value of EntityRef field in LINQ to Oracle
Fixed bug with Queriable.Cast to interface type in LINQ to Oracle
Fixed bug with NVARCHAR fields
Fixed bug with submitting changes in DbDataTable on WPF
Fixed bug with duplicate column mapping

Entity Framework support

Fixed bug with some procedures missing in the model
Fixed bug with deselected objects appearing in the Update wizard
Added ORDER BY clause in a subquery for correct functioning of Take() after Skip()

5.00.12 13-Nov-08

OraDirect .NET renamed to dotConnect for Oracle
Supported LINQ to Oracle
Added Entity Developer for LINQ to Oracle
Added free Express Edition with basic connectivity features
Added Developer Edition, which is equivalent to the Professional Edition plus OraDeveloper Tools
TransactionScope supported
Support for .NET Framework 1.x is discontinued
Fixed several bugs in DataSet Wizard
Fixed bug with describing INTERVAL AND TIMESTAMP columns with 0 seconds fraction
Fixed bug with Unicode string value in NCLOB parameters
Fixed LINQ to Oracle bug with inserting new objects by adding them to EntitySet collection

Entity Framework support

Improved performance of EDM Wizard
EDM Wizard now supports system privileges SELECT ANY TABLE and EXECUTE ANY PROCEDURE
EDM Wizard now supports grants and privileges of the user's role
Fixed bug with quoting names that include special symbols
Fixed type mapping in models with inherited entities
Fixed bug with GUIDs in RAW columns
Fixed bug with comparing DateTime values that include nanoseconds

4.75.44 27-Oct-08

Improved /silent install parameter
Added /verysilent install parameter
Added /nofeedback uninstall parameter

4.75.43 26-Sep-08

Fixed bug with OracleLoader.SetNumber() method
Fixed bug with SDO_GEOMETRY objects in Unicode=true mode
Fixed bug with several equivalent SQL parameter names in Direct mode
Fixed bug with seconds fraction of OracleTimeStamp.Value
Fixed bug with wrong display of stored procedures and functions in Select Data Source page of DataSet Wizard
Fixed bug with UniqueConstraint generation in DataSet Wizard
Fixed bug with wrong Relation generation in case of several columns in constraint
Fixed bug with wrong Relation generation after changing column mapping
Fixed bug with wrong AllowDBNull mapping in DataSet Wizard

Entity Framework support

Improved support for server-generated values
GUID is now mapped to the RAW(16) Oracle type
NULLs can now be used in typed expressions
Entity Framework is now supported for server versions 9.2.0.4 and higher
Fixed bug with updating large CLOB, NCLOB, and XMLTYPE fields
All Oracle database reserved words are quoted

4.75.42 09-Sep-08

Fixed bug with OCI calls on x64 platform
Fixed bug with Preview Data in DataSet and DataAdapter components when data exceeds the System.Decimal's scale

Entity Framework support

Now objects in edmx models can be named without the schema prefix
Improved EDM Wizard's performance on large databases

4.75.41 29-Aug-08

Fixed bug with national characters in parameter names
Fixed bug with context menu in the DataSet Manager

4.75.40 27-Aug-08

Entity Framework support

Improved support for Entity SQL canonical functions: Right, Day
Supported Entity SQL canonical functions: Left, Year, Month, Hour, Minute, Second, BitwiseAnd, BitwiseOr, BitwiseXor, NewGuid, CurrentDateTimeOffset, GetTotalOffsetMinutes
Supported parameters in the Top() and Take() methods
Supported binary constants
Fixed bug with updating entities in concurrency mode
Fixed bug with MINUS (EXCEPT) implementation
Fixed problem with module division

4.75.39 20-Aug-08

Supported .NET Framework 3.5 Service Pack 1
Supported Visual Studio 2008 Service Pack 1
Fixed bug with OracleDependency.IsNotifiedOnce
Fixed bug with serialization of OracleParameter.SourceColumnNullMapping

Entity Framework support

Supported inserting, updating, and deleting entities with stored procedures
Supported Create Function Import dialog
Supported REF CURSORs
Supported user-defined SQL queries as functions in SSDL
Oracle type INTERVAL DAY TO SECOND is now mapped to System.TimeSpan
Fixed bug with skipping records when the query is sorted not by the primary key

4.70.38 21-Jul-08

Added collections PrimaryKeys and PrimaryKeyColumns to OracleConnection.GetSchema
Fixed bug with OracleQueue operating in a schema other than it was connected to
Fixed bug with filling tables that have composite keys
Fixed bug with connection strings from app.config and Server Explorer
Fixed bug with DataSet Wizard in Visual Studio 2008
Unified provider name in Visual Studio 2008 (Devart.Oracle instead of Devart.Oracle.Entity)

Entity Framework support

Supported StoreGeneratedPattern attribute with values Identity and Computed (manual mapping required)
Supported System.Guid type (manual mapping required)
Fixed bug with method Skip()
Fixed bug with tables not owned by the current user
Fixed type mapping in EntityKey.EntityKeyValues
Fixed definitions of some provider-specific functions in Entity SQL

4.70.37 25-Jun-08

Connection strings from web.config are now available in Visual Studio 2008 design time
Improved OracleDataSource design time capabilities
Fixed bug with DataLink design time

Entity Framework support

XMLTYPE columns supported
NUMBER columns are now mapped to Decimal, Double, Int64, Int32, and Boolean, depending on column precision and scale
EDM Wizard is capable of operating in schemas not owned by the current user (Oracle 10g and above)
Added partial support for Table of Object (the table must have a primary key, and all object fields must be primitive)
EDM Wizard no longer shows deleted tables
Fixed several bugs with package stored procedures support

4.70.36 04-Jun-08

Fixed bug with dotConnect for Oracle Data Provider missing in the EDM wizard
Fixed bug with inserting a row in DbDataTable when a filter is enabled

4.70.35 29-May-08

Supported .NET Framework 3.5 Service Pack 1 Beta
Supported Visual Studio 2008 Service Pack 1 Beta
Improved support for ADO.NET Entity Framework

4.60.34 19-May-08

Fixed bug with connection when server reports some warning message
Fixed bug with FetchSize in REF CURSOR parameters
Fixed bug with updating tables using queries with ROWID field
Fixed bug with disposing statement handle in REF CURSOR parameters
Fixed bug with converting strings to numbers on Cisco computers

4.60.33 23-Apr-08

Supported Visual Studio designers for Entity Framework
Improved Entity Framework run-time support
Fixed bug with user identification in session information in Mobile edition
Fixed bug with OracleDataTable.Load and ROWID fields
Fixed bug with OracleConnection.GetServerList and names ending with "WORLD"

4.50.32 04-Apr-08

Fixed bug with inherited forms in Interform links
Fixed bug with invalid LOB locator in Direct mode
Fixed bug with DbDataTable.RowFetched event in asynchronous mode
Fixed bug with Analysis provider design time

4.50.31 19-Mar-08

Fixed bug with licensing in Delphi for .NET and RAD Studio 2007
Fixed bug with reading BLOB value
Fixed bug with OracleQueue in Direct mode
Fixed bug with disposing OracledataReader in proxy connections
Fixed bug with null cursor parameter in Direct mode
Fixed bug with OracleDataSource designer

4.50.30 26-Feb-08

Added DB server-based data paging for ASP.NET applications
OracleDataSource design time improvements
ASP.NET demo pack added
Oracle ANYDATA type supported
OracleSelectStatement.TryParse method added
OracleXml class now can work without a connection
DataLink.DataSource property can refer to another DataLink component
Fixed bug with executing Entity Framework queries
Fixed bug with DbDataTable and some visual controls
Fixed bug with DbDataTable.FillPage method
Fixed bug with assigning OracleTimeStamp value to OracleObject attribute

4.35.29 13-Feb-08

Fixed bug with OracleDataReader.GetValue for REF CURSOR field
Fixed bug with seconds fraction of OracleIntervalDS
Fixed bug with generating schema in EDM Wizard

4.35.28 18-Jan-08

Fixed bug with OracleDataReader.GetString for XMLTYPE field
Fixed bug with DbDataTable.Clone and expression columns
Fixed bug with DDEX in Visual Studio 2008
Fixed bug with mobile projects when dotConnect Mobile for Oracle is not installed
Fixed bug with reading empty LOBs in Direct mode

4.35.27 20-Dec-07

Visual Studio 2008 supported
Entity Framework Beta 3 supported
Added Licensing Information dialog

4.30.26 13-Dec-07

Fixed bug with compiling web applications in CodeGear RAD Studio 2007
Fixed bug with DataSet Wizard when editing standard DataSets
Fixed bug with OracleDate format when converting it to string
Fixed bug with overflow in conversion from decimal types to OracleNumber

4.30.25 19-Nov-07

Oracle version 11g supported
Fixed bug with filling DataSet asynchronously
Fixed bug with hidden columns in DataSet Wizard
Fixed bug with DataSet generator
Fixed bug with .NET Entity Framework support
Fixed bug with licensing in multithreaded applications

4.25.24 05-Nov-07

Fixed bug with schema generator for .NET Entity Framework
Fixed bug with case sensitive names in DbDataTable.ParentRelation

4.25.23 26-Oct-07

.NET Entity Framework Beta 2 supported
Visual Studio 2008 Beta 2 supported
Added Visual Basic versions to CRM, WinForms, and Web samples
Fixed bug with fetching LONG fields
Fixed bug with OracleQueue component and multi-consumer queues
Fixed bug with CLOB parameters in Direct mode
Fixed bug with editing filtered and sorted DbDataTable
Fixed bug with design time editors of DbDataTable.ParentRelation
Fixed bug with editing relation resultset with DataLink
Fixed bug with building Refresh SQL when TableMappings are used
Fixed bug with converting large OracleDate to string
Fixed bug with editing OracleConnection in design time

4.20.22 18-Sep-07

Bug with truncating procedure name in Unicode mode fixed
Bug with Oracle objects in Unicode mode fixed
Bug with Enterprise Library missing in the installation fixed
Bug with license on dotConnect Mobile for Oracle fixed
Bug with Visual Studio 2005 integration fixed
Bug with OracleDataTable design-time fixed
Bug with DataSet Wizard fixed
Bug with InterForm design time fixed

4.20.21 04-Sep-07

Bug with OracleDataTable component designer fixed
Bug with creating typed DataSet from stored procedure fixed
Bug with OracleObject attributes in Unicode=true mode fixed
Bug with updating OracleRef objects fixed
Bug with OracleDataSet.ReadXml method fixed

4.20.20 30-Aug-07

Supported Visual Studio codename Orcas Beta 1
Supported .NET Entity Framework
Supported Proxy Authentication
Supported OCI Pooling
Enhanced command builder with generation of row refresh statements
Added detailed warning information to OracleInfoMessageEventArgs class
Added DbCommand.GetRecordCount() method to determine rows count of a request
Added INullable interface for provider specific types
Improved LOBs performance in Direct mode
Added capability to store connection strings in application settings
Improved integration with OraDeveloper Tools
Extended drag'n'drop capabilities in DataSet Manager
Add-in menu moved to Visual Studio package
Demo projects reorganized
Added CRM (Customer Relationship Management) demo project
Added Ping demo project for Mobile Edition

4.00.14 30-May-07

Bug with OracleConnection in Mobile Edition fixed
IFILE clause supported in OracleConnection.GetServerList method
Bug with OracleObject attribute values fixed
Bug with DbDataSet.ReadXml() fixed
Bug with closing IDbDataReader in DbDataTable fixed
Bug with OracleSelectStatement fixed

4.00.13 03-May-07

Application development enhancement

Added DataSet Manager to control dataset instances in the project
Added DataSet Editor for convenient datasets manipulation
New OracleDataSet class to use with OracleDataTable
New component DataLink added for flexible data binding
New capabilities added to OracleDataTable class
Added capability for cross-form components cooperation
Design time visualization extended
Supported addin, DataSet Wizard, and OraDeveloper Tools integration with Borland Developer Studio

.NET 2 features

Added OracleDependency class to support Database Change Notification
Added OracleDataSourceEnumerator class to support Server Enumeration feature
Added support for Batch Update in OracleDataAdapter
Added support for returning provider-specific types in OracleDataReader and OracleDataAdapter

Advanced Oracle features

LOBs and Oracle Objects now entirely support the disconnected model
Supported Oracle Advanced Queue technology
New OracleAlerter component added
New OraclePipe component added
New OracleTrace component added
Oracle Client Software x64 supported
Added support for custom UDT classes
Added support for IN and IN/OUT REF CURSORs
OracleDataAdapter now supports sequential fetch
Added new class OracleGlobalization for managing culture settings

Other features

SQL Server 2005 Business Intelligence Solutions supported
Added OracleSelectStatement class for building SELECT statements
Added list of servers in connection form and connection properties
Added OracleLoader.LoadTable method
Added DbLoader class that serves to load external data into database
Added dotConnect for Oracle information to Visual Studio 2005 splash screen and About box
Base level classes moved to the new assembly Devart.Data.dll
New demo projects added
Bug with handling broken connections in connection pool fixed
Bug with InputOutput VARCHAR parameters fixed

OraDeveloper Tools 2.00 improvements

Added PL/SQL and SQL script debuggers
Added a project management framework for bookmarking related scripts and organizing database developments
Enhanced SQL Editor with context-sensitive code completion, code navigation, incremental search, and more
Enhanced working with data, including possibility to print data directly from data editor
Added search in object data and source code
Added an extensive collection of SQL and PL/SQL code templates
Completely redesigned Security Manager for controlling user accounts
Added a Session Manager for controlling and analyzing user sessions
Added an Event Monitor for exchanging signals between database connections
Extended Oracle schema object support, including support for XML Schemas, Materialized Views, and Materialized View Logs

3.55.17 22-Dec-06

Bug with Visual Studio 2005 integration fixed

3.55.16 14-Dec-06

Bug with installation fixed

3.55.15 12-Dec-06

Windows Vista support added

3.50.14 01-Nov-06

Bug with creating DataSet from stored procedure in DataSet wizard fixed
Bug with case-sensitive UserName, Email, ApplicationName, RoleName in Web providers fixed
Bug with removing items in OracleSessionStateStore provider fixed
Bug with error message when decryption key is not defined in OracleMembershipProvider fixed
Bug with DataSet Wizard on x64 platform fixed
Memory leak with Oracle Client 8.0.6 fixed

3.50.13 21-Sep-06

Integration with Visual Studio 2005 Standard edition supported
Bug with handling broken connections in connection pool fixed
Bug with generating OracleArray parameters with Package wizard fixed
Bug with updating table using public synonym fixed
Bug with processing error on creating users with Membership provider fixed
Bug with getting property values with Profile provider fixed
Bug with processing error on adding users to roles in Role provider fixed
Bug with OracleObject attributes with nested OracleRef fixed

3.50.12 23-Aug-06

Data Design Extensibility (DDEX) features supported for Visual Studio 2005 Standard Edition

3.50.11 30-May-06

Bug with fetching BFILE fixed
Bug with processing warnings during fetch operation fixed
Bug with errors processing with DML array parameters fixed
Bug with VARCHAR2 output parameters in Unicode=true fixed
Bug with describing Oracle types with recursive links fixed
Bug with filling REF objects to DataSet fixed
Bug with fetching ROWID fields fixed

3.50.9 17-Apr-06

Implemented advanced integration with Visual Studio 2005, including Server Explorer, Data Source wizard, TableAdapter configuration, Query Builder and configuring web component SqlDataSource
ASP.NET 2.0 providers added: Membership Provider, Profile Provider, Role Provider, Session State Provider
Capability to call dotConnect for Oracle runtime assemblies by partially trusted code added
DataSet Wizard added
Enterprise Library Data Access Application Block support added
Mono support added
Borland Delphi 2006 support added
Added streaming support for OracleScript
OraDeveloper Tools installation separated from dotConnect for Oracle installation
OracleConnection.Client version now returns four digits
Licensing for applications that call dotConnect for Oracle through DbProviderFactory added. This allows to use dotConnect for Oracle in SQL Server 2005 Business Intelligence Solutions
Bug with OracleConnection.GetServerList fixed
Bug with OracleParameter.this[int] and null elements fixed
Bug with BreakExec in Direct mode fixed
Bug with Package generation wizard fixed
Bug with returning string parameters when Unicode=true in Direct mode fixed
Bug with OraclePackage.DescribeProcedure fixed
Bug with setting empty parameter in connection string fixed
Bug with parameters regenerating in OracleDataAdapter editor fixed
Migration wizard design enhanced
Bug with OracleMonitor messages in Visual Studio Output window fixed
Bug with statement caching fixed

3.20.7 02-Feb-06

Bug with licensing fixed
Bug with returning NULL PL/SQL table parameter fixed
Bug with OracleTransaction.Dispose() fixed
Bug with OracleDataReader on Oracle 10g fixed
Bug with national characters in command text when Unicode=true in Direct mode fixed

3.20.6 28-Dec-05

Supported .NET Framework 2.0 release version
Supported Visual Studio 2005 release version
Compact .NET Framework 2.0 supported
Bug with detecting unique indexes in schema table fixed
Bug with application information in session view in Direct mode fixed
Bug with closing connection after network error in Direct mode fixed
Bug with Oracle 10g Standard and Instant client homes fixed
Bug with updating ROWID fields fixed
Bug with boolean parameters in stored procedure fixed
Bug with detecting error offset in Direct mode fixed
Bug with detecting parameters in SQL with comments in Direct mode fixed
Bug with processing warnings during fetch operation fixed
Default value for OracleCommandBuilder.QuotePrefix set to '"'
Bug with inserting empty array to BLOB field fixed
Bug with exception messages in dotConnect Mobile for Oracle fixed
OracleParameter now returns DBNull.Value for NULL result
Bug with describing TIMESTAMP parameters of stored procedure in Direct mode fixed

OraDeveloper Tools improvements (Professional edition only)

Database export/import
Script support
Stop execution feature
Execution of the selected SQL fragment feature
Data Export feature
Dynamic data viewing of the tables and views in DbExplorer
Paginal data access mode
LOB viewer/editor
Database object search
Duplicate object feature
DDL generation wizard
Data grid colors customizing

3.01.5 28-Oct-05

Sample projects for dotConnect Mobile for Oracle added
Bug with length of DML array parameters fixed
Bug with reading LOB parameters fixed

3.01.4 17-Oct-05

Bug with OracleMonitor and warning messages fixed
Bug with BLOBs in Direct mode fixed
Performance improved in working with Oracle Object types
Bug with using dotConnect for Oracle in CLS-compliant projects fixed

3.01.3 19-Sep-05

Native exception in dotConnect Mobile for Oracle fixed
Bug with OracleDataReader.IsDBNull() for LONG fields fixed
Bug with result of OracleCommand.ExecuteNonQuery fixed
Bug with result BLOB parameter in strored procedure fixed
Bug with national charsets in Direct mode fixed
Bug with returning parameters in stored procedures fixed
Bug with stored procedure name in CommandText fixed

3.01.2 29-Jul-05

Bug with VARCHAR fields fixed in Direct mode
Bug with LONG parameters fixed
Bug with failed connections in connection pool fixed
Bug with Prepare event in OracleMonitor fixed
Bug in Database Connection Properties dialog with Direct mode is fixed
Bug with describing table storage options is fixed

3.01.1 11-Jul-05

OracleCommandBuilder.UpdatingFields property added
OracleLoader now inherits from DbLoader class
Bug with GetRowId on Oracle client 8.1.7 fixed
Bug with RECORD return parameters of stored proc fixed
Bug with OracleConnection.ClientVersion fixed
Bug with finalization of OracleDataReader in Direct mode fixed
Bug with retrieving procedure parameters on Oracle 7 fixed
Bug with OracleDate parameters on Oracle 7 fixed
Bug with Long parameters on Oracle 7 fixed

3.00.0 03-Jun-05

Access to Oracle server without Oracle client software with Direct mode
Support for .NET Compact Framework added with Mobile edition
OracleDataTable component greatly enhanced with OracleObject and Arrays advanced data binding and update capabilities
New functionality added to OracleScript component
Oracle warning support added to OracleConnection.InfoMessage event
Interface enhanced for OraclePackage component
Publisher policy file added for versions compatibility
Support for Microsoft Visual Studio 2005 Beta 2 added

Design-time tools are completely revised, extended and called OraDeveloper Tools (Professional edition only)

Visual editors for Oracle schema objects added
Query Builder tool rewritten and improved
SQL editor tool improved
Execution plan visualization tool added
Ability to drag connections, tables and stored procedures from DbExplorer to Form Designer added
Component designers more tightly integrated with OraDeveloper Tools

2.50.1 11-May-05

Bug with Loader fixed
Bug with OracleConnection.ChangePassword fixed
Bug with VARCHAR fields in Unicode mode fixed
Bug with OracleTimestamp precision fixed

2.50.0 06-Jan-05

Support for .NET Framework 2.0 added
Support for Microsoft Visual Studio .NET 2005 Beta 1
Borland Delphi 2005 support added
Support ADO.NET 2 features including:
- Support for metadata schemas added
- The Base-Class-Based provider model used
- Connection pooling enhancements functionality added, that allows you to programmatically "drain" the connection pool
- New OracleConnectionStringBuilder component to build connection strings to represent data sources
Documentation enriched

2.40.4 08-Oct-04

Bug with OracleObject OUT parameters fixed
Bug with passing NULL values for OracleObject datatype
Bug with OracleCommand executing when behavior is SingleResult and parameter is REF CURSOR fixed

2.40.3 28-Sep-04

Bug with TableMappings generation for REF CURSOR fixed
Bug with transaction support fixed
Bug with OracleParameter CodeDOM serialization fixed

2.40.2 17-Aug-04

Bug with NCLOB charsets fixed
Bug with OracleArray.Clear method fixed
Bug with Unicode mode fixed

2.40.1 30-Jul-04

Bug with NUMBER parameters fixed
Bug with fetch NCLOB values fixed
Bug with fetch LONG values fixed

2.40.0 21-Jul-04

Performance increased
New component OracleDataTable added
New methods for asynchronous working added
Support for paginal access to query result added
Support for multiple ExecuteReader added
Retrieve ROWID to dataset 'ROWID' column added
Parameter editor extended for Array and Tables datatypes
Datatype conversions ability extended for OracleParameter.Value
Bug with NCLOB parameters fixed
Bug with LONG values in PL/SQL tables fixed
Bug with OracleException message retrieving fixed

2.30.2 18-May-04

OracleLoader performance was increased
Using PL/SQL RECORDs as stored proc parameters bug was fixed

2.30.1 14-May-04

Memory usage is optimized to fetch VARRAY datatype
Oracle10g homes bug fixed
Decsribing Object members bug fixed

2.30.0 30-Apr-04

Oracle 10g support
Multiple home environment
XMLType support
Supports BINARY_FLOAT and BINARY_DOUBLE types
Oracle 10g Instant Client support
Dynamic fetch size feature added
Statement caching (Oracle 10g only)
Transparent Application Failover (TAF) support
Overloaded stored procedures
RECORD data type as parameters type
Schema table for REF cursor's and nested tables
Working with VARRAY and TABLE data types as native .NET array types
OracleDataReader.HasRows property added
OracleCommand.GetRowId method for native Oracle ROWID
OracleCommand.Cancel method supported
OracleError and OracleErrorCollection for Array Binding errors
OraclePermission class and attribute added

2.01.1 04-Mar-04

Oracle NUMBER to Decimal conversion bug fixed
VARRAY inside Oracle object types was fixed
Searching Oracle client library order was changed to correspond PATH environment variable value

2.01 12-Feb-04

Support for Borland Delphi 8 added
Support for Borland C#Builder 1.0 added

2.00.7 06-Feb-04

Bug with Oracle objects fixed

2.00.6 22-Jan-04

New method GetOracleValue for retrieve native Oracle values added
Bug with Oracle objects describe fixed
Bug with schema table fixed

2.00.5 24-Nov-03

Bug with nested tables was fixed
Performance execution inside non-default domain was increased

2.00.4 29-Oct-03

Bug with loading design-time classes was fixed

2.00.3 22-Oct-03

Bugs with Oracle 8.1.7 server was fixed
Bugs with Oracle 8.0.5 server was fixed

2.00.2 10-Oct-03

Connection string editor added
Bug with UNICODE connection parameter fixed
Bug with PL/SQL Table parameters fixed

2.00 03-Oct-03

Fully rewritten 100% managed code
Available Standard and Professional editions
Support Oracle 9i types such as TIMESTAMP, INTERVAL
Support Oracle object types OBJECT, VARRAY, TABLE, REF
Native classes and structures to represent Oracle types
Connection pooling support
Unicode support added
Array binding feature support
PL/SQL tables support
Fill DataSet with several REF CURSOR
OS authentication enabled
DBA privileges to open a session with
Controlling automatic commit data for the connection
Enables changing expired password
Transaction savepoints support added
Optimization fetching data with OracleCommand.FetchSize property
Getting offset of the error in SQL statement
dotConnect for Oracle help integrated into Visual Studio .NET
XML documentation for code completion added
Migration wizard from MS OracleClient and ODP.NET Data Providers
Typed Oracle package wizard
Support for Borland C#Builder added
New sample applications added

1.55 24-Jun-03

Visual Studio .NET 2003 support added
Property editors for OracleCommandBuilder.KeyFields and OracleCommandBuilder.UpdatingTable added

1.50 11-Feb-03

New component OracleScript added. Serves to execute series of SQL statements separated by special symbols, like SQL*Plus scripts
New component OracleLoader added. Serves to load external data into the Oracle database. Uses direct path load interface to speed up loading
New component OracleMonitor added. Allows to monitor dynamic SQL execution in applications that use dotConnect for Oracle. Extended monitoring capabilities are provided with DBMonitor application
New component OraclePackage added. Provides access to packages stored in Oracle database
OracleConnection.Home property added to support Oracle Homes
OracleConnection.Error event added
OracleConnection.GetServerList() static method added
Performance greatly increased
Designer form for OracleDataAdapter component setup added
OracleCommand component designer functionality extended
Typed dataset generation mechanism enabled for OracleDataAdapter
Automatic component registration (in toolbox) mechanism added
OraDesigner, OraExplorer, OraBuilder and OraDebugger are now embedded into dotConnect for Oracle
BlobPictures, Loader, Pictures, StoredProc samples added
Visual Basic .NET samples added
Many bugs fixed

1.20 17-Jul-02

ASP.NET sample project
MasterDetail sample project
UnloadedAppDomain bug fixed
Special characters in connect string bug fixed
Statement handle not executed bug fixed (1212)

1.12 13-Jun-02

SchemaInfo bug fixed (1230)
OracleConnection [@name.globalname] connection string bug fixed (1322)
OracleCommand.CommandText property editor added
Design-time bug with sp describe fixed (1134)
References to extensibility and envdte removed from OracleDesign (1152)
Design-time execution bug with not caught exception fixed (1123)
WaitCursor for design-time describe added (1208)
OraTools version added to About form (1231)

1.10 15-May-02

DataSet sample project
DataReader sample project
Table sample project
"Designer..." verb added to OracleConnection ComponentDesigner
Add-in bug with help menu fixed

OracleCommand editor form

tables and stored procedures list is accessible from additional ComboBox
removed from taskbar
some interface bugs fixed: anchors bug, parameter list bug
out parameter values are available on execute now

1.00 09-Apr-02

First release of dotConnect for Oracle 1.00