dotConnect for Oracle History

5.60.102 Beta 04-Mar-10

Supported Visual Studio 2010 Release Candidate
ADO.NET Data Services v1.5 CTP2 supported
Added possibility to avoid connecting to dbMonitor.exe when using DbMonitor ancestors
Fixed bug with parameters on multiple runs of ExecuteArray

LINQ to Oracle

Fixed bug with nullable boolean and null comparison

Entity Developer

Support for ADO.NET Entity Framework 4 Release Candidate added
Improved Find in Model functionality

Entity Framework support

Supported ADO.NET Entity Framework 4 Release Candidate

5.55.97 Beta 17-Feb-10

Fixed bug with licensing in Visual Studio 2010 Beta 2 projects
Fixed bug with exception in License Information window
Fixed bug with OracleDataSource parameters

LINQ to Oracle

Fixed "Cannot access a disposed object" error
Fixed bug with "select new"
Fixed bug with insert of autoincremented values
Fixed bug with Count and IGrouping

Entity Developer

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

Entity Framework support

Fixed bug with EndsWith method

5.55.90 Beta 08-Feb-10

Supported Visual Studio 2010 Beta 2
Install Wizard improved (ability to automatically uninstall previous version added)
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

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 Beta 2 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
Strongly typed reference cursors supported
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 Beta 2
- 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
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