Home / Products / ADO.NET Data Providers / dotConnect for Oracle / History

dotConnect for Oracle History

This page lists the functionality added in each version of dotConnect for Oracle. To view the full changelog including bug fixes, consult the dotConnect for Oracle revision history.

27-Jan-12 New features in dotConnect for Oracle 6.70

• 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

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

Entity Framework

• Entity Framework 4.3 Beta 1 (Code First Migrations) is supported
• Oracle-specific Code First Migration customizations are implemented

09-Dec-11 New features in dotConnect for Oracle 6.60

• Workflow Tracking support is implemented
• Enabling Persistence for WAS-Hosted Workflow Services that use the WorkflowServiceHost using a Configuration File is supported

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

Entity Framework

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

06-Sep-11 New features in dotConnect for Oracle 6.50

• The 'OraMts' connection string parameter for distributed transactions support through OraMTS is added
• Devart.Data.Oracle.DurableInstancing assembly and namespace were renamed to Devart.Data.Oracle.WorkflowFoundation
• The possibility of choosing connections that are created with Oracle Object Wizard and Oracle Package Wizard is implemented for different project types
• Behaviour is changed: pending operations on a connection are rolled back before returning the connection to pool

LinqConnect (formerly known as LINQ to Oracle)

• Fluent Mapping support is added

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
• Disabling facets that are not applicable to the current field type is implemented (LinqConnect models)
• The possibility of specifying the name of the connection string to be saved in the application configuration file is implemented
• 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 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

Entity Framework

• 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 REGEXP Oracle functions for working with regular expressions are supported
• The code generation is improved to distinguish DATE from TIMESTAMP when using database independent fluent mapping
• Changed behaviour: the CHAR and VARCHAR2 columns are created with the CHAR semantics for EF Code-First CreateDatabase()

17-May-11 New features in dotConnect for Oracle 6.30

• 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
• The OracleConnectMode.SYSASM privilege is supported
• 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 support of events which occur when connections are taken and returned to pool for processing OracleMonitor.TraceEvent is added
• The "Use schema name" check box is added to DataSet Wizard

LinqConnect (formerly known as LINQ to Oracle)

• Eager loading is implemented in case the related entities collection is referenced in the select clause of the query
• IFetch mode customization for eager loading of related entities is implemented
• Performance of ordered queries with the Skip() and Take() methods is improved: the 'rownum' pseudo-column is now used instead of the 'row_number' function
• The 'IsReference' mode of entity serialization is supported

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
• 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 Entity Key handling for Views in Update From Database Wizard in Entity Framework models is improved
• The pluralization algorithm is improved when Naming rules are defined
• Runtime support for literals specified in the 'Default Value' entity field property for LinqConnect models is implemented
• The "Preserve schema name in storage" option is added
• Behaviour is changed: string entity fields are now mapped to varchar2(4000) by default

Entity Framework

• Entity Framework 4.2 June 2011 CTP is supported
• Batch Updates support is added
• Adjustable SQL Formatting for DML commands is added
• Ability to configure the NULL values inserting behaviour is added
• 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
• 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
• 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

27-Jan-11 New features in dotConnect for Oracle 6.10

• Supported Visual Studio 2010 Service Pack 1
• Added DDEX support in Express Edition
• Supported SQL Server Reporting Services x64
• Supported Oracle Database Resident Connection Pooling (DRCP)
• Added 'Connection Class' connection string parameter and OracleConnectionStringBuilder.ConnectionClass property for DRCP support
• Improved public interface of OracleNumberMappingCollection class
• 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
• Implemented generation of UDT method wrappers in the Oracle Object wizard
• 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
• Changed behaviour: OracleDbType.VarChar parameter's max size is increased from 4000 to 32767 symbols

LinqConnect (formerly known as LINQ to Oracle)

