dotConnect for Oracle Professional Edition Changelog

What's new in dotConnect for Oracle Professional Edition 10.3.10

Jan 18, 2024

.NET 8 compatibility
Visual Studio 2022 version 17.9 Preview is supported
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
LinqConnect (formerly known as LINQ to MySQL):
.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

New in dotConnect for Oracle Professional Edition 10.1.151 (Jun 6, 2023)

New in dotConnect for Oracle Professional Edition 10.1.134 (Mar 3, 2023)

New in dotConnect for Oracle Professional Edition 10.0.0 (Jul 1, 2022)

New in dotConnect for Oracle Professional Edition 9.16.1434 (Jan 25, 2022)

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

New in dotConnect for Oracle Professional Edition 9.15.1410 (Dec 21, 2021)

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
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

New in dotConnect for Oracle Professional Edition 9.14.1382 (Nov 9, 2021)

New in dotConnect for Oracle Professional Edition 9.14.1369 (Oct 21, 2021)

New in dotConnect for Oracle Professional Edition 9.14.1353 (Sep 28, 2021)

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 EntityEFCore3Devart.Data.Oracle.Entity.EFCore.dll

New in dotConnect for Oracle Professional Edition 9.14.1312 (Jul 30, 2021)

New in dotConnect for Oracle Professional Edition 9.14.1298 (Jul 8, 2021)

New in dotConnect for Oracle Professional Edition 9.14.1273 (Jun 3, 2021)

New in dotConnect for Oracle Professional Edition 9.14.1234 (Apr 9, 2021)

New in dotConnect for Oracle Professional Edition 9.14.1228 (Apr 1, 2021)

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

New in dotConnect for Oracle Professional Edition 9.14.1204 (Feb 18, 2021)

New in dotConnect for Oracle Professional Edition 9.14.1180 (Jan 14, 2021)

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

New in dotConnect for Oracle Professional Edition 9.14.1160 (Dec 17, 2020)

New in dotConnect for Oracle Professional Edition 9.14.1150 (Dec 3, 2020)

New in dotConnect for Oracle Professional Edition 9.13.1127 (Oct 29, 2020)

New in dotConnect for Oracle Professional Edition 9.13.1107 (Oct 1, 2020)

New in dotConnect for Oracle Professional Edition 9.13.1098 (Sep 17, 2020)

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 EntityEFCore3Devart.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

New in dotConnect for Oracle Professional Edition 9.12.1064 (Jul 30, 2020)

New in dotConnect for Oracle Professional Edition 9.12.1054 (Jul 16, 2020)

New in dotConnect for Oracle Professional Edition 9.11.1034 (Jun 17, 2020)

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 SQL generation in EF Core 3, when enum values are used in CASE and COALESCE statements, 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

New in dotConnect for Oracle Professional Edition 9.11.980 (Apr 2, 2020)

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

New in dotConnect for Oracle Professional Edition 9.11.951 (Feb 20, 2020)

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

New in dotConnect for Oracle Professional Edition 9.9.887 (Nov 21, 2019)

New in dotConnect for Oracle Professional Edition 9.9.872 (Oct 31, 2019)

New in dotConnect for Oracle Professional Edition 9.9.867 (Oct 24, 2019)

New in dotConnect for Oracle Professional Edition 9.8.838 (Sep 13, 2019)

New in dotConnect for Oracle Professional Edition 9.7.805 (Jul 25, 2019)

New in dotConnect for Oracle Professional Edition 9.7.790 (Jul 4, 2019)

New in dotConnect for Oracle Professional Edition 9.7.770 (Jun 6, 2019)

New in dotConnect for Oracle Professional Edition 9.7.734 (Apr 12, 2019)

New in dotConnect for Oracle Professional Edition 9.6.725 (Mar 28, 2019)

New in dotConnect for Oracle Professional Edition 9.6.696 (Feb 14, 2019)

New in dotConnect for Oracle Professional Edition 9.6.675 (Jan 10, 2019)

