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
What is equivalent for regsvr32 exe in .net ?
Explain the difference between asp.net and asp?
Explain Different kinds of methods?
What is the use of activex control in .net?
Can I write my own .net host?
What is web.config in .net?
What is the difference between a debug and release build?
Do you know what is linq?
How viewstate is being formed and how it's stored on client in .net?
Differentiate between 'DataSet' and 'SQLDataReader' in ADO.NET?
Explain the use of activex control in .net?
Do you know the difference between the stack and the heap?
What does il do?
What is the native image generator?
I am constantly writing the drawing procedures with system.drawing.graphics, but having to use the try and dispose blocks is too time-consuming with graphicsobjects. Can I automate this?