这个类现在使用连接池功能吗？ - MSSQL 2008 R2 - ASP.net 4.0

Question

我浏览了网络，但我无法准确理解连接池的事情。这是我的查询执行类。每个查询都由此类执行。

谢谢。

using System;
using System.Collections.Generic;
using System.Collections;
using System.Linq;
using System.Web;
using System.Data.Sql;
using System.Data.SqlClient;
using System.Data;
using System.IO;

public class DbConnection
{
    public static string srConnectionString = "server=localhost;database=mydb;uid=sa;pwd=mypw;";

    public DbConnection()
    {

    }

    public static DataSet db_Select_Query(string strQuery)
    {
        DataSet dSet = new DataSet();

        try
        {
            using (SqlConnection connection = new SqlConnection(srConnectionString))
            {
                connection.Open();
                SqlDataAdapter DA = new SqlDataAdapter(strQuery, connection);
                DA.Fill(dSet);
            }
            return dSet;

        }

        catch (Exception)
        {
            using (SqlConnection connection = new SqlConnection(srConnectionString))
            {
                if (srConnectionString.IndexOf("select Id from tblAspErrors") != -1)
                {
                    connection.Open();
                    strQuery = strQuery.Replace("'", "''");
                    SqlCommand command = new SqlCommand("insert into tblSqlErrors values ('" + strQuery + "')", connection);
                    command.ExecuteNonQuery();
                }
            }
            return dSet;
        }
    }

    public static void db_Update_Delete_Query(string strQuery)
    {
        try
        {
            using (SqlConnection connection = new SqlConnection(srConnectionString))
            {
                connection.Open();
                SqlCommand command = new SqlCommand(strQuery, connection);
                command.ExecuteNonQuery();
            }
        }
        catch (Exception)
        {
            strQuery = strQuery.Replace("'", "''");
            using (SqlConnection connection = new SqlConnection(srConnectionString))
            {
                connection.Open();
                SqlCommand command = new SqlCommand("insert into tblSqlErrors values ('" + strQuery + "')", connection);
                command.ExecuteNonQuery();
            }
        }
    }
}

Answer 1

是的，连接池是根据连接字符串创建的。为了防止内存泄漏，您还应该在 SqlCommand 和 SqlDataAdapter 对象周围有一个 using 语句。

SQL Server 连接池 (ADO.NET)

为每个唯一的连接字符串创建一个连接池。当一个
创建池，创建多个连接对象并添加到
池，以满足最小池大小要求。
根据需要将连接添加到池中，直至最大池数
指定大小（默认为 100）。连接被释放回来
当它们关闭或处置时进入池中。

使用语句示例：

using (SqlConnection connection = new SqlConnection(srConnectionString))
{
    connection.Open();
    using(SqlDataAdapter DA = new SqlDataAdapter(strQuery, connection))
    {
        DA.Fill(dSet);
    }
}

using (SqlConnection connection = new SqlConnection(srConnectionString))
{
    if (srConnectionString.IndexOf("select Id from tblAspErrors") != -1)
    {
       connection.Open();
       strQuery = strQuery.Replace("'", "''");
       using(SqlCommand command = new SqlCommand("insert into tblSqlErrors values ('" + strQuery + "')", connection))
       {
          command.ExecuteNonQuery();
       }
    }
}