once data is fetched into dataset connection gets closed. but in datareader
connection is always maintained...then why datareader is fast and mainly
recommended ?
- 2 Answers
- 5351 Views
- I also Faced
- E-Mail Answers
Answer Posted / abhishek
datareader is forwardonly thus is fast and is mostly used
while retrieving the data from the database.
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
Define data adapter?
What are the major challenges in accessing data from a database?
What is the maximum pool size in ado.net connection string?
Explain the dataadapter class in ado.net?
What is a non query?
What is the difference between dataset and datatable?
What is serialization and de-serialization in .net?
Why do we serialize data?
What are the parameters that control most of connection pooling behaviours?
Explain what is datagrid with an example?
I loaded the dataset with a table of 10 records. One of the records is deleted from the backend, how do you check whether all the 10 records were present while updating the data(which event and steps) and throw the exception 28 can datareader hold data from multiple tables?
What is ado or jdbc?
What is difference between connected and disconnected architecture in ado.net?
What is the difference between Response.Expires and Reponse.ExpiresAbsolute?
Which is better entity framework or ado.net?
