Watch, Follow, &
Connect with Us

For forums, blogs and more please visit our
Developer Tools Community.

Welcome, Guest
Guest Settings

Thread: ADO.Net VCL for Delphi v4.0.0.0 released

Permlink Replies: 0 Threads: [ Previous | Next ]
Bismark Appah

Posts: 26
Registered: 3/13/15
ADO.Net VCL for Delphi v4.0.0.0 released
Click to report abuse...   Click to reply to this thread Reply
  Posted: Dec 28, 2017 4:42 PM
The CrystalNet Technologies LTD company has released a new version of the ADO.Net VCL for Delphi at

ADO.Net VCL for Delphi is the fastest and most reliable database connectivity solutions for any database using ADO.Net technology in Delphi. It provides data access to data sources such as SQL Server, Oracle and to data sources exposed through OLE DB and ODBC using ADO.Net data provider framework. ADO.Net VCL for Delphi is an enterprise solution with highest performance and unlimited possibilities. Data-sharing consumer applications can use ADO.NET VCL for Delphi to connect to these data sources and retrieve, handle, and update the data that they contain.

With its powerful common architecture base on ADO.Net technology, ADO.Net VCL for Delphi enables high-speed direct data access from Delphi to SQL Server, Oracle and other data sources exposed through OLE DB and ODBC.

The ADO.Net VCL for Delphi consists of the following library of Data Access components:
- SqlClient Data Access Components
- OracleClient Data Access Components
- ODBC Data Access Components
- OLE DB Data Access Components
- Virtual Table Components

NB: Direct Data Access components for the following data sources will be available in future: MySQL, Firebird, SQLite, BD2, Informix etc. However, you can still connect to these data sources using ODBC Data Access Components or OLE DB Data Access Components provided ODBC drivers or OLE DB providers are installed on the client machine.

- Net Runtime Library for Delphi (Enterprise Edition)

Supported Target Platforms
- Windows, 32-bit and 64-bit


General usability
- Direct access to server data without using client library. Does not require installation of other data provider layers (such as BDE)
- Interface compatible with standard data access methods, such as ADO
- Bulk copying of data from a data source to Sql server database using TSqlClientBulkCopy component
- Supports the posting of deferred updates, so called Cached Updates.
- Provides methods to sort the records. The dataset sorting allows you to get the required records order without requiring a database
- Provides methods to filter the records. The dataset filtering allows you to get record subsets based on a condition
- Provides flexible support for master-detail relationships between datasets
- Support prefetching rows - specifies the number of rows that are to be fetched per server round trip This is controlled by FetchOptions.RowsetSize property
- Unicode support
- Easy to deploy

Network and connectivity
- Disconnected mode with automatic connection control for working with data offline
- Transmission is via XML format, therefore can pass through firewalls

- Full support of the latest server versions
- Compatible with Code Gear RAD Studio 2009, Embarcadero RAD Studio 2010, XE, XE2, XE3, XE4, XE5, XE6, XE7, XE8, Seattle, Berlin, Tokyo
- Support for all standard and third-party visual data-aware controls

- High performance access to the data source
- Fast controlled fetch of large data blocks
- Advanced connection pooling
- High performance of applying cached updates with batches
- Fast locate in a sorted DataSet
- High performance batch processing
- Intelligent fetch block size control
- Rowset fetching support using TDbRecordSet Class which mimics the behaviour of ADO RecordSet Object using ADO.Net technology
- ADO.NET VCL components uses XML to store and transfer data among applications, which provide fast access of data for desktop and distributed applications

Local data storage operations
- Database-independent data storage with TClrMemtable and TClrDataTable components
- CachedUpdates operation mode which is controlled UpdateMode property
- Local sorting and filtering, including by calculated and lookup fields
- Local master/detail relationship
- Data access and data management automation
- Automatic data updating with Query, Table, and StoredProc components
- Fast-forward data retrieval with DataReader component
- Automatic record refreshing and locking
- Automatic query preparing

Data exchange
- Transferring data from all types of TCustomClrDataSet descendants, Xml etc to a Sql Server database using TSqlClientBulkCopy component
- Data export and import to/from XML

For more information go to

Edited by: Bismark Appah on Dec 29, 2017 12:53 AM
Helpful Answer (5 pts)
Correct Answer (10 pts)

Server Response from: ETNAJIVE02