ADO.Net Data Access Components (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 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.

The ADO.Net DAC 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.

Pre-requisite: Net Runtime Library for Delphi Enterprise Edition (https://crystalnet-tech.com/RuntimeLibrary/Download.aspx)

Features

  • 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
  • Disconnected mode with automatic connection control for working with data offline
  • Transmission is via XML format, therefore can pass through firewalls
  • 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 DAC components uses XML to store and transfer data among applications, which provide fast access of data for desktop and distributed applications
  • 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
  • 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 export and import to/from XML
  • ..e.t.c

Project Samples

Project Activity

See All Activity >

Categories

Design, Libraries

License

GNU General Public License version 3.0 (GPLv3)

Follow ADO.Net DAC for Delphi

ADO.Net DAC for Delphi Web Site

Other Useful Business Software
Our Free Plans just got better! | Auth0 Icon
Our Free Plans just got better! | Auth0

With up to 25k MAUs and unlimited Okta connections, our Free Plan lets you focus on what you do best—building great apps.

You asked, we delivered! Auth0 is excited to expand our Free and Paid plans to include more options so you can focus on building, deploying, and scaling applications without having to worry about your security. Auth0 now, thank yourself later.
Try free now
Rate This Project
Login To Rate This Project

User Ratings

★★★★★
★★★★
★★★
★★
1
0
0
0
0
ease 1 of 5 2 of 5 3 of 5 4 of 5 5 of 5 5 / 5
features 1 of 5 2 of 5 3 of 5 4 of 5 5 of 5 5 / 5
design 1 of 5 2 of 5 3 of 5 4 of 5 5 of 5 5 / 5
support 1 of 5 2 of 5 3 of 5 4 of 5 5 of 5 5 / 5

User Reviews

  • Wow, this is the component i have long been waiting for. I finally replaced or my ADO components with ADO.Net Components. These components are the best. The components are working fine and fast without errors. I am in love with these components. When will the final build be released?
Read more reviews >

Additional Project Details

Operating Systems

Windows

Intended Audience

Developers, Architects

Programming Language

C#, Delphi/Kylix

Database Environment

XML-based, Oracle, SQLite, SQL-based, Microsoft SQL Server, Microsoft Access, ODBC, ADO.NET

Related Categories

C# Design Software, C# Libraries, Delphi/Kylix Design Software, Delphi/Kylix Libraries

Registered

2014-05-08