SqlConnectionStringBuilder的用法

SqlConnectionStringBuilder提供了一个很好的构建SQL连接字串的方式。不多说，见代码：

           SqlConnectionStringBuilder builder = new SqlConnectionStringBuilder
           {
                DataSource = "(localdb)\\MSSQLLocalDB",
                InitialCatalog = "UserManage",
                //UserID = "adb",
                //Password = "aaa",
                IntegratedSecurity = true,//是否使用windows登录相同的用户名和密码
                MultipleActiveResultSets = true,//是否允许一次连接多次查询
               ApplicationName="EntityFramework"//标识应用程序名称，可以自定义，供在SQL跟踪调试时用
            };
            string connStr = builder.ConnectionString;

上面代码得到的连接字串为：data source=(localdb)\\MSSQLLocalDB;initial catalog=UserManage;integrated security=True;MultipleActiveResultSets=True;App=EntityFramework

Namespace:   System.Data.SqlClient
Assembly:  System.Data (in System.Data.dll)

 

转载于:https://www.cnblogs.com/ccjungle/p/8564892.html