关闭 SqlConnection 和 SqlCommand c# [英] Closing SqlConnection and SqlCommand c#

问题描述

在我的 DAL 中，我编写如下查询:

In my DAL I write queries like this:

using(SQLConnection conn = "connection string here")
{
    SQLCommand cmd = new ("sql query", conn);
    // execute it blah blah
}

现在我突然想到我没有明确关闭 SQLCommand 对象.现在我知道使用"块会处理 SQLConnection 对象，但这也会处理 SQLCommand 对象吗?如果不是那么我有一个严重的问题.我将不得不在成千上万行代码上的 SQLCommand 上添加使用"，或者在数百种方法上执行 cmd.Close().请告诉我，如果输入 using 或 close 命令会为 Web 应用程序提供更好的内存管理?

Now it just occurred to me that I am not explicitly closing the SQLCommand object. Now I know the 'using' block will take care of the SQLConnection object, but will this also take care of the SQLCommand object? If not than I have a serious problem. I would have to put in the 'using' on the SQLCommand on thousands and thousands of lines of code or do a cmd.Close() on hundreds of methods. Please tell me that if putting in the using or closing the command will provide a better memory management of the web app?

推荐答案

不，using 语句不会处理命令.

No, the using statement will not take care of the command.

您也应该使用 using 语句来包装命令，因为这将正确地调用它们的 Dispose:

You should wrap the commands with using statements as well, since this will properly call Dispose on them:

using(SQLConnection conn = 'connection string here')
{
    using(SQLCommand cmd = new ('sql query', conn))
    {
        //execute it blah blah
    }
}

这篇关于关闭 SqlConnection 和 SqlCommand c#的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！