What’s better: DataSet or DataReader?

by

That is essentially: “which is better: a bucket or a hose?”

A DataSet is the bucket here; it allows you to carry around a disconnected set of data and work with it – but you will incur the cost of carrying the bucket (so best to keep it to a size you are comfortable with).

A data-reader is the hose: it provides one-way/once-only access to data as it flies past you; you don’t have to carry all of the available water at once, but it needs to be connected to the tap/database.

And in the same way that you can fill a bucket with a hose, you can fill the DataSet with the data-reader.

The point I’m trying to make is that they do different things…

I don’t personally use DataSet very often – but some people love them. I do, however, make use of data-readers for BLOB access etc.

More Related Contents:

  1. Call a stored procedure with parameter in c#
  2. Insert 2 million rows into SQL Server quickly
  3. Pass table valued parameter using ADO.NET
  4. When using Trusted_Connection=true and SQL Server authentication, will this affect performance?
  5. Connection timeout for SQL server
  6. How DataReader works?
  7. Fastest method for SQL Server inserts, updates, selects
  8. Determine if a number can be made with prepicked numbers and times
  9. The provider is not compatible with the version of Oracle client
  10. Best way in asp.net to force https for an entire site?
  11. Entity Framework Refresh context? [closed]
  12. Can I get more than 1000 records from a DirectorySearcher?
  13. Pulling data from a webpage, parsing it for specific pieces, and displaying it
  14. IEnumerable doesn’t have a Count method
  15. Adding custom properties for each request in Application Insights metrics
  16. Can you prevent your ASP.NET application from shutting down?
  17. Creating iCal Files in c#
  18. Get current System.Web.UI.Page from HttpContext?
  19. DataTable equivalent in Java [duplicate]
  20. Recursive TreeView in ASP.NET
  21. Index (zero based) must be greater than or equal to zero
  22. Get All Web Controls of a Specific Type on a Page
  23. Full postback triggered by LinkButton inside GridView inside UpdatePanel
  24. Unable to find the requested .Net Framework Data Provider. It may not be installed
  25. GeneralLink in Sitecore
  26. Change cell color on different values – Gridview
  27. Bind Dictionary with list in viewmodel to checkboxes
  28. {version} wildcard in MVC4 Bundle
  29. Reading a date using DataReader
  30. What are some alternatives to ReSharper? [closed]

Leave a Comment