The bug with calling OracleDataReader.IsDBNull() for a NULL value from an XMLTYPE column is fixed
The bug with connecting to a localhost in the Direct mode is fixed
The bug with connecting to Oracle 12c in the Direct mode is fixed
LinqConnect (formerly known as LINQ to Oracle):
The new overload DataContext.Refresh(bool ignoreErrors, RefreshMode mode, object entity) is added for ignoring errors during refresh
The existing overload DataContext.Refresh(RefreshMode mode, object entity) is improved: its check avoids the try to refresh the entity that is added to the context but not submitted to the database
The type and text of the error generated by the DataContext.Refresh(RefreshMode mode, object entity) method, when the passed entity doesn't exist in database, is fixed
Entity Developer:
The multiple select functionality in EF Core Model is improved: now it allows setting PrimaryKey, ValueGenerated, Concurrency for several properties simultaneously
The bug with detecting order of columns in composite primary key with two or more columns by Update To Database and by Update From Database wizards in EF Core is fixed
The bug with using ASP.NET Core Web Application (.NET Framework) and Azure Functions v1 (.NET Framework) projects in Visual Studio 2017 is fixed
Entity Framework support:
Entity Framework Core 2.2.1 is supported
The new extension method Database.IsOracle() in EF Core 2 is implemented
The .HasComputedColumnSql functionality in EF Core Code-First Migrations is supported
The performance of Entity Data Model Wizard is improved
The bug with applying config.Workarounds.IgnoreSchemaName=true to the .ToTable() functionality in EF Core 2 is fixed
The bugs with using the GuidToStringConverter, EnumToStringConverter, ValueConverter classes in EF Core 2 are fixed
The bug with constructing the LIKE clause in EF Core 2 is fixed
The bug with generating a subselect within the SELECT list in EF Core 2 is fixed
The bug with applying an aggregate function to the result of a subselect in EF Core 2 is fixed
The bug with throwing "ORA-00907: missing right parenthesis" in EF Core 2 is fixed
The bug with accessing FKs, when the SELECT permission is granted through roles, by Entity Data Model Wizard is fixed

New in dotConnect for Oracle Professional Edition 9.6.646 (Nov 29, 2018)

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

New in dotConnect for Oracle Professional Edition 9.6.621 (Oct 25, 2018)

New in dotConnect for Oracle Professional Edition 9.6.597 (Sep 20, 2018)

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

New in dotConnect for Oracle Professional Edition 9.6.584 (Aug 31, 2018)

New in dotConnect for Oracle Professional Edition 9.6.570 (Aug 10, 2018)

New in dotConnect for Oracle Professional Edition 9.6.558 (Jul 19, 2018)

New in dotConnect for Oracle Professional Edition 9.6.540 (Jun 22, 2018)

New in dotConnect for Oracle Professional Edition 9.5.520 (May 25, 2018)

New in dotConnect for Oracle Professional Edition 9.5.502 (Apr 27, 2018)

New in dotConnect for Oracle Professional Edition 9.5.4583 (Mar 30, 2018)

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

New in dotConnect for Oracle Professional Edition 9.5.454 (Feb 15, 2018)

New in dotConnect for Oracle Professional Edition 9.5.429 (Jan 12, 2018)

New in dotConnect for Oracle Professional Edition 9.5.399 (Nov 24, 2017)

New in dotConnect for Oracle Professional Edition 9.5.381 (Oct 30, 2017)

New in dotConnect for Oracle Professional Edition 9.4.348 (Sep 7, 2017)

New in dotConnect for Oracle Professional Edition 9.4.326 (Aug 4, 2017)

New in dotConnect for Oracle Professional Edition 9.4.314 (Jul 13, 2017)

New in dotConnect for Oracle Professional Edition 9.4.299 (Jun 23, 2017)

New in dotConnect for Oracle Professional Edition 9.4.280 (May 25, 2017)

.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 EF Core is fixed

New in dotConnect for Oracle Professional Edition 9.3.230 (Mar 20, 2017)

New in dotConnect for Oracle Professional Edition 9.2.220 (Mar 3, 2017)

New in dotConnect for Oracle Professional Edition 9.2.205 (Feb 9, 2017)

New in dotConnect for Oracle Professional Edition 9.2.200 (Feb 3, 2017)

New in dotConnect for Oracle Professional Edition 9.2.187 (Jan 17, 2017)

New in dotConnect for Oracle Professional Edition 9.2.172 (Dec 27, 2016)

New in dotConnect for Oracle Professional Edition 9.2.162 (Dec 13, 2016)

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

New in dotConnect for Oracle Professional Edition 9.1.131 (Nov 11, 2016)

New in dotConnect for Oracle Professional Edition 9.1.121 (Nov 11, 2016)

New in dotConnect for Oracle Professional Edition 9.1.111 (Nov 11, 2016)

New in dotConnect for Oracle Professional Edition 9.1.97 (Nov 11, 2016)

New in dotConnect for Oracle Professional Edition 9.1.82 (Nov 11, 2016)

New in dotConnect for Oracle Professional Edition 9.1.67 (Nov 11, 2016)

New in dotConnect for Oracle Professional Edition 9.1.55 (Jul 21, 2016)

