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

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