SDAC

Component List

This topic presents a brief description of the components included in the SQL Server Data Access Components library. Click on the name of each component for more information. These components are added to the SDAC page of the Component palette except for TCRBatchMove and TVirtualTable components. TCRBatchMove and TVirtualTable components are added to the Data Access page of the Component palette. Basic SDAC components are included in all SDAC editions. SDAC Professional Edition components are not included in SDAC Standard Edition.

Basic SDAC components

MSConnection TMSConnection Lets you set up and control connections to SQL Server.
MSQuery TMSQuery Uses SQL statements to retrieve data from SQL Server table or tables and supply it to one or more data-aware components through a TDataSource component. Provides flexible update of data.
MSTable TMSTable Lets you retrieve and update data in a single table without writing SQL statements.
MSStoredProc TMSStoredProc Executes stored procedures and functions.
MSSQL TMSSQL Executes SQL statements and stored procedures that do not return rowsets.
MSScript TMSScript Executes sequences of SQL statements.
MSUpdateSQL TMSUpdateSQL Lets you tune update operations for DataSet component.
MSDataSource TMSDataSource Provides an interface between a SDAC dataset components and data-aware controls on a form.
MSUpdateSQL TMSSQLMonitor Interface for monitoring dynamic SQL execution in SDAC-based applications.
MSConnectDialog TMSConnectDialog Is used on client side to supply username, password, database and server name.
MSTableData TMSTableData Is used for working with user-defined table types in SQL Server 2008.
VirtualTable TVirtualTable Dataset that stores data in memory. This component is placed on the Data Access page of the Component palette.
VirtualDataSet TVirtualDataSet Dataset that processes arbitrary non-tabular data.

SDAC Professional Edition components

TMSEncryptor TMSEncryptor Represents data encryption and decryption in client application.
MSLoader TMSLoader Provides quick data loading to SQL Server database.
MSDump TMSDump Serves to store a database or its parts as a script and also to restore database from received script.
MSServiceBroker TMSServiceBroker Lets you send and receive messages using the SQL Server Service Broker system.
MSMetaData TMSMetaData Retrieves embracing metadata on specified SQL object.
MSChangeNotification TMSChangeNotification Lets you react on different server side changes on-the-fly. Based on the Query Notifications mechanism of SQL Server.
MSTransaction TMSTransaction Lets you control distributed transactions via Microsoft Distributed Transaction Coordinator.
MSCompactConnection TMSCompactConnection Lets you set up and control connections to SQL Server Compact Edition.
CRBatchMove TCRBatchMove Transfers data between all types of TDataSets descendants. This component is placed on the Data Access page of the Component palette.
© 1997-2019 Devart. All Rights Reserved. Request Support DAC Forum Provide Feedback