New in dotConnect for Oracle Professional Edition 8.4.344 (Feb 12, 2015)

New in dotConnect for Oracle Professional Edition 8.4.342 (Feb 12, 2015)

New in dotConnect for Oracle Professional Edition 8.4.333 (Feb 12, 2015)

New in dotConnect for Oracle Professional Edition 8.4.313 (Feb 12, 2015)

New in dotConnect for Oracle Professional Edition 8.4.303 (Feb 12, 2015)

New in dotConnect for Oracle Professional Edition 8.4.293 (Feb 12, 2015)

New in dotConnect for Oracle Professional Edition 8.4.283 (Feb 12, 2015)

New in dotConnect for Oracle Professional Edition 8.4.274 (Feb 12, 2015)

New in dotConnect for Oracle Professional Edition 8.4.264 (Feb 12, 2015)

New in dotConnect for Oracle Professional Edition 8.4.254 (Feb 12, 2015)

New in dotConnect for Oracle Professional Edition 8.2.103 (Feb 18, 2014)

New in dotConnect for Oracle Professional Edition 8.2.100 (Feb 15, 2014)

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

New in dotConnect for Oracle Professional Edition 8.2.90 (Feb 1, 2014)

New in dotConnect for Oracle Professional Edition 8.2.80 (Jan 17, 2014)

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

New in dotConnect for Oracle Professional Edition 8.1.65 (Dec 27, 2013)

New in dotConnect for Oracle Professional Edition 8.1.55 (Dec 20, 2013)

New in dotConnect for Oracle Professional Edition 8.1.45 (Dec 20, 2013)

New in dotConnect for Oracle Professional Edition 8.1.36 (Dec 20, 2013)

New in dotConnect for Oracle Professional Edition 8.1.26 (Dec 20, 2013)

New in dotConnect for Oracle Professional Edition 8.0.17 (Dec 20, 2013)

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

New in dotConnect for Oracle Professional Edition 7.9.333 (Sep 26, 2013)

New in dotConnect for Oracle Professional Edition 7.9.322 (Sep 17, 2013)

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

New in dotConnect for Oracle Professional Edition 7.8.301 (Aug 10, 2013)

New in dotConnect for Oracle Professional Edition 7.8.287 (Jul 22, 2013)

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

New in dotConnect for Oracle Professional Edition 7.7.276 (Jul 22, 2013)

New in dotConnect for Oracle Professional Edition 7.7.267 (Jun 22, 2013)

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

New in dotConnect for Oracle Professional Edition 7.7.257 (Jun 11, 2013)

New in dotConnect for Oracle Professional Edition 7.7.252 (Jun 11, 2013)

New in dotConnect for Oracle Professional Edition 7.7.242 (Jun 11, 2013)

New in dotConnect for Oracle Professional Edition 7.7.226 (Jun 11, 2013)

New in dotConnect for Oracle Professional Edition 7.7.224 (Apr 18, 2013)

New in dotConnect for Oracle Professional Edition 7.7.217 (Apr 18, 2013)

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

New in dotConnect for Oracle Professional Edition 7.6.202 (Mar 14, 2013)

New in dotConnect for Oracle Professional Edition 7.6.192 (Feb 28, 2013)

New in dotConnect for Oracle Professional Edition 7.5.179 (Feb 7, 2013)

New in dotConnect for Oracle Professional Edition 7.5.164 (Jan 18, 2013)

New in dotConnect for Oracle Professional Edition 7.4.146 (Dec 20, 2012)

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
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 innapropriate 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)

New in dotConnect for Oracle Professional Edition 7.3.132 (Nov 29, 2012)

New in dotConnect for Oracle Professional Edition 7.2.122 (Nov 15, 2012)

New in dotConnect for Oracle Professional Edition 7.2.114 (Nov 5, 2012)

New in dotConnect for Oracle Professional Edition 7.2.104 (Oct 18, 2012)

New in dotConnect for Oracle Professional Edition 7.2.96 (Oct 4, 2012)

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

New in dotConnect for Oracle Professional Edition 7.2.77 (Sep 10, 2012)

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

New in dotConnect for Oracle Professional Edition 7.1.58 (Aug 9, 2012)

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

New in dotConnect for Oracle Professional Edition 7.1.40 (Jul 18, 2012)

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

New in dotConnect for Oracle Professional Edition 7.0.25 (Jun 21, 2012)

New in dotConnect for Oracle Professional Edition 7.0.17 (Jun 8, 2012)

New in dotConnect for Oracle Professional Edition 7.0.6 (Jun 8, 2012)

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

