Watch, Follow, &
Connect with Us

Please visit our new home
community.embarcadero.com.


Welcome, Guest
Guest Settings
Help

Thread: SqlClientDAC for Delphi



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

Posts: 26
Registered: 3/13/15
SqlClientDAC for Delphi
Click to report abuse...   Click to reply to this thread Reply
  Posted: Dec 28, 2017 4:52 PM
SqlClient Data Access Components (SqlClientDAC) is 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 is designed to help programmers develop faster and cleaner SQL Server database applications. SqlClientDAC uses its own protocol to communicate with SQL Server. SqlClientDAC is lightweight and performs well because it is optimized to access a SQL Server directly without adding an OLE DB or Open Database Connectivity (ODBC) layer.

SqlClientDAC, a high-performance and feature-rich SQL Server connectivity solution, is a complete replacement for standard SQL Server connectivity solutions and presents an efficient native alternative to the Borland Database Engine (BDE) and standard dbExpress driver for access to SQL Server.

SqlClientDAC-based DB applications are easy to deploy, do not require installation of other data provider layers (such as BDE and ODBC), uses ADO.Net technologies and that's why they can work faster than the ones based on standard Delphi data connectivity solutions.

NB: SqlClientDAC is part of the ADO.Net VCL for Delphi.

Key Features
- Direct access to microsoft sql server data. Does not require installation of other data provider layers (such as BDE)
- Bulk copying of data from a data source to Sql server database using TSqlClientBulkCopy
- Interface compatible with standard data access methods, such as BDE and ADO
- Unicode support
- Easy to deploy
- Connection string support
- Transmission is via XML format, therefore can pass through firewalls
- Provides support for obtaining SQL Server run-time statistics
- Provides database mirroring functionality
- Provides support for snapshot isolation, a row versioning mechanism designed to reduce blocking in transactional applications.
- Provides support for High Availability, Disaster Recovery
- High overall performance
- Fast controlled fetch of large data blocks
- High performance of applying cached updates with batches
- Advanced connection pooling
- High performance batch processing
- Intelligent fetch block size control
- Support prefetching rows - specifies the number of rows that are to be fetched per server round trip. This is controlled by FetchOptions.RowsetSize property
- CachedUpdates operation mode which is controlled UpdateMode property
- Automatic data updating with TSqlClientQuery, TSqlClientTable, and TSqlClientStoredProc components
- Fast data retrieval with TSqlClientDataReader component
- Automatic record refreshing and locking
- Automatic query preparing
- Data export and import to/from XML
- Advanced design-time component and property editors
- The ConnectRetryCount and ConnectRetryInterval connection string keywords (ConnectionString) let you control the idle connection resiliency feature
- and many more

For more information go to https://crystalnet-tech.com/ADONetVcl/SqlClientDAC.aspx
For more information about ADO.Net VCL for Delphi, go to https://crystalnet-tech.com/ADONetVcl/ADODotNet.aspx

Edited by: Bismark Appah on Dec 29, 2017 9:52 AM
Legend
Helpful Answer (5 pts)
Correct Answer (10 pts)

Server Response from: ETNAJIVE02