Can you explain the difference between an ADO.NET Dataset
and an ADO Recordset?
Answer Posted / thangaraj.r
. 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 ? | 7 Yes | 0 No |
Post New Answer View All Answers
What is the difference between union and structure?
Explain what is event bubbling?
What are themes and skins in 2.0, explain usage scenario?
Explain how is a property designated as read-only?
What is asp.net mvc? : asp.net mvc
Describe session handling in a webfarm?
Explain client-side scripting?
Can we have 2 web config files?
What is a global postback url?
What is difference between singleton and single call?
What is the importance of Global.asax in ASP.NET?
Why mvc is faster than asp.net? : Asp.Net MVC
What are user controls?
What are the server control tags in asp.net.?
To get the values in two different controls to match which control you use it?