比較兩種寫法

[sound02]

using (SqlConnection connection = new SqlConnection(connectionString))
{
SqlDataReader returnReader;
connection.Open();
SqlCommand command = BuildQueryCommand(connection, storedProcName, parameters);
command.CommandType = CommandType.StoredProcedure;
returnReader = command.ExecuteReader();
return returnReader;
}

using (SqlConnection connection = new SqlConnection(connectionString))
{
SqlDataReader returnReader;
connection.Open();
SqlCommand command = BuildQueryCommand(connection, storedProcName, parameters);
command.CommandType = CommandType.StoredProcedure;
returnReader = command.ExecuteReader();
connection.Close(); return returnReader;
}
哪种會好些？

[弦弦]

using (SqlConnection connection = new SqlConnection(connectionString))

有了这句话 connection.Close()加不加都无所谓，因为走出括号它都会释放对象，

[一起得瑟]

帮顶

[娃都会打酱油了]

正常情况下using了应该会自动关闭。。。。但我碰到过好多次using完了还不关闭的情况。。。。。
反正一般我都是把close加上的