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.

Free Trial

 Latest: 4.0.5.1 - 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

SqlClient DAC for Delphi

A feature-rich and high-performance library of components that provides native connectivity to SQL Server from Delphi for both 32-bit and 64-bit Windows platforms. SqlClientDAC-based applications connect to SQL Server directly through the ADO.Net SqlClient, which is a .NET Framework Data Provider for SQL Server. SqlClientDAC aims to assist programmers in developing of fast and native SQL Server database applications.

Learn More >>

OracleClient DAC for Delphi

A feature-rich and high-performance library of components that provides native connectivity to Oracle from Delphi for both 32-bit and 64-bit Windows platforms. OracleClientDAC-based applications connect to Oracle directly through the ADO.Net OracleClient, which is an Oracle Data Provider for .NET (ODP.Net). OracleClientDAC aims to assist programmers in developing of fast and native Oracle database applications.

Learn More >>

SQLite DAC for Delphi

A feature-rich and high-performance library of components that provides native connectivity to SQLite from Delphi for both 32-bit and 64-bit Windows platforms. SQLiteDAC-based DB applications are easy to deploy, do not require installation of other data provider layers (such as BDE or ODBC), and that's why they can work faster than the ones based on standard Delphi data connectivity solutions. SQLiteDAC-based applications connect to SQLite.

Learn More >>

ODBC DAC for Delphi

A feature-rich and high-performance library of components that provides data access for data sources exposed through ODBC from Delphi for both 32-bit and 64-bit Windows platforms. ODBCDAC-based applications connects to any data source exposed through ODBC using the .NET Framework Data Provider for ODBC. ODBCDAC aims to assist programmers in developing of fast and native database applications. ODBCDAC uses the native ODBC Driver Manager (DM) to enable data access.

Learn More >>

OLEDB DAC for Delphi

A feature-rich and high-performance library of components that provides data access for data sources exposed through OLE DB from Delphi for both 32-bit and 64-bit Windows platforms. OLEDBDAC aims to assist programmers in developing of fast and native database applications. OLEDBDAC uses native OLE DB through COM interop to enable data access. OLEDBDAC does not support OLE DB version 2.5 interfaces.

Learn More >>

VistaDB DAC for Delphi

A feature-rich and high-performance library of components that provides native connectivity to VistaDB from Delphi for both 32-bit and 64-bit Windows platforms. VistaDB-based DB applications are easy to deploy, do not require installation of other data provider layers (such as BDE or ODBC), and that's why they can work faster than the ones based on standard Delphi data connectivity solutions.


Learn More >>

Virtual Table Components

A feature-rich and high-performance library of components that provides an in-memory cache of data retrieved from a data source. It offers a disconnected data source architecture which means there is no need of active connections during work with this component. It can be used to hold multiple tables with data. You can select data form tables, create views based on table. The component also provides you with rich features like saving data as XML and loading XML data.

Learn More >>

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 11 Alexandria
  • 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

40+ DELPHI DATA ACCESS COMPONENTS

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 $149.95

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

 Order