ado.net关于操作数据库的连接字符串整理

            SqlConnectionStringBuilder conSb = new SqlConnectionStringBuilder();
            conSb.DataSource = @"localhost\sqlexpress";
            conSb.InitialCatalog = "TestDb";
            conSb.Pooling = true;
            conSb.MaxPoolSize = 10;
            conSb.MinPoolSize = 1;
            conSb.IntegratedSecurity = false;
            conSb.UserID = "sa";
            conSb.Password = "123456";
            conSb.PersistSecurityInfo = true;
            SqlConnection sqlCon = new SqlConnection(conSb.ConnectionString);//直接获取ConnectionString
            sqlCon.Open();

通常情况下，我们配置好SqlConnectionStringBuilder实例的几个常用属性，然后直接获取实例的ConnectionString属性后就大功告成了。