ADO.Net DAC for Delphi

ADO.Net DAC 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, SQLite, VistaDB and to data sources exposed through OLE DB and ODBC using ADO.Net data provider framework. ADO.Net DAC for Delphi is an enterprise solution with highest performance and unlimited possibilities. Data-sharing consumer applications can use ADO.NET DAC for Delphi to connect to these data sources and retrieve, handle, and update the data that they contain.

Download

 Latest: 4.0.5.0 - What's New

adoNetDAC4Delphi

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

ADO.Net DAC for Delphi provides a library of components for connecting to a database, executing commands, and retrieving results. Those results are either processed directly, placed in a Virtual Table components. The Virtual Table component can also be used independently of any active connection to manage data local to the application or sourced from XML.

You have the choice of either using client-side or server-side cursors. The ADO.Net DAC for Delphi actually handle the work of cursors. The developer has the freedom of choice in development, for creating efficient applications.

Components of ADO.Net DAC for Delphi

Features

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.
  • Provides methods to sort the records. The dataset sorting allows you to get the required records order without requiring a database.
  • Supports the posting of deferred updates, so called Cached Updates.
  • 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

Performance

  • 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 controlled by UpdateOptions.UpdateBatchSize property.
  • 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 DAC components uses XML to store and transfer data among applications, which provide fast access of data for desktop and distributed applications.
  • All our components and libraries are designed to help you write high-performance, lightweight data access layers, therefore they use ado.net data access technologies and techniques of optimization.
  • DataReader is used to read the data from database and it is a read and forward only connection oriented architecture when fetching data from database. DataReader will fetch the data very fast when compared to other TCustomClrDataSet descendants.
  • DataAdapter acts as a Bridge between TCustomClrDataSet descendants and database. This dataadapter object is used to read the data from database and bind that data to TCustomClrDataSet descendants. It is a disconnected oriented architecture.

Local data storage operations

  • Database-independent data storage with TClrMemTable and TClrDataTable components
  • CachedUpdates operation mode controlled UpdateOptions.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

Handling Cursors

  • When a SQL command is executed and it has to return rows, the DBMS creates a cursor on the DBMS server. An application uses the cursor to retrieve rows from a database. There are serveral cursor kinds to choose from using the FetchOptions.CursorKind property.


Supported Platforms

Delphi

IDE Compatibility

Delphi
  • Embarcadero Delphi 10.3 Rio
  • Embarcadero Delphi 10.2 Tokyo
  • Embarcadero Delphi 10.1 Berlin
  • Embarcadero Delphi 10.0 Seattle
  • Embarcadero Delphi XE8
  • Embarcadero Delphi XE7
  • Embarcadero Delphi XE6
  • Embarcadero Delphi XE5
  • Embarcadero Delphi XE4
  • Embarcadero Delphi XE3
  • Embarcadero Delphi XE2
  • Embarcadero Delphi XE

Server

Supported Database Server

.NET
Database

Oracle - OracleClientDAC

Servers: 12c, 11g, 10g, 9i, 8i, 8.0, including Oracle Express Edition 11g and 10g
Clients: 12c, 11g, 10g, 9i, 8i, 8.0


Microsoft SQL Server - SqlClientDAC

Servers: SQL Server 2019, 2017, 2016, 2014, 2012, 2008 R2, 2008, 2005 (including Express edition),
SQL Server 2000 (including MSDE), SQL Server 7 Clients: SQL OLE DB and SQL Native Client


SQLite - SQLiteDAC

Database file with any of the following extensions: .db3, .s3db, .sqlite3, .sl3, .db2, .s2db, .sqlite2, .sl2, .db, .sdb, .sqlite, .sl


Any database using OBDC driver - ODBCDAC

Microsoft-Supplied ODBC Drivers:
  • Microsoft Access Drivers
    • Microsoft Access Driver (*.mdb, *.accdb)
    • Microsoft Access Driver (*.mdb)
  • Microsoft Excel Drivers
    • Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)
    • Microsoft Excel Driver (*.xls)
  • Paradox Drivers
    • Microsoft Paradox Driver (*.db)
  • Dbase Drivers
    • Microsoft dBase Driver (*.dbf)
  • Text Files
    • Microsoft Text Driver (*.txt; *.csv)
  • ODBC Driver for Oracle
    • Microsoft ODBC for Oracle
  • Microsoft SQL Server
    • SQL Server Native Client 11.0
    • SQL Server Native Client 10.0
    • SQL Native Client
    • ODBC Driver 11 for SQL Server
    • SQL Server

Any database using OLE DB provider - OLEDBDAC

Microsoft-Supplied OLE DB Providers:

Any VistaDB Database

OS

Supported Platforms

OS
  • Windows OS 32-bit.
  • Windows OS 64-bit

Included Demos

These demos are installed with the product. Download the FREE trial to get started.

Download Free Trial


30-Day Fully-Functional Free Trial

Get started today and see why developers worldwide
choose CrystalNet ADO.Net DAC for Delphi.

 Download

Order Online


Starting at $114.99

Provides a cost-effective solution for developers to access any database connectivity using ADO.Net technology from Delphi.

 Order