SqlConnection SqlCommand SqlDataReader IDisposable

by

This is 100% the correct way. If a class leverages IDisposable it should be wrapped in a using statement to ensure that the Dispose() method is called. Further, communicating with an outside technology -unmanaged at that -like SQL Server shouldn’t be taken lightly. The SqlCommand object implements IDisposable for a very good reason. The code below is the Dispose() method for the SqlCommand object:

protected override void Dispose(bool disposing)
{
    if (disposing)
    {
        this._cachedMetaData = null;
    }
    base.Dispose(disposing);
}

and as you can see, it’s releasing a reference to the _cachedMetaData object so that it too can get cleaned up.

More Related Contents:

  1. ExecuteReader requires an open and available Connection. The connection’s current state is Connecting
  2. MultipleActiveResultSets=True or multiple connections?
  3. How to keep single SQL Server connection instance open for multiple request in C#?
  4. How do I connect to a SQL database from C#?
  5. SQLite Database Locked exception
  6. How to deploy application with sql server database on clients
  7. Exception when AddWithValue parameter is NULL
  8. Bulk Update in C#
  9. How to catch SQLServer timeout exceptions
  10. Use of SqlParameter in SQL LIKE clause not working
  11. EF 6 – How to correctly perform parallel queries
  12. How to pass a table-value parameter
  13. How can I retrieve a list of parameters from a stored procedure in SQL Server
  14. DataTable equivalent in Java [duplicate]
  15. How to use SqlCommand to CREATE DATABASE with parameterized db name?
  16. ExecuteNonQuery returning -1 when using sql COUNT despite the query string
  17. Using SqlDataAdapter to insert a row
  18. How do I re-write a SQL query as a parameterized query?
  19. Add WHERE clauses to SQL dynamically / programmatically
  20. Horrible performance using SqlCommand Async methods with large data
  21. Check if a SQL table exists
  22. GO statements blowing up sql execution in .NET
  23. Unable to load SqlServerSpatial.dll
  24. Unable to connect to localDB in VS2012 – “A network-related or instance-specific error occurred while establishing a connection to SQL Server…”
  25. “The operation is not valid for the state of the transaction” error and transaction scope
  26. How to get efficient Sql Server deadlock handling in C# with ADO?
  27. .net connection pooling
  28. Passing array to a SQL Server Stored Procedure
  29. Generating sql code programmatically
  30. Do we have transactions in MS-Access?

Leave a Comment