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
- DbDataTable component with connected model abilities and provider-specific features
- Database applications design extensions
- Features specific to database servers
- .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
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
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.