Can you explain the difference between an ADO.NET Dataset
and an ADO Recordset?
- 3 Answers
- 10120 Views
- HCL, Wipro, I also Faced
- E-Mail Answers
Answer Posted / kvnvani
1. In ADO recordset(in memory representation of data) looks
like single table
where as
in ADO.NET dataset(in-memory representation of data) is a
collection of one or more tables(use JOIN Query).
2. In ADO you communicate with the database by making the
calls to an OLEDB Provider
where as
in ADO.NET you communicate with the database through a Data
Adapter(an OledbDataAdapter,SQLDataAdapter,OdbcDataAdapter
or OracleDataAdapter object) which make calls to an OLEDB
Provider or the API's provided by the underlying datasource.
3. In ADO recordset objects operate in a fully connected
state
where as
in ADO.NET dataset operate in disconnected state.
4. ADO requires COM marshalling to transmit records sets
among components, does require that ADO data types be
converted to COM data types.
where as
ADO.NET does not require data-type conversions.
5. In ADO it is sometime sproblematic firewalls( firewalls
are typically configured to allow HTML text to pass, but to
prevent system-level requests (such as COM marshalling)
from passing) prevent many types of requets
where as
in ADO.NET datasets using XML, firewalls can allow datasets
to pass.
| Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
In which situation can you not use a viewstate?
Which ASP.NET configuration options are supported in the ASP.NET implementation on the shared web hosting platform?
Where is asp.net session stored?
Distinguish between Server-side and Client-side code with its functionality?
Explain what is clr?
What are the Types of session management in ASP.NET
Does web services support data reader like pom project?
Explain client-side scripting?
What are the steps to follow to host a web application on a web server?
How to fetch a data from one table to another table in asp.net ?
What is the difference between asp.net and mvc?
Explain the difference between or and orelse?
Explain the different types of directives in .net?
What is the maximum amount of memory any single process on windows can address?
What is postback in asp net?
