Answer Posted / lucky

ADO and ADO.NET are different in several ways:

* ADO works with connected data. This means that when
you access data, such as viewing and updating data, it is
real-time, with a connection being used all the time.
This
is barring, of course, you programming special routines
to
pull all your data into temporary tables.
* ADO.NET uses data in a disconnected fashion. When you
access data, ADO.NET makes a copy of the data using XML.
ADO.NET only holds the connection open long enough to
either pull down the data or to make any requested
updates.
This makes ADO.NET efficient to use for Web applications.
It's also decent for desktop applications.
* ADO has one main object that is used to reference
data, called the Recordset object. This object basically
gives you a single table view of your data, although you
can join tables to create a new set of records. With
ADO.NET, you have various objects that allow you to
access
data in various ways. The Dataset object will actually
allow you to store the relational model of your database.
This allows you to pull up customers and their orders,
accessing/updating the data in each related table
individually.
* ADO allows you to create client-side cursors only,
whereas ADO.NET we don't have any cursor support in
ADO.NET.
* ADO allows you to persist records in XML
format, ADO.NET allows you to manipulate your data using
XML as the primary means. This is nice when you are
working
with other business applications and also helps when you
are working with firewalls because data is passed as HTML
and XML.

What is difference between connected and disconnected architecture in ado.net?

1151

---

What are the different namespaces used in the project to connect the database? What data providers available in .net to connect to database?

1336

---

Is it possible to edit data in Repeater control?

957

---

What are the steps you will take to improve performance?

892

---

What is command class in ado.net?

1021

---

What is the use of sqldatareader class?

996

---

What are all features of ADO.Net?

978

---

what is the difference betwen typed dataset and untyped dataset?in general which dataset can we use in programming?

1013

---

What are the different execute methods of Ado.Net?

1022

---

Which method in OLEDBAdapter is used to populate dataset with records?

1023

---

Describe the command object and its method.

996

---

What is a datareader object?

1097

---

Explain the advantage of ADO.Net?

989

---

What is an orm, and why would you use one instead of plain old ado.net?

1046

---

How to retrieve the user id which is provided while windows authentication?

1096

---