ADO.NET Providers Simplify Data Access

January 09, 2007

Core Lab Software Development has announced the release of beta versions of the next major versions of OraDirect .NET, MySQLDirect .NET, and PostgreSQLDirect .NET. The new generation of ADO.NET data providers contains improvements in 4 development directions:

  1. DbDataTable component with connected model abilities and provider-specific features
  2. Database applications design extensions
  3. Features specific to database servers
  4. .NET Framework 2.0 advanced features

The OracleDataTable, MySqlDataTable and PgSqlDataTable components were greatly enhanced to give a database developer maximum possible flexibility and convenience. Now the components can perform data fetch sequentially and asynchronously, all at once or in paginal mode. Now you can choose whether updates are cached or not, you can establish server side master-detail relation. The components acquire new abilities in handling LOBs and objects in Oracle, as well as many other features.

With this version Core Lab ADO.NET Data Providers become a comprehensive solution for database developer, including more powerful design time features. New tools DataSet Manager, DataSet Editor, and DataSet Generator allow you to customize your datasets in fast and convenient way. New InterForm technology is designed to reference components on different forms in the project, which means centralized customization and ease of use. Together with a new DataLink component, the InterForm technology represents a way to setup data binding with the data source. Using this technology, the DataLink and DbDataTable components bring you live data in the design time of the whole application.

As usual, we continue to enhance support for server-specific features in our ADO.NET providers. In PostgreSQLDirect .NET we added new PgSqlTimeStamp class to represent TIMESTAMP and DATE types. In MySQLDirect .NET we supported DECIMAL, BINARY, and VARBINARY types. And OraDirect .NET was enriched with support of Oracle Advanced Queue technology, as well as three new components - OracleAlerter, OraclePipe, and OracleTrace.

Among the features suggested by .NET Framework 2.0, the new versions supported Dependency, Data Source Enumeration, and Batch Update. The Dependency mechanism is designed to track changes in data on the server. The Data Source Enumeration feature allows you to list servers available in the local network. The Batch Update ability helps to optimize interactions with server. Furthermore, now you can manage provider-specific types, and they are supported even in design time and visual controls.

The Professional Edition of OraDirect .NET is now compatible with OraDeveloper Tools version 2.00, which reveals additional horizons in data management and server administration. For details on what's new in OraDeveloper Tools please refer to this announcement.

There are much more new features in every data provider. For a complete list of new features refer to the history pages of each product. You can download the beta versions from the Downloads page.

If you wish to provide feedback on the new versions, you can do it in our forums or by e-mail. We are always glad to hear your comments and take into account your development needs.