Should I Dispose() DataSet and DataTable?

by

Here are a couple of discussions explaining why Dispose is not necessary for a DataSet.

To Dispose or Not to Dispose ?:

The Dispose method in DataSet exists ONLY because of side effect of inheritance– in other words, it doesn’t actually do anything useful in the finalization.

Should Dispose be called on DataTable and DataSet objects? includes some explanation from an MVP:

The system.data namespace (ADONET) does not contain
unmanaged resources. Therefore there is no need to dispose any of those as
long as you have not added yourself something special to it.

Understanding the Dispose method and datasets? has a with comment from authority Scott Allen:

In pratice we rarely Dispose a DataSet because it offers little benefit”

So, the consensus there is that there is currently no good reason to call Dispose on a DataSet.

More Related Contents:

  1. Is it possible to force the use of “using” for disposable classes?
  2. Do HttpClient and HttpClientHandler have to be disposed between requests?
  3. OleDB & mixed Excel datatypes : missing data
  4. Will the Garbage Collector call IDisposable.Dispose for me?
  5. How I can filter a Datatable?
  6. Using statement vs. IDisposable.Dispose()
  7. Dispose, when is it called?
  8. returning in the middle of a using block
  9. What happens if i return before the end of using statement? Will the dispose be called?
  10. yield return statement inside a using() { } block Disposes before executing
  11. Questions about Entity Framework Context Lifetime
  12. Datatable vs Dataset
  13. What is IDisposable for?
  14. Manually destroy C# objects
  15. using statement FileStream and / or StreamReader – Visual Studio 2012 Warnings
  16. Do I need to Dispose a SemaphoreSlim?
  17. Who Disposes of an IDisposable public property?
  18. Determining if IDisposable should extend an interface or be implemented on a class implementing said interface
  19. Convert IEnumerable to DataTable
  20. Is it considered acceptable to not call Dispose() on a TPL Task object?
  21. When should I use “using” blocks in C#? [duplicate]
  22. Export DataTable to Excel File
  23. Async network operations never finish
  24. Convert DataTable to generic List?
  25. DataTable, How to conditionally delete rows
  26. Why Dispose is not called even with using-statement?
  27. Refresh AWS RDS database from Power BI Web
  28. Convert DataTable to List
  29. Print Contents Of A DataTable
  30. Is it necessary to dispose System.Timers.Timer if you use one in your application?

Leave a Comment