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
Write the .net syntax for 'for loop'?
How does linq work?
Explain what is an interface and what is an abstract class? Please, expand by examples of using both. Explain why?
Differences between datagrid, datalist and repeater in .net?
Explain dataset.acceptchanges and dataadapter.update methods in .net?
Dynamic Fonts
Explain what are possible implementations of distributed applications in .net?
Explain about the Common Language Runtime?
Difference between machine.config and web.config?
What are the different types of Classes in .NET?
Can you explain what do you understand about web service?
Is .net core the future?
What's the use of system.diagnostics.process class in .net?
What is connected and diconnected database ?
Explain about .Net products?