Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between ADO and ADO.net ?
- 11 Answers
- 30956 Views
- Accenture, BirlaSoft, College School Exams Tests, Krest, Red Apple, I also Faced
- E-Mail Answers
Answer Posted / lokesh
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 gives you the choice of either using client-
side or server-side cursors. In ADO.NET, classes actually
handle the work of cursors. This allows the developer to
decide which is best. For Internet development, this is
crucial in creating efficient applications.
? Whereas 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.
| Is This Answer Correct ? | 63 Yes | 8 No |
Post New Answer View All Answers
How can you identify whether or not any changes are made to the DataSet object since it was last loaded?
What is difference between connected and disconnected architecture in ado.net?
What are the uses of Stored Procedure?
Give an example of a .net application which connects to microsoft access database using ado.net classes.
What two types of data providers does ADO.NET supply? What determines which one you should use?
What is ole access?
What is a data control clerk?
Is it possible to edit data in Repeater control?
What is sqlconnection and sqlcommand?
Do you use stored procedure in ado.net?
What is the use of adodc?
Explain the dataadapter class in ado.net?
What is difference in record set and dataset?
What is ado data control?
What property must be set and what method must be called in your code to bind the data from some data source to the Repeater control?
