ADO.NET DATABase Classes

Data Provider Components

Each .NET data provider consists of four main components:

   Connection – used to connect to the data source

   Command– used to execute a command against the data source and retrieve a DataReader or DataSet, or to execute an              INSERT, UPDATE, or DELETE command against the data source

  DataReader–A  forward-only, read-only connected resultset

   DataAdapter – used to populate a DataSet with data from the data source, and to update the data Source