New in dotConnect for Oracle Professional Edition 6.80.350 (Apr 30, 2012)

New in dotConnect for Oracle Professional Edition 6.80.341 (Apr 12, 2012)

New in dotConnect for Oracle Professional Edition 6.80.332 (Mar 29, 2012)

New in dotConnect for Oracle Professional Edition 6.80.325 (Mar 15, 2012)

New in dotConnect for Oracle Professional Edition 6.70.311 (Feb 27, 2012)

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

New in dotConnect for Oracle Professional Edition 6.70.302 (Feb 10, 2012)

New in dotConnect for Oracle Professional Edition 6.70.293 (Jan 27, 2012)

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

New in dotConnect for Oracle Professional Edition 6.60.283 (Jan 13, 2012)

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

New in dotConnect for Oracle Professional Edition 6.60.268 (Dec 22, 2011)

New in dotConnect for Oracle Professional Edition 6.50.258 (Dec 8, 2011)

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

New in dotConnect for Oracle Professional Edition 6.50.250 (Nov 24, 2011)

New in dotConnect for Oracle Professional Edition 6.50.244 (Nov 11, 2011)

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

New in dotConnect for Oracle Professional Edition 6.50.237 (Oct 20, 2011)

Devart.Data.Oracle.DurableInstancing assembly and namespace were 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 saved in the application configuration file is implemented
The bug with saving the IsFlags property of enum types in Entity Framework models is fixed
The code generation is improved to distinguish DATE from TIMESTAMP when using database independent fluent mapping
The bug with duplicating the IsComposable attribute in CSDL 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

New in dotConnect for Oracle Professional Edition 6.50.228 (Sep 29, 2011)

New in dotConnect for Oracle Professional Edition 6.50.214 (Sep 6, 2011)

The 'OraMts' connection string parameter for distributed transactions support through OraMTS is added
Query based notification for OracleDependency is implemented
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
Support for spatial data-types for Geography and Geometry in Entity Framework June 2011 CTP models is added
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

New in dotConnect for Oracle Professional Edition 6.30.202 (Aug 16, 2011)

New in dotConnect for Oracle Professional Edition 6.30.196 (Jul 28, 2011)

New in dotConnect for Oracle Professional Edition 6.30.185 (Jul 12, 2011)

New in dotConnect for Oracle Professional Edition 6.30.172 (Jun 16, 2011)

New in dotConnect for Oracle Professional Edition 6.30.165 (Jun 2, 2011)

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

New in dotConnect for Oracle Professional Edition 6.30.160 (May 20, 2011)

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

New in dotConnect for Oracle Professional Edition 6.10.141 (Apr 19, 2011)

New in dotConnect for Oracle Professional Edition 6.10.135 (Apr 6, 2011)

New in dotConnect for Oracle Professional Edition 6.10.126 (Mar 25, 2011)

New in dotConnect for Oracle Professional Edition 6.10.121 (Mar 12, 2011)

New in dotConnect for Oracle Professional Edition 6.10.111 (Feb 24, 2011)

New in dotConnect for Oracle Professional Edition 6.10.103 (Feb 15, 2011)

New in dotConnect for Oracle Professional Edition 6.10.96 (Feb 3, 2011)

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

New in dotConnect for Oracle Professional Edition 6.00.86 (Jan 20, 2011)

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

New in dotConnect for Oracle Professional Edition 6.00.70 (Jan 20, 2011)

New in dotConnect for Oracle Professional Edition 6.00.69 (Jan 20, 2011)

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 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

New in dotConnect for Oracle Professional Edition 6.00.58 (Jan 20, 2011)

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

New in dotConnect for Oracle Professional Edition 5.70.190 (Jan 20, 2011)

New in dotConnect for Oracle Professional Edition 5.70.180 (Jan 20, 2011)

New in dotConnect for Oracle Professional Edition 5.70.170 (Jan 20, 2011)

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

New in dotConnect for Oracle Professional Edition 5.70.152 (Jan 20, 2011)

New in dotConnect for Oracle Professional Edition 5.70.146 (Jan 20, 2011)

New in dotConnect for Oracle Professional Edition 5.70.140 (Jan 20, 2011)

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

New in dotConnect for Oracle Professional Edition 5.35.79 (Jan 14, 2010)

New in dotConnect for Oracle Professional Edition 5.35.62 (Dec 19, 2009)

New in dotConnect for Oracle Professional Edition 5.35.57 (Dec 7, 2009)

New in dotConnect for Oracle Professional Edition 5.35.54 (Nov 24, 2009)

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