• Implemented the Attach(object entity, object original) method of the Devart.Data.Linq.ITable interface
• Implemented implicit sorting by the entity key in queries with defined LoadWith rules

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
• 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: when adding two related entities with the corresponding properties having different types, an invalid association is created now

Entity Framework

• Entity Framework 4.1 RTW supported
• 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
• Improved performance for Visual Studio LightSwitch Beta 1 integration
• Microsoft Generate Database from Model Wizard: Changed Date type to Timestamp type for DateTime properties
• Improved Skip/Take performance
• Improved performance by removing the unnecessary CAST statements

29-Nov-10 New features in dotConnect for Oracle 6.00

• 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
• 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
• Changed behaviour: when clearing the pool, the number of connections specified in 'Min Pool Size' is never removed

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
• Implemented support for custom type arguments in LinqConnect compiled queries

Entity Developer

• Update To Database with Storage Synchronization functionality added
• Added possibility for changing the UpdateCheck property for several fields at once
• Added Update Model From Database functionality
• Added multiselect support for properties
• Improved large models handling

Entity Framework

• 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

20-May-10 New features in dotConnect for Oracle 5.70

• Supported password salt in ASP.NET membership provider
• Implemented capability of extending base functionality of ASP.NET providers
• Added ClientId connection parameter
• Improved Upgrade wizard
• Added support for Enterprise Library 5
• 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
• Implemented additional constructors for OracleParameter class
• Implemented explicit disposing of OracleCommands used in the Enqueue/Dequeue methods of the OracleQueue components
• 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
• Changed the primary key of the aspnet_sessions table for ASP.NET Web providers (the ApplicationName column added)
• Added functionality for setting size of packets sent on command execution
• Changed generation of overloaded procedures names in Oracle Package Wizard
• Changed default behaviour of OracleTransaction without explicit Commit/Rollback call (RollBack now)

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
• Changed DataContext.Log output format for Microsoft compatibility reasons
• Improved transaction behaviour in case when exception is thrown
• DataContext class is now CLS-Compilant
• Changed behaviour: Substring() in LINQ queries is now translated to DBMS_LOB.SUBSTR for LOBs
• Added the client NLS settings support in the TO_NUMBER function
• Added implementation of the ITable interface for the Table class

Entity Developer

• Added possibility of renaming associations in the model
• Improved code generation for procedures returning several cursors
• Added default bindings to entity fields in Insert(Update/Delete) MethodMappings

Entity Framework

• 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
• Added implementation for the DatabaseExists method
• Improved select performance in case of specific double values

15-Apr-10 New features in dotConnect for Oracle 5.60

• Supported Visual Studio 2010
• 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

LINQ to Oracle

• Added support for specific dynamic expressions

Entity Framework

• Supported ADO.NET Entity Framework 4
• 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)

Entity Developer

• Support for ADO.NET Entity Framework 4 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
• Improved Find in Model functionality
• Strongly typed reference cursors supported
• Improved One-To-One associations handling

20-Nov-09 New features in dotConnect for Oracle 5.35

• 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

LINQ to Oracle

• Devart DbLinqDataSource added
• Linq performance improved
• Supported navigation using properties (not only keys)

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

14-Jul-09 New features in dotConnect for Oracle 5.25

• Visual Studio 2010 Beta supported
• ASP.NET Web Providers: Added requiresUniqueEmail functionality
• Performance improvements in Direct mode when executing DML commands

LINQ to Oracle

• Added support of the String.IsNullOrEmpty() method

Entity Developer 2.20

• 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

28-Apr-09 New features in dotConnect for Oracle 5.20

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

Entity Developer 2.00

• 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

13-Nov-08 New features in dotConnect for Oracle 5.00

• 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
• Renamed assemblies, namespaces, and classes (for information on upgrading your projects please refer to FAQ, section Subscriptions and Upgrades)

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

20-Aug-08 New features in OraDirect .NET 4.75

• Supported .NET Framework 3.5 Service Pack 1
• Supported Visual Studio 2008 Service Pack 1

