How to Disconnect from a Database Safely

After database connection and access are complete, applications must disconnect from the database to properly release un-managed resources. These un-managed resources are provided to DG by the Common Language Runtime (CLR) for network access. In general, DG and the CLR will not release these un-managed resources for you, and if not released, unexpected results, including loss of data, can occur. You must explicitly release un-managed resources associated with AdgConnection objects using the AdgConnection.Close or AdgConnection.Dispose methods. You should call one of these methods before the AdgConnection variable loses scope or is reassigned.

  Cx.Close();
  Cx = null;

Whether you use AdgConnection.Close or AdgConnection.Dispose is a matter of preference since they perform the same task of disconnecting the database and releasing un-managed resources. Note that AdgConnection.Dispose implements the conventional System.IDisposable interface for AdgConnection .

See Also

  <span> [AdgConnection Class](adg-connection-class.html)
  </span>
  <br /> [AdgConnection.Close Method](adg-connection-class-close-method.html)
  <br /> [AdgConnection.Dispose Method](adg-connection-class-dispose-method.html)
  <br /> [Connecting to a Database](connectingtoa-database.html)
  <br />