What is DataSet in ADO.NET?

1.	What is DataSet in ADO.NET?
Answer» The DATASET is a collection of database tables(row and column format) that contain the data. It is helpful for fetching the data without any need for Data Source interaction, that is why it is called a DISCONNECTED data access method. It is an in-memory data store that can contain multiple tables at the same time. DataRelation objects can be used to RELATE these tables. For creating a DataSet object, ADO.NET provides a DataSet class that consists of constructors and methods to CARRY out data-related operations. It can be used with various data sources, with XML data, or to MANAGE the application’s local data. The DataSet will include related tables, data constraints, and relationships among the tables.

Discussion