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
- 5824 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 DataReader and DataSet in ADO.NET?
What is difference between ado.net and asp net?
What is method to get XML and schema from Dataset? getXML() and get Schema ()
How can I retrieve two tables of data at a time by using data reader? Data reader read and forward only, how is it possible to get 2 tables of data at a time?
What are the disadvantages of using datalist?
Define atomicity?
Give an example that shows how to execute a stored procedure in ado.net?
What is microsoft ole db provider for sql server?
What is ole in vb?
What are the objects of ado.net?
What is the difference between sqlcommand and sqldataadapter?
What is variable view?
What is the full form of ado?
Which is faster ado.net or linq?
What are the drawbacks of using ado.net?
