Do I have to Close() a SQLConnection before it gets disposed?

by

Since you have a using block, the Dispose method of the SQLCommand will be called and it will close the connection:

// System.Data.SqlClient.SqlConnection.Dispose disassemble
protected override void Dispose(bool disposing)
{
    if (disposing)
    {
        this._userConnectionOptions = null;
        this._poolGroup = null;
        this.Close();
    }
    this.DisposeMe(disposing);
    base.Dispose(disposing);
}

More Related Contents:

  1. Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. The statement has been terminated
  2. in a “using” block is a SqlConnection closed on return or exception?
  3. Under what circumstances is an SqlConnection automatically enlisted in an ambient TransactionScope Transaction?
  4. ASP.NET use SqlConnection connect MySQL
  5. Is SqlCommand.Dispose() required if associated SqlConnection will be disposed?
  6. How to run multiple SQL commands in a single SQL connection?
  7. SqlCommand with using statement
  8. Can I specify a custom location to “search for views” in ASP.NET MVC?
  9. How can I get a list of users from active directory?
  10. Has an event handler already been added?
  11. How to dynamically create ASP.net controls within dynamically created ASP.net controls
  12. MVC Razor view nested foreach’s model
  13. GridView Hide Column by code
  14. IdentityServer4 Role Based Authorization for Web API with ASP.NET Core Identity
  15. Does Stream.Dispose always call Stream.Close (and Stream.Flush)
  16. How to return JSON with ASP.NET & jQuery
  17. How to show a image in database in the image control of Asp.net?
  18. Can I have an optional parameter for an ASP.NET SOAP web service
  19. MemoryStream – Cannot access a closed Stream
  20. How can I get the value of a session variable inside a static method?
  21. How to restrict file type in FileUpload control
  22. Determine OS using Environment.OSVersion [duplicate]
  23. The data source does not support server-side data paging
  24. Prevent textbox autofill with previously entered values
  25. How can I secure passwords stored inside web.config?
  26. How to change CurrentCulture at runtime?
  27. How to add Web API to an existing ASP.NET MVC (5) Web Application project?
  28. How to return a PDF from a Web API application
  29. How to send a Status Code 500 in ASP.Net and still write to the response?
  30. How to get hold of Content that is already read

Leave a Comment