ado.net database support
a number of database enhancements were implemented in delphi 2005, particularly in the ado.net technology, but also to bde, dbexpress and the availability of dbgo for ado on .net.
borland data provider enhancements
there are a number of borland data provider for ado.net improvements, including support for interbase boolean fields, oracle packages, localized table name support, schema name list retrieval, and sybase 12.5 support.
this brings the list of certified bdp ado.net data provider drivers to the following: borland interbase 7.5 (should also work but is not certified with interbase 7.1, 7.0 and 6.5), oracle 10g (should also work with oracle 9.2.0 and 9.1.0), ibm db2 udb 8.x (should also work with 7.x), microsoft sql server 2000, microsoft msde 2000, microsoft access 2000, and sybase 12.5.
designer enhancements
there are significant database related ado.net designer enhancements in delphi 2005. there is new stored procedure testing support, where you can specify the stored procedure to test, including the input parameters, and then actually run the stored procedure and view output parameter values (if any).
delphi 2005 stored procedure dialog testing sub_tot_budget
a special table mapping feature helps you to specify the table mapping for a bdpdataadapter, where you can specify the mapping between columns of a datatable and an in-memory dataset with more descriptive column names. you can also add or remove columns for the in-memory dataset.
the object inspector now offers a connection string editor for the sqlconnection component, allowing specifying the connection string for an ado.net provider.
bdp remoting, heterogeneous support
new ado.net components called remoteserver and remoteconnection offer rad support for building multi-tier applications (using .net remoting infrastructure). two other new ado.net components, called datahub and datasync, offer support for aggregating heterogeneous databases into single datasets. the four components can be combined, resulting in distributed applications using multiple different ado.net data providers. in this architecture, the datahub and remoteconnection are part of the thin-client tier, while the remoteserver and datasync components are part of the server tier, connected to the data providers.
