ADO - ActiveX Data Object.
The old ADO is evolved to ADO.Net in .Net Framework.
Differences are as follows:
1. ADO use connected data usage while ADO.Net uses disconnected data environment.
2. ADO uses OLE DB to access data and it is COM based while ADO.Net uses xml as data formate for transmitting data to and from database and web application.
3. ADO Recordset has single table or a query result. While ADO.Net dataset can have multiple tables from any database.
4. ADO is sometimes problamatic, as Firewall prohibits many types of request. While in ADO.Net there is no such problems as xml is completly firwall proof.
5. In ADO we can't generate relation, while in ADO.Net we can generate relations.
6. In ADO's we cant generate SQL statements whereas in ADO.Net we can generate SQL statements.
7. In ADO's we can't send multiple transactions in a single instance whereas in ADO.Net we can send multiple transactions using single instance.
No comments:
Post a Comment