Difference between ado and ado.net

Answer 1

ADO is a com base library that supports only connected data. This means that when we access the data (view, edit and update) it is affected in real-time,since the connection is being used all the time. ADO uses the objects as reference data known as Recordset object. Hence it basically gives a single table view of the data. We can also join tables to create a new set of records in ADO.ADO allows to create only client-side cursors. Using ADO we can persist records in XML format and XML integration is not possible.

ADO.NET is a CLR based library that supports disconnected recordsets. This means that When we access data, ADO.NET makes a copy of the data using XML and holds the connection to pull down the data or to make any requested updates as long as we need. The best method to follow is ADO.NET.ADO.NET uses various objects known as Dataset that allow to access data in various methods. Hence it allows to store the relational model of the database and helps us to access /update the data in each related table individually. ADO.NET supports both client-side and server-side cursors. Also the cursors are handled as classes in ADO.NET providing a way to create efficient applications. Using ADO.NET we can manupulate records in XML format. Also ADO.NET 2.0 provides Multiple Active ResultSets (MARS) which allows to have two datareader on one connection open at sametime.

Answer 2

ADO.NET and ASP.NET are not mutually exclusive, they serve 2 different purposes.

ASP.NET is a library for developing web applications.

ADO.NET is a library for accessing databases.

A Visual Studio project could use both libraries to write a web application that accesses databases

Answer 3

Ado.net is data base engine , where Asp.net is web page engine