System.Data Namespace

Classes

• DataSet

  ClassRepresents an in-memory cache of data.

• DataTable

  ClassRepresents a collection of rows that support operations such as searching and sorting.

• DataColumn

  ClassRepresents a column in a DataTable.

• DataRow

  ClassRepresents a row of data in a DataTable.

• DataException

  ClassRepresents the exceptions thrown by the .NET Framework data providers.

• SqlConnection

  ClassRepresents a connection to a Microsoft SQL Server database.

• SqlCommand

  ClassRepresents a Transact-SQL statement or procedure to execute against a SQL Server database.

Enums

• SqlDataReaderType

  EnumSpecifies the type of data to return from a query.

• CommandBehavior

  EnumProvides hints to the SqlCommand for how to execute a query.

Interfaces

• IDatabaseCommand

  InterfaceRepresents a command that can be executed against a database.

• IDataAdapter

  InterfaceRepresents a set of data access and manipulation commands for a data source, typically a relational database.