Answer Posted / guneetinder singh
1. ADO used connected data usage, while ADO.net used
disconnected data environment.
2. ADO used OLE DB to access data and is COM-based, while
ADO.net uses XML as the format for transmitting data to and
from your database and web application.
3. In ADO, Record set, is like a single table or query
result, while in ADO.net Dataset, can contain multiple
tables from any data source.
4. In ADO, it is sometime problematic because firewall
prohibits many types of request, while in ADO.net there is
no such problem because XML is completely firewall-proof.
| Is This Answer Correct ? | 28 Yes | 2 No |
Post New Answer View All Answers
How to check if the Dataset has records ?
Which method in OLEDBAdapter is used to populate dataset with records?
What is difference between datareader and dataadapter?
Which method is used by command class to execute SQL statements that return single value?
How to find the given query is optimised one or not?
How to retrieve the user id which is provided while windows authentication?
how Sequence to connect and retrieve data from database using dataset?
What is a dataview?
Which object is used to add relationship between two Datatables?
Which is faster entity framework or ado.net?
Which is faster datareader or dataadapter?
What is aggregating data ?
What is connection string?
How do you connect to sql server database without using sqlclient?
What is the difference between data grid and data repeater?