连接池的使用



using System;
using System.Collections.Generic;
using System.Data.SqlClient;
using System.Diagnostics;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace _05连接池
{
    class Program
    {
        static void Main(string[] args)
        {
            // 连接池，尽可能早关闭，尽可能晚打开
            string connStr = @"server=.;database=MySecondDB;uid=sa;password=520;";
            Stopwatch sp = new Stopwatch();
            sp.Start();
            for (int i = 0; i < 100; i++)
            {
                SqlConnection conn = new SqlConnection(connStr);
                conn.Open();
                conn.Close();
            }
            sp.Stop();

            Console.WriteLine(sp.Elapsed);               
            Console.ReadKey();
        }
    }
}