SqlConnection.Close() inside using statement

Question

I'm using this code:

    public void InsertMember(Member member)     {         string INSERT = "INSERT INTO Members (Name, Surname, EntryDate) VALUES (@Name, @Surname, @EntryDate)";          using (sqlConnection = new SqlConnection(sqlConnectionString_WORK))         {             sqlConnection.Open();              using (SqlCommand sqlCommand = new SqlCommand(INSERT, sqlConnection))             {                 sqlCommand.Parameters.Add("@Name", SqlDbType.VarChar).Value = member.Name;                 sqlCommand.Parameters.Add("@Surname", SqlDbType.VarChar).Value = member.Surname;                 sqlCommand.Parameters.Add("@EntryDate", SqlDbType.Date).Value = member.EntryDate;                  sqlCommand.ExecuteNonQuery();             }         }     } 

Is it wrong if I don't add sqlConnection.Close(); before disposing it? I mean. It's not showing any errors, no problems at all. Is it better to Close it first? If yes, why?

Answer 1

No need to Close or Dispose the using block will take care of that for you.

As stated from MSDN:

The following example creates a SqlConnection, opens it, displays some of its properties. The connection is automatically closed at the end of the using block.

private static void OpenSqlConnection(string connectionString)  {     using (SqlConnection connection = new SqlConnection(connectionString))     {         connection.Open();         Console.WriteLine("ServerVersion: {0}", connection.ServerVersion);         Console.WriteLine("State: {0}", connection.State);     }  }