What are good ADO.NET object(s) to replace the ADO
Recordset object.
- 1 Answers
- 3470 Views
- I also Faced
- E-Mail Answers
Answer / ch.raviteja
The differences includes
In ADO, the in-memory representation of data is the Recordset.
In ADO.net, it is the dataset
A recordset looks like a single table in ADO
In contrast, a dataset is a collection of one or more tables in ADO.net
ADO is designed primarily for connected access
ADO.net the disconnected access to the database is used
In ADO you communicate with the database by making calls to an OLE DB provider.
In ADO.NET you communicate with the database through a data adapter (an OleDbDataAdapter, SqlDataAdapter, OdbcDataAdapter, or OracleDataAdapter object), which makes calls to an OLE DB provider or the APIs provided by the underlying data source.
In ADO you cant update the database from the recordset. ADO.NET the data adapter allows you to control how the changes to the dataset are transmitted to the database.
| Is This Answer Correct ? | 2 Yes | 1 No |
What are the benefits of Model-View-Controller Architecture?
Please explain what is immutability, what is it for and how is it codified?
What is the difference between a Hash Table and a Dictionary?
what is the difference between class and structures?
Tell us what is the native image generator?
What are nullable types in .NET
0 Answers TryTechnicals Pvt Ltd,
What is CCW (COM Callable Wrapper) ?
Explain manifest & metadata.
How does linq work?
Readonly vs. const?
Explain the main components in .net?
you have a requirement from client, he has an XML file and you need to insert the data into 5-6 tables in database. explain me the procedure.
Dot Net Framework 
