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
- 5901 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 ambient transaction?
What are the parameters that control most of connection pooling behaviours?
What are ado.net objects?
Explain the role of data provider in ado.net?
Which method is used by command class to execute SQL statements that return single value?
What are the rules to implement connection pooling?
What is data adapter in ado.net with example?
Explain the various objects in dataset.
What are all the different authentication techniques used to connect to MS SQL Server?
How do you implement locking concept for dataset?
What are the namespaces used in ADO.Net to connect to a database?
What is ole db query?
differance between ADO vs ADO.Net?
How do we use stored procedure in ADO.NET and how do we provide parameters to the stored procedures?
What are the essential features of ado.net?
