What are the differences between ADO and ADO.Net?

S.No	ADO	ADO.Net
1	It is a COM based library.	It is a CLR based library.
2	Classic ADO requires active connection with the data store.	ADO.NET architecture works while the data store is disconnected.
3	Locking feature is available.	Locking feature is not available.
4	Data is stored in binary format.	Data is stored in XML.
5	XML integration is not possible.	XML integration is possible.
6	It uses the object named Recordset to reference data from the data store.	It uses Dataset Object for data access and representation.
7	Using Classic ADO, you can obtain information from one table or set of tables through join. You cannot fetch records from multiple tables independently.	Dataset object of ADO.NET includes collection of DataTables wherein each DataTable will contain records fetched from a particular table. Hence multiple table records are maintained independently.
8	Firewall might prevent execution of Classic ADO.	ADO.NET has firewall proof and its execution will never be interrupted.
9	Classic ADO architecture includes client side cursor and server side cursor.	ADO.NET architecture doesn't include such cursors.
10	You cannot send multiple transactions using a single connection instance.	You can send multiple transactions using a single connection instance.