Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 6002 Views
- I also Faced
- E-Mail Answers
Answer Posted / hhh
DataSet carry considerable overhead because of relations,
multiple tables,
While DataReader only readony and fawardonly stream of
data, it fatch only one row at a time. thats y its faster
| Is This Answer Correct ? | 9 Yes | 0 No |
Post New Answer View All Answers
What is the difference between ado.net and entity framework?
How can we load multiple tables in a dataset?
What are the different execute methods of Ado.Net?
What is difference between ado.net and asp net?
What is the default Timeout for SqlCommand.CommandTimeout property?
What is ado circle?
Explain the difference in record set and dataset?
What is ado.net object model?
Define executenonquery?
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 Dataset Object?
Explain the dataadapter class in ado.net?
Explain the difference between data reader and data set?
What are all the different methods under sqlcommand?
Explain how to copy the contents from one table to another table and how to delete the source table in ado.net?
