Ado and Ado.Net In .NET

It is data model which is used by .net application for doing data manipulation with database.Ado means Active Data Object.Before the Ado.Net there was 'Ado' used for connectivity and data manipulation with database.But There are some difference b/w Ado and Ado.Net:-

  • 'Ado'supports only connected architecture but Ado.Net support connected as well as disconnected architecture.
  • In 'Ado'we can not create constraint but in Ado.Net we can easily create constraints.
Connected Architecture:-

In connected architecture Application directly communicate with database so we need to 'OPEN' and 'CLOSE' the connection manually.
This diagram is helpful for understanding the connected architecture:-

Disconnected Architecture:-

In disconnected Architecture Application does not communicate with database but with Data Set, so to 'OPEN' and  'CLOSE' the connection  Data Adapter is responsible.We don't need it to manually.

This diagram is helpful for understanding the Disconnected architecture:-


  1. well explained.

  2. Thanks for your informative article and the blog. Your article is very useful for .net professionals and freshers looking for interview. Best DOT NET Training | Dot Net course Chennai

  3. The expansion of internet and other business intelligence leads to large volume of data. Industries are looking for talented professionals to maintain and process huge volume of data with latest tools available in the market. Taking Hadoop Training in Chennai | Big Data Training in Chennai will ensure better career prospects for talented professionals.


Powered by Blogger.