Difference between ADO and ADO.NET:

[hari]

· ADO works with connected data. This means that when you access data, such as viewing and updating data, it is real-time, with a connection being used all the time.

ADO.NET supports disconnected architecture. When you access data, ADO.NET makes a copy of the data using XML. ADO.NET only holds the connection open long enough to either pull down the data or to make any requested updates. This makes ADO.NET efficient to use for Web applications.

· ADO has one main object that is used to reference data, called the Recordset object. This object basically gives you a single table view of your data, although you can join tables to create a new set of records. With ADO.NET, you have various objects that allow you to access data in various ways. The DataSet object allows you to store the relational model of your database.

· ADO allows you to create client-side cursors only, whereas ADO.NET gives you the choice of using client-side or server-side cursors. Whereas ADO allows you to persist records in XML format, ADO.NET allows you to manipulate data using.