dotConnect for Oracle History

6.70.293 27-Jan-12

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

LinqConnect (formerly known as LINQ to Oracle)

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

Entity Developer

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

Entity Framework support

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

6.60.283 12-Jan-12

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

Entity Developer

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

Entity Framework support

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

6.60.268 22-Dec-11

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

Entity Developer

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

Entity Framework support

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

6.60.258 08-Dec-11

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

LinqConnect (formerly known as LINQ to Oracle)

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

Entity Developer

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

Entity Framework support

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

6.50.250 24-Nov-11

Query based notification for OracleDependency is implemented

Entity Developer

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

Entity Framework support

The size of generated SQL is reduced by excluding redundant aliases

6.50.244 11-Nov-11

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

LinqConnect (formerly known as LINQ to Oracle)

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

Entity Developer

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

Entity Framework support

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

6.50.237 19-Oct-11

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

LinqConnect (formerly known as LINQ to Oracle)

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

Entity Developer

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

Entity Framework support

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

6.50.228 29-Sep-11

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

LinqConnect (formerly known as LINQ to Oracle)

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

Entity Developer

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

Entity Framework support

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

6.50.214 06-Sep-11

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

LinqConnect (formerly known as LINQ to Oracle)

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

Entity Developer

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

Entity Framework support

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

6.30.202 11-Aug-11

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

LinqConnect (formerly known as LINQ to Oracle)

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

Entity Developer

The pluralization algorithm is improved when Naming rules are defined

6.30.196 28-Jul-11

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

LinqConnect (formerly known as LINQ to Oracle)

The bug with columns named as Oracle keywords is fixed

Entity Developer

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

Entity Framework support

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

6.30.185 07-Jul-11

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

LinqConnect (formerly known as LINQ to Oracle)

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

Entity Developer

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

Entity Framework support

Entity Framework 4.2 June 2011 CTP is supported

6.30.172 15-Jun-11

LinqConnect (formerly known as LINQ to Oracle)

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

Entity Developer

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

Entity Framework support

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

6.30.165 01-Jun-11

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

LinqConnect (formerly known as LINQ to Oracle)

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

Entity Developer

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

Entity Framework support

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

6.30.160 17-May-11

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

LinqConnect (formerly known as LINQ to Oracle)

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

Entity Developer

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

Entity Framework support

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

6.10.141 19-Apr-11

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

LinqConnect (formerly known as LINQ to Oracle)

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

Entity Framework support

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

6.10.135 06-Apr-11

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

LinqConnect (formerly known as LINQ to Oracle)

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

Entity Developer

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

Entity Framework support

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

6.10.126 23-Mar-11

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

LinqConnect (formerly known as LINQ to Oracle)

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

Entity Developer

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

Entity Framework support

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

6.10.121 11-Mar-11

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

LinqConnect (formerly known as LINQ to Oracle)

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

Entity Developer

Fixed bug with discarding changes in Navigation Properties names

Entity Framework support

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

6.10.111 24-Feb-11

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

LinqConnect (formerly known as LINQ to Oracle)

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

Entity Developer

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

Entity Framework support

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

6.10.103 09-Feb-11

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

LinqConnect (formerly known as LINQ to Oracle)

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

Entity Developer

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

6.10.96 27-Jan-11

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

LinqConnect (formerly known as LINQ to Oracle)

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

Entity Developer

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

Entity Framework support

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

6.00.86 12-Jan-11

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

LinqConnect (formerly known as LINQ to Oracle)

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

Entity Developer

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

Entity Framework support

Added support for Entity Framework CTP 5
Improved DatabaseExists functionality

6.00.70 23-Dec-10

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

6.00.69 16-Dec-10

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

LinqConnect (formerly known as LINQ to Oracle)

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

Entity Developer

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

Entity Framework support

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

6.00.58 29-Nov-10

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

LinqConnect (formerly known as LINQ to Oracle)

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

Entity Developer

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

5.70.190 04-Nov-10

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

LinqConnect (formerly known as LINQ to Oracle)

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

Entity Developer

Fixed bug with associations adding

Entity Framework support

Model First support improved

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

5.70.180 14-Oct-10

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

LinqConnect (formerly known as LINQ to Oracle)

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

Entity Developer

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

Entity Framework support

Added implementation for the DatabaseExists method

5.70.170 23-Sep-10

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

LinqConnect (formerly known as LINQ to Oracle)

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

Entity Developer

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

Entity Framework support

Fixed bug with the Guid output parameter

5.70.152 28-Jul-10

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

LinqConnect (formerly known as LINQ to Oracle)

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

Entity Developer

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

Entity Framework support

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

5.70.146 07-Jul-10

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

LinqConnect (formerly known as LINQ to Oracle)

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

Entity Developer

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

Entity Framework support

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

5.70.140 20-May-10

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

LinqConnect (formerly known as LINQ to Oracle)

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

Entity Developer

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

Entity Framework support

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

5.60.124 15-Apr-10

Supported Visual Studio 2010

Entity Developer

Support for ADO.NET Entity Framework 4 added

Entity Framework support

Supported ADO.NET Entity Framework 4