29-May-08 New features in OraDirect .NET 4.70

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

23-Apr-08 New features in OraDirect .NET 4.60

• Supported Visual Studio designers for Entity Framework
• Improved Entity Framework run time support

26-Feb-08 New features in OraDirect .NET 4.50

• Oracle ANYDATA type supported
• Added DB server-based data paging for web applications
• OracleDataSource design time improvements
• ASP.NET demo pack added
• OracleSelectStatement.TryParse method added
• OracleXml class changed
• DataLink.DataSource property can refer to another DataLink component

20-Dec-07 New features in OraDirect .NET 4.35

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

19-Nov-07 New features in OraDirect .NET 4.30

• Oracle version 11g supported

25-Oct-07 New features in OraDirect .NET 4.25

• .NET Entity Framework Beta 2 supported
• Visual Studio 2008 Beta 2 supported
• Added Visual Basic versions to CRM, WinForms, and Web samples

30-Aug-07 New features in OraDirect .NET 4.20

• 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

03-May-07 New features in OraDirect .NET 4.00

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 OraDirect .NET information to Visual Studio 2005 splash screen and About box
• Base level classes moved to the new assembly CoreLab.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

12-Dec-06 New features in OraDirect .NET 3.55

• Windows Vista support added

17-Apr-06 New features in OraDirect .NET 3.50

• Implemented advanced integration with Visual Studio 2005, including Server Explorer, Data Source wizard, TableAdapter configuration, Query Builder and configuring web component SqlDataSource
• Mono support added
• ASP.NET 2.0 providers added: Membership Provider, Profile Provider, Role Provider, Session State Provider
• Capability to call OraDirect .NET runtime assemblies by partially trusted code added
• DataSet Wizard added
• Enterprise Library Data Access Application Block support added
• Added streaming support for OracleScript
• OraDeveloper Tools installation separated from OraDirect .NET installation
• Four digits of OracleConnection.Client version is returning
• Licensing for applications that call OraDirect .NET through DbProviderFactory added.
• This allows to use OraDirect .NET in SQL Server 2005 Business Intelligence Solutions

28-Dec-05 New features in OraDirect .NET 3.20

• Supported .NET Framework 2.0 release version
• Supported Visual Studio 2005 release version
• Compact .NET Framework 2.0 supported
• Performance improved in working with Oracle Object types
• Sample projects for OraDirect .NET Mobile added

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

11-Jul-05 New features in OraDirect .NET 3.01

• OracleCommandBuilder.UpdatingFields property added
• OracleLoader now inherits from DbLoader class

03-Jun-05 New features in OraDirect .NET 3.00

• 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

06-Jan-05 New features in OraDirect .NET 2.50

• Support for .NET Framework 2.0 added
• Support for Microsoft Visual Studio .NET 2005 Beta 1
• 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
• Support for Borland Delphi 2005
• Documentation enriched

21-Jul-04 New features in OraDirect .NET 2.40

• 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

30-Apr-04 New features in OraDirect .NET 2.30

• 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

11-Feb-04 New features in OraDirect .NET 2.01

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

02-Oct-03 New features in OraDirect .NET 2.00

• 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
• OraDirect .NET help integrated into Visual Studio .NET
• XML documentation for code completion added
• Migration wizard from MS OracleClient and ODP.NET
• Typed Oracle package wizard
• New sample applications added

24-Jun-03 New features in OraDirect .NET 1.55

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

11-Feb-03 New features in OraDirect .NET 1.50

• New component OracleScript added. Servers 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 OraDirect .NET. 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 OraDirect .NET
• BlobPictures, Loader, Pictures, StoredProc samples added
• Visual Basic .NET samples added

17-Jul-02 New features in OraDirect .NET 1.20

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

13-Jun-02 New features in OraDirect .NET 1.12

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

15-May-02 New features in OraDirect .NET 1.10

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

09-Apr-02 First release of OraDirect .NET 1.00