What is the main difference between ADO and ADO.Net
ADO was a connected data access model, which means that when
a connection to the database is made, the connection remains
open until the application is closed.
ADO.NET is disconnected database access model, which means
when an application interacts with the database, the
connection is opened to serve the request of the
application, and is closed as soon as the request is completed.