5.60.120 31-Mar-10

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

LINQ to Oracle

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

Entity Developer

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

Entity Framework support

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

5.35.79 14-Jan-10

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

LINQ to Oracle

Fixed the "Destabilize the runtime" problem

Entity Developer

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

Entity Framework support

Fixed bug with EntitySQL BigCount function

5.35.62 16-Dec-09

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

LINQ to Oracle

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

Entity Developer

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

Entity Framework support

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

5.35.57 02-Dec-09

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

Entity Developer

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

Entity Framework support

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

5.35.54 19-Nov-09

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

LINQ to Oracle

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

Entity Developer

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

Entity Framework support

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

5.25.49 19-Oct-09

Added SchemaTable property to DbDataTable
Added Enlist parameter to connection string

LINQ to Oracle

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

Entity Developer

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

5.25.44 24-Sep-09

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

LINQ to Oracle

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

Entity Developer

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

Entity Framework support

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

5.25.42 04-Sep-09

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

LINQ to Oracle

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

Entity Developer

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

5.25.39 06-Aug-09

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

Entity Developer

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

Entity Framework support

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

5.25.37 14-Jul-09

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

LINQ to Oracle

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

Entity Developer

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

Entity Framework support

Fixed bug with ProviderManifestToken

5.20.33 21-May-09

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

LINQ to Oracle

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

Entity Developer

Fixed some code generation bugs

Entity Framework support

Fixed bug with functions from packages

5.20.29 28-Apr-09

LINQ to Oracle

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

Entity Developer

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

5.00.26 02-Apr-09

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

5.00.22 16-Feb-09

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

LINQ to Oracle

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

5.00.20 14-Jan-09

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

Entity Framework support

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

LINQ to Oracle

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

5.00.16 05-Dec-08

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

Entity Framework support

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

5.00.12 13-Nov-08

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

Entity Framework support

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

4.75.44 27-Oct-08

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

4.75.43 26-Sep-08

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

Entity Framework support

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

4.75.42 09-Sep-08

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

Entity Framework support

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

4.75.41 29-Aug-08

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

4.75.40 27-Aug-08

Entity Framework support

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

4.75.39 20-Aug-08

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

Entity Framework support

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

4.70.38 21-Jul-08

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

Entity Framework support

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

4.70.37 25-Jun-08

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

Entity Framework support

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

4.70.36 04-Jun-08

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

4.70.35 29-May-08

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

4.60.34 19-May-08

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

4.60.33 23-Apr-08

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

4.50.32 04-Apr-08

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

4.50.31 19-Mar-08

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

4.50.30 26-Feb-08

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

4.35.29 13-Feb-08

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

4.35.28 18-Jan-08

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

4.35.27 20-Dec-07

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

4.30.26 13-Dec-07

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

4.30.25 19-Nov-07

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

4.25.24 05-Nov-07

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

4.25.23 26-Oct-07

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

4.20.22 18-Sep-07

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

4.20.21 04-Sep-07

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

4.20.20 30-Aug-07

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

4.00.14 30-May-07

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

4.00.13 03-May-07

Application development enhancement

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

.NET 2 features

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

Advanced Oracle features

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

Other features

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

OraDeveloper Tools 2.00 improvements

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

3.55.17 22-Dec-06

Bug with Visual Studio 2005 integration fixed

3.55.16 14-Dec-06

Bug with installation fixed

3.55.15 12-Dec-06

Windows Vista support added

3.50.14 01-Nov-06

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

3.50.13 21-Sep-06

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

3.50.12 23-Aug-06

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

3.50.11 30-May-06

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

3.50.9 17-Apr-06

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

3.20.7 02-Feb-06

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

3.20.6 28-Dec-05

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

OraDeveloper Tools improvements (Professional edition only)

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

3.01.5 28-Oct-05

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

3.01.4 17-Oct-05

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

3.01.3 19-Sep-05

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

3.01.2 29-Jul-05

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

3.01.1 11-Jul-05

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

3.00.0 03-Jun-05

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

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

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

2.50.1 11-May-05

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

2.50.0 06-Jan-05

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

2.40.4 08-Oct-04

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

2.40.3 28-Sep-04

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

2.40.2 17-Aug-04

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

2.40.1 30-Jul-04

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

2.40.0 21-Jul-04

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

2.30.2 18-May-04

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

2.30.1 14-May-04

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

2.30.0 30-Apr-04

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

2.01.1 04-Mar-04

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

2.01 12-Feb-04

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

2.00.7 06-Feb-04

Bug with Oracle objects fixed

2.00.6 22-Jan-04

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

2.00.5 24-Nov-03

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

2.00.4 29-Oct-03

Bug with loading design-time classes was fixed

2.00.3 22-Oct-03

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

2.00.2 10-Oct-03

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

2.00 03-Oct-03

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

1.55 24-Jun-03

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

1.50 11-Feb-03

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

1.20 17-Jul-02

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

1.12 13-Jun-02

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

1.10 15-May-02

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

OracleCommand editor form

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

1.00 09-Apr-02

First release of dotConnect for Oracle 1.00