ADO.NET Provider Objects

ADO.NET Provider objects are the objects defined in each .Net provider.The various provider objects are :

1.Connection Object : The Connection object provides the basic connection to our data source.If we are using a database that requires a username and password details of establishing the connection and logged in.

 

2.Command Object : We use the command object to give a command to a data source,such as select * from tablename 

3.Command Builder Object : The command builder object ia to build SQL commands for data modification from objects based on a single table query

4.Data Reader Object : The Data Reader object a fast simple to use object that reads a forward only read only  stream of a data from a data source

5.Data Adapter Object : Data Adapter object used to exchange a data between from  data source to data set.