| ADO | ADO.NET |
|---|---|
| ADO have recordset. | ADO.NET have data adopter and data set. |
| The objects of ado communicate in binary mode. | It uses XML for passing the data. |
| It supports mostly connection oriented models. | It works in disconnected manners. |
| It derives information about data implicitly at runtime based on metadata, so it is a costly process. | It uses known metadata at design time, so it provides better runtime performance and more consistent runtime behavior. |
| It allows only client-side cursors. | It supports both client side and server side cursors. |
