Difference between DataReader and DataAdapter / DataSet and
DataAdapter?
- 3 Answers
- 32150 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / anul haq
When accessing data the DataReader is the hands down winner.
Performance increases almost exponentially over the DataSet
when more than a few queries are executed sequentially.
Simple, fast forward, read-only access to result sets is the
DataReader's favorite pastime. If data doesn't need to be
modified, cached or serialized consider using a reader.
Don't dismiss the DataReader just because you need results
in XML. Try using the ExecuteXmlReader method of the
SqlCommand class. Just don't forget the FOR XML clause in
your query.
Business applications with a strong BLL that coerce
requested data into new types can use a DataReader without
fear of lost scalability. Often times the application's
business objects can easily duplicate or enhance some of the
functionality that the DataSet is so popular for. Creating
those business objects can mean the difference between an
application that entirely relies on DataSets to one that can
leverage their usefulness only where need be.
Binding of read-only data is much more efficient using a
reader. Just imagine how many times a day that DropDownList
you use is populated. Remember how much things cost in the
long run.
| Is This Answer Correct ? | 20 Yes | 21 No |
Post New Answer View All Answers
How do you update database through dataset?
Explain About ado.net components/objects. Usage of data adapters and tell the steps to retrieve data.
What is the significance of CommandBehavior.CloseConnection ?
What is aggregating data ?
differences between ADO and ADO.NET
Explain why canot we use multiple inheritance and garbage collector paralelly in .net?
What are all the different methods under sqlcommand?
How to check if a datareader is closed or opened? IsClosed()
What is meant by ‘transaction’ in a database and what are the ‘properties of transaction’?
Which is faster ado.net or linq?
What is the difference between Response.Expires and Reponse.ExpiresAbsolute?
What is oledb connection?
Explain the differences between oledb sql server, oledbdotnet provider?
Explain ODP.net
Explain the difference between an ado.net dataset and an ado recordset?
