Question - What are all components of ADO.Net data provider?
Answer -
Following are the components of ADO.Net Data provider:
- Connection object – Represents connection to the Database
- Command object – Used to execute stored procedure and command on Database
- ExecuteNonQuery – Executes command but doesn’t return any value
- ExecuteScalar – Executes and returns single value
- ExecuteReader – Executes and returns result set
- DataReader – Forward and read only recordset
- DataAdapter – This acts as a bridge between database and a dataset.