What are good ADO.NET object(s) to replace the ADO
Recordset object.
Answer Posted / 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 |
Post New Answer View All Answers
Tell me about secure socket layer? How to make use of the technology?
Explain .net framework overview?
Explain about managed heap?
What is .net and .net framework?
What are the main components in .net?
Do you know what is the difference between an abstract class and an interface?
How will you do redo and undo in textbox control?
What is the use of Treeview control?
What is the use of gacutil.exe?
How we can achieve Connection pooling in .Net?
Explain how to manage pagination in a page using .net?
What is clr in .net?
Which dll translate xml to sql in internet information server (iis)?
What are Satellite Assemblies? How you will create this? How will you get the different language strings?
How many types of design patterns available in .NET?