Difference between ADO and ADO.net ?
- 11 Answers
- 27745 Views
- Accenture, BirlaSoft, College School Exams Tests, Krest, Red Apple, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / jebamani
1.ado.net is dataset.
ado is recordset.
2.ado.net is disconnected access to the database.
ado is connected access to the database.
3.in ado.net user can move one data from one table to
another table.
In ado user can move sequentially to database.
| Is This Answer Correct ? | 42 Yes | 4 No |
main upgaded differencees
1disconnected data archetecture
2 data cached in dataset
3 data transefer in XML format
4 interaction with database is done through the datacommands
| Is This Answer Correct ? | 28 Yes | 9 No |
Answer / c.ranadeepreddy
1.ado is server based technology?
2.ado is user control process?
3.ado is object oriented?
4.ado is COM based library?
| Is This Answer Correct ? | 17 Yes | 5 No |
Answer / 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.
| Is This Answer Correct ? | 15 Yes | 4 No |
Answer / sonika
*)ado is connected mode always where as ado.net is
connected as well as disconnected.
*)ado ---recordset whereas ado.net ---dataset
*)ado---c,c++whereas ado.net---- .net framework
*)ado--server based whereas ado.net --client
| Is This Answer Correct ? | 11 Yes | 6 No |
Answer / ajit
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.
| Is This Answer Correct ? | 7 Yes | 2 No |
Answer / rajani kanth reddy
ado means activex data object
ado.net means activex data object for .net
ado uses record set for getting data from database
ado.net uses dataset for getting multiple table information
ado supports connection oriented
ado.net supports both connection & disconnected architeture
| Is This Answer Correct ? | 6 Yes | 1 No |
Answer / schk123
Just to correct you at one point,
There is no cursor support in ADO.NET. Cursors are a
database-specific technology and thus are tied to features
of a particular database such as SQL Server? or Oracle.
| Is This Answer Correct ? | 27 Yes | 23 No |
Answer / wubetu
#11 ADO is always used to create a single table by using
recordset only and ADO is also always connection oriented
programming language.
ADO.NET is used to create multible tables by using objects
of the dataset and also it is both connection oriented and
disconnected fashion
.ADO.NET is used for .net programming languages etc.
| Is This Answer Correct ? | 1 Yes | 0 No |
What does connection string consists of ?
What do you know about ADO.NET's objects and methods?
What are the three Objects of ADO.
What are the benefits of ADO.NET?
What is data reader in ado.net?
Explain the architecture of ado.net?
What providers does Ado.net uses?
feature of ADO.Net
Why is ADO.NET serialization slower than ADO ?
Difference between ADO and ADO.net ?
11 Answers Accenture, BirlaSoft, College School Exams Tests, Krest, Red Apple,
What is ODP.NET ?
what is ado.net
-
Visual Basic (800) - C Sharp (3816)
- ASP.NET (3180)
- VB.NET (461)
- COM+ (79)
- ADO.NET (717)
- IIS (369)
- MTS (11)
- Crystal Reports (81)
- BizTalk (89)
- Dot Net (2435)
- Exchange Server (362)
- SharePoint (720)
- WCF (340)
- MS Office Microsoft (6963)
- LINQ Language-Integrated Query (317)
- WPF (371)
- TypeScript (144)
- Microsoft Related AllOther (311)
