Database Access in ADO.NET

Database Access in ADO.NET

Data providers:  Set of classes that allows us to
access a particular database, execute commands and
retrieve/update data.

Data providers generally have the following classes
1. Connection   : use to connect
2. Command      : used to execute commands or stored procs
3. DataReader   :Object that provides read only,forward
only access
4. DataAdapter  :Object that is used to populate the
dataset(disconnected tables). Or used to apply changes
to  a database.

There are four providers
1. SQL Server Provider  : Access to sql server
2. OLE DB Provider      :Access to data sources which
provide ole db drivers
3. Oracle provider              : Optimized access to Oracle
database.
4. ODBC provider                :access to an odbc data source.