Connection, command and data set
The public language running library provides a complete managed data access API set for data-intensive applications. These APIs help abstract data and use data with consistent methods, independent of the actual data source (SQL Server, OLEDB, XML, etc.). The most commonly used objects are basically three: connections, commands, and datasets.
Connection represents a physical connection to some data stores such as SQL Server or XML files. The command represents an instruction to retrieve (selection) or on the data storage area (insert, update, delete). The data set represents the actual data used by the application. Note that the data set is always disconnected from their source connections and data models and can be modified independently. However, changes to the data set can be easily coordinated with the starting data model.