Datatable.Dispose() will make it remove from memory?

by

DataSet and DataTable don’t actually have any unmanaged resources, so Dispose() doesn’t actually do much. The Dispose() methods in DataSet and DataTable exists ONLY because of side effect of inheritance – in other words, it doesn’t actually do anything useful in the finalization.

It turns out that DataSets, DataViews, DataTables suppress finalization in their constructorsc this is why calling Dispose() on them explicitly does nothing.

Presumably, this happens because, as mentioned above, they don’t have unmanaged resources; so despite the fact that MarshalByValueComponent makes allowances for unmanaged resources, these particular implementations don’t have the need and can therefore forgo finalization.

Overview of this Immense Answer:

Without a doubt, Dispose should be called on any Finalizable objects.

DataTables are Finalizable.

Calling Dispose significantly speeds up the reclaiming of memory.

MarshalByValueComponent calls GC.SuppressFinalize(this) in its Dispose() – skipping this means having to wait for dozens if not hundreds of Gen0 collections before memory is reclaimed.

Further Reading:

See this question and the related answer.

More Related Contents:

  1. Proper way to dispose a new Form
  2. What happens if I don’t call Dispose on the pen object?
  3. How to write WinForms code that auto-scales to system font and dpi settings?
  4. How to make a window always stay on top in .Net?
  5. How do I properly exit a C# application?
  6. How to update GUI with backgroundworker?
  7. How do I call paint event?
  8. Best way to access a control on another form in Windows Forms?
  9. How can we show progress bar for upload with FtpWebRequest
  10. The ‘Microsoft.ACE.OLEDB.12.0’ provider is not registered on the local machine while data export to MS ACCESS
  11. Refresh DataGridView when updating data source
  12. Stop the ‘Ding’ when pressing Enter
  13. Background color of a ListBox item (Windows Forms)
  14. How to find overlapping controls that I added to form?
  15. How to receive Plug & Play device notifications without a windows form
  16. InvalidOperationException – object is currently in use elsewhere
  17. ComboBox Dropdown Position
  18. WinForms application hang due to SystemEvents.OnUserPreferenceChanged event
  19. Using C# to search a CSV file and pull the value in the column next to it
  20. Save Settings in VB.Net or C#
  21. How to add event handler for dynamically created controls at runtime?
  22. Control.AddRange(…) is slow
  23. Order of events ‘Form.Load’, ‘Form.Shown’ and ‘Form.Activated’ in Windows Forms
  24. big issue in converting string to datetime using linq-to-entities
  25. Multiple UI Threads – Winforms
  26. How do I clear a combobox?
  27. How to create a form with a border, but no title bar? (like volume control on Windows 7)
  28. Best practices for multi-form applications to show and hide forms? [closed]
  29. Detect when a form has been closed c#
  30. Prompt Dialog in Windows Forms

Leave a Comment