如果将处置关联的 SqlConnection，是否需要 SqlCommand.Dispose()? [英] Is SqlCommand.Dispose() required if associated SqlConnection will be disposed?

问题描述

我通常使用这样的代码:

I usually use code like this:

using (var connection = new SqlConnection(ConfigurationManager.ConnectionStrings["MyConn"].ConnectionString))
{
   var command = connection.CreateCommand();
   command.CommandText = "...";
   connection.Open();
   command.ExecuteNonQuery();
}

我的 command 会自动处理吗?或者不是，我必须将它包装到 using 块中?是否需要dispose SqlCommand?

Will my command automatically disposed? Or not and I have to wrap it into using block? Is it required to dispose SqlCommand?

推荐答案

这样做:

using(var connection = new SqlConnection(ConfigurationManager.ConnectionStrings["MyConn"].ConnectionString))
using(var command = connection.CreateCommand())
{
   command.CommandText = "...";
   connection.Open();
   command.ExecuteNonQuery();
}

不对命令调用 dispose 不会做任何坏事.但是，对其调用 Dispose 将抑制对终结器的调用，使调用 dispose 提高性能.

Not calling dispose on the command won't do anything too bad. However, calling Dispose on it will suppress the call to the finalizer, making calling dispose a performance enhancement.

这篇关于如果将处置关联的 SqlConnection，是否需要 SqlCommand.Dispose()?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！