in a “using” block is a SqlConnection closed on return or exception?

by
  1. Yes
  2. Yes.

Either way, when the using block is exited (either by successful completion or by error) it is closed.

Although I think it would be better to organize like this because it’s a lot easier to see what is going to happen, even for the new maintenance programmer who will support it later:

using (SqlConnection connection = new SqlConnection(connectionString)) 
{    
    int employeeID = findEmployeeID();    
    try    
    {
        connection.Open();
        SqlCommand command = new SqlCommand("UpdateEmployeeTable", connection);
        command.CommandType = CommandType.StoredProcedure;
        command.Parameters.Add(new SqlParameter("@EmployeeID", employeeID));
        command.CommandTimeout = 5;

        command.ExecuteNonQuery();    
    } 
    catch (Exception) 
    { 
        /*Handle error*/ 
    }
}

More Related Contents:

  1. Do I have to Close() a SQLConnection before it gets disposed?
  2. An unhandled exception of type ‘System.InvalidOperationException’ occurred in System.Data.dll?
  3. What are the uses of “using” in C#?
  4. What is the C# Using block and why should I use it? [duplicate]
  5. What is the best workaround for the WCF client `using` block issue?
  6. Do HttpClient and HttpClientHandler have to be disposed between requests?
  7. Nested using statements in C#
  8. Why should you remove unnecessary C# using directives?
  9. When should I use “using” blocks in C#? [duplicate]
  10. “open/close” SqlConnection or keep open?
  11. Under what circumstances is an SqlConnection automatically enlisted in an ambient TransactionScope Transaction?
  12. Using statement vs. IDisposable.Dispose()
  13. How is performance affected by an unused using directive?
  14. How do I use the C#6 “Using static” feature?
  15. Does Stream.Dispose always call Stream.Close (and Stream.Flush)
  16. Is SqlCommand.Dispose() required if associated SqlConnection will be disposed?
  17. How to run multiple SQL commands in a single SQL connection?
  18. Using Statement with Generics: using ISet = System.Collections.Generic.ISet
  19. SqlCommand with using statement
  20. yield return statement inside a using() { } block Disposes before executing
  21. Questions about Entity Framework Context Lifetime
  22. Is it possible to force the use of “using” for disposable classes?
  23. Using the using statement in C# [duplicate]
  24. Manually destroy C# objects
  25. Is it better to execute many sql commands with one connection, or reconnect every time?
  26. using statement FileStream and / or StreamReader – Visual Studio 2012 Warnings
  27. Will a using block close a database connection?
  28. Using various types in a ‘using’ statement (C#)
  29. SqlConnection Thread-Safe?
  30. Why remove unused using directives in C#?

Leave a Comment