You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 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 if 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.