You use Microsoft Visual Studio 2010 and Microsoft NET Framework 4 to create an application. The
application connects to a Microsoft SQL Server database over the network.
The application uses data from multiple related database tables. You need to ensure that the
application can be used it the connection is disconnected or unavailable. Which object type should
you use to store data from the database tables?
A.
DataSet
B.
DataAdapter
C.
DataReader
D.
Data Services
Explanation:
The DataSet, which is an in-memory cache of data retrieved from a data source, is a major
component of the ADO.NET architecture.
The DataSet consists of a collection of DataTable objects that you can relate to each other with
DataRelation objects.
You can also enforce data integrity in the DataSet by using the UniqueConstraint and
ForeignKeyConstraint objects.