What?s the role of the DataReader class in ADO.NET connections?
Answer Posted / ajay singh negi
DataReader object is a simply used to read data from the
result sets and because of this feature we call this object
as forward only or read only cursor. It requires a live
connection with the data source. Threw looping you can
efficiently access all or a part of data from the result
set. Note you cannot directly initialize a DataReader
object. Execute reader method of the command object is used
to obtain a valid DataReader object. After using DataReader
you need to close the connection otherwise it is stayed
alive and it is explicitly closed.
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
What is serialization and de-serialization in .net? How can we serialize the dataset object?
What is execute scalar in ado.net?
What is bubbled event can you please explain?
What is the difference between dataset and datatable?
What is ole db and odbc?
How is entity framework different from ado.net?
Explain the DataAdapter.Update() and DataSetAcceptChanges() methods.
What are the Data providers in ADO.Net?
What is XML serialization
What are the main differences between classic ado and ado.net?
Is bulk insert faster than insert?
Which is faster entity framework or ado.net?
What do you mean by performing asynchronous operation using command object?
differences between ADO and ADO.NET
What provider ado.net use by default? Explain the role of data provider in ado.net? What is the role of data provider in ado.net?