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
Do you know what are three common acronyms used in .net, and what do they stand for?
What is interface and abstract class in .net?
Explain how to stop a thread?
Difference between class and interface in .net?
What is finalize method in .net?
Explain garbage collection?
When displaying fonts, what is the difference between pixels, points and ems?
Please explain what are an object and a class?
What exactly is being serialized when you perform serialization in .net?
What is Flyout Design Pattern in .NET?
What is .net environment?
Explain me what is .net web service?
As you know read-only variables and constants have many similarities, but what is at least one way that they differ?
What is meant by globalization?
What is difference between .net core and .net standard?