ADO.NET connects both front end and backend. It interacts with both displaying of data and hiding details of the movement of data.
DataSet class- The dataset class represents a subset of the database. The dataset contains a data table and data relation object.
Properties of DataSet Class
- CaseSensitive – Indicates string comparison tables are case sensitive or not
- Container – Gets container for the component
- Dataset Name – Gets or sets the name of the current data set
- Design Mode - Indicates whether the component is in design mode
- Events – Gets the list of event handler
- Extended Properties – Gets the collection of customized user information
- Initialized – Indicates if the dataset is initialized
- Locale – Get or sets the locale information used to compare strings
- Namespace – Get or sets the namespace
- Tables – Returns collection of DataTableObject
- Relations – Returns the collection of DataRelationObject
Methods of Data Class
- AcceptChanges
- Clear
- BeginInit
- Clone
- Copy
- CreateDataReader
- EndInit
- Equals
- Finalize
- Get Change
- GetType
- GetXML
DataRow Class- This represents a row in a table.
DataAdapterObject – This acts as a bridge between Dataset object and database.
DataReaderObject- This acts as an alternative to DataSet and DataAdapter combination. This provides connection access to data records.
DbCommand and Db Connection - This object represents a connection to the data source. The connection can be shared among different commands.