Interested to Buy Any Domain ? << Click Here >> for more details...
What is the main difference between ADO and ADO.Net
- 4 Answers
- 9917 Views
- HCL, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / hhh
ADO- Connection-Oriented Architecture
Use Record Set
Communicate in Binary mode
Ado.net Dis-connected architecture
Use DataSet,Adapter
Parse Data in XML mode
| Is This Answer Correct ? | 27 Yes | 0 No |
Answer / jyoti
ADO was a connected data access model, which means that when
a connection to the database is made, the connection remains
open until the application is closed.
ADO.NET is disconnected database access model, which means
when an application interacts with the database, the
connection is opened to serve the request of the
application, and is closed as soon as the request is completed.
All data is presented in XML, as compared to ADO.
| Is This Answer Correct ? | 11 Yes | 2 No |
Answer / babina
The old ADO (ActiveX Data Object) has evolved to ADO.NET in
the .NET Framework. The ADO.NET object is a lightweight
object. The ADO Recordset was a huge object in ADO. It
provided the ability to support multiple types of cursors.
It provided fast lightweight "firehose" cursor and also
supported a disconnected client-side cursor that supported
tracking, optimistic locking, and automatic batch updates of
a central database. However, all of this functionality was
difficult to customize.
ADO.NET breaks the functionality of the ADO object to
multiple classes, thereby allowing a focused approach to
developing code. The ADO.NET DataReader is equivalent to the
"firehose" cursor. The DataSet is a disconnected cache with
tracking and control binding functionality. The DataAdapter
provides the ability to completely customize how the central
data store is updated with the changes to a DataSet.
| Is This Answer Correct ? | 6 Yes | 1 No |
ADO- Connection-Oriented Architecture
Use Record Set
Communicate in Binary mode
Ado.net Dis-connected architecture
Use DataSet,Adapter
Parse Data in XML mode
| Is This Answer Correct ? | 2 Yes | 0 No |
What is typed dataset ?
What are all the different methods under sqlcommand?
What is disconnected architecture in ado.net?
types of Store procedure in Sqlserver2000?
What is difference between dataset and datatable?
If we are not returning any records from the database, which method is to be used?
Define bubbled event?
What is the difference between ado.net and oledb?
Which one of the objects is a high-level abstraction of the connection and command objects in ado.net?
What is connected architecture in ado.net?
Explain About ado.net components/objects. Usage of data adapters and tell the steps to retrieve data.
What is ole in vb?
-
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)
