ADO.Net

• ADO.Net is an acronym for ActiveX Data Object in dot Net. ADO.Net is a specification for interacting with any database or XML documentation.
  
• ADO.Net is of two types:
  

1. Disconnected model:
   
   

   If we use ADO.Net disconnected model for interacting with any database, connection is not required while performing any navigations or manipulation on the data.
   

2. Connection Oriented model:
   
   

   If we use ADO.Net connection oriented model for interacting with any database, connectivity between the application and the data base has to be maintain till end of the application