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.

Which is better viewstate or session?

935

---

How do I use response redirect?

982

---

How is a session stored and maintained in asp.net?

1001

---

Which of the following .NET framework supports Web API?

1088

---

If you are using components in your application, how can you handle exceptions raised in a component?

2681

---

Explain one critical mapping?

995

---

What is the base class from which web forms are inherited?

1015

---

Which object encapsulates state or data of a user?

1069

---

What are the server controls in asp.net?

957

---

What are the advantages of Web API?

1115

---

Any disadvantages in Dataset and in reflection ?

3258

---

Explain the concept of MVC Scaffolding?

1024

---

How can we access static variable?

1098

---

What is the state management in asp.net?

1022

---

What is difference between Fragment Caching and Page Caching in ASP.NET?

1018

---