C# Developeramp;#039;s Guide to ASP.NET, XML, and ADO.NET [Electronic resources]

ADO.NET Framework Reference

This section contains a brief reference to the ADO.NET objects mentioned in this chapter. It is not designed to be an exhaustive reference. For complete descriptions, including information on the objects not discussed in this chapter, refer to the .NET framework SDK documentation.

DataAdapter Class

Member of System.Data.Common. Abstract class. Inherits from System.ComponentModel.Component.

The DataAdapter class serves as the base class for data adapter implementations in the SQL Server, OLE DB (and potentially other) data providers in ADO.NET.

Note that this is not the class you instantiate when you want to access data in ADO.NET; to write data-access code using a data adapter in your applications, use the OleDbDataAdapter, SqlDataAdapter, or other provider-specific data adapter class.

DataSet Class

Member of System.Data. Inherits from System.ComponentModel.MarshalByValueComponent.

Note that the DataSet class is not owned by any particular provider; any ADO.NET data provider is capable of creating a DataSet object, and DataSet objects should interoperate across providers.

DataColumn Class

Member of System.Data. Inherits System.ComponentModel.MarshalByValueComponent.

The DataColumn object represents the structure, or schema, of data in a DataTable object. You use the DataColumn object to determine information about the structure of the field (not the data it contains).

This object is contained by the DataSet object and is therefore not provider specific.

DataRelation Class

Member of System.Data.

The DataRelation object is used to denote the relationship between two DataTable objects.

DataTable Class

Member of System.Data.

The DataTable object represents a unit of data arranged as collections of rows and columns. It is contained by the DataSet object and is not provider specific.

OleDbCommand Class

Member of System.Data.OleDb. Inherits from System.Component.Component.

The OleDbCommand object is used to execute commands (including queries and such operations as data manipulation commands) against a data source.

SqlDataAdapter Class

Member of System.Data.SqlClient. Inherits from System.Data.DataAdapter.

The SqlDataAdapter object is used primarily to create DataSet objects in the SQL Servermanaged provider. In thick client context, the data adapter can also be used to provide cursorless navigation, filtering, creation, deletion, and updating of data. The OLE DB equivalent is System.Data.OleDb.OleDbDataAdapter.

SqlDataReader Class

Member of System.Data.SqlClient. Inherits System.MarshalByRefObject.

The SqlDataReader object enables connection-based, fast access to data in the SQL Servermanaged provider. The OLE DB equivalent to this object is System.Data.OleDb.OleDbDataReader.

SqlConnection Class

Member of System.Data.SqlClient.

The SqlConnection object is used to create and maintain a connection to a data source in the SQL Servermanaged provider. Its OLE DB provider equivalent is System.Data.OleDb.OleDbConnection.

SqlError Class

Member of System.Data.SqlClient.

The SqlError object is found in the Errors collection contained by the SqlException object. It is designed to provide SQL Serverspecific error information. Its OLE DB provider equivalent is the OleDbError class.

Note that this object (and the SqlException object that contains it) is available only when you use the SQL Servermanaged provider.

SqlException Class

Member of System.Data.SqlClient. Inherits from System.Exception.

The SqlException object is the object thrown when an error occurs in the ADO.NET SQL Servermanaged provider. This object contains a collection of SqlError objects that you can use to get detailed information on exactly what caused the data-access error.

The equivalent to this class in the OLE DB provider is the OleDbException class.

This object is typically caught in an exception handler rather than constructed.