SqlConnectionStringBuilder

来源：互联网发布：java接口作为参数传递编辑：程序博客网时间：2024/06/05 15:11

using System;
using System.Data.SqlClient;

SqlConnectionStringBuilder builder = new SqlConnectionStringBuilder();
builder.DataSource = Environment.MachineName;     // builder["server"]
builder.InitialCatalog = "ProductSet";           // builder["database"]
builder.IntegratedSecurity = true;              // builder["trusted_connection"]
builder.TypeSystemVersion = "SQL Server 2000"; // builder["Type System Version"]

SqlConnectionStringBuilder builder = new SqlConnectionStringBuilder();
builder.DataSource = string.Format(@"{0}/SQLEXPRESS", Environment.MachineName);
builder.InitialCatalog = "ProductSet";
builder.IntegratedSecurity = true;
builder.TypeSystemVersion = "SQL Server 2005";

SqlConnectionStringBuilder builder = new SqlConnectionStringBuilder();
builder.DataSource = string.Format(@"{0}/SQLEXPRESS", Environment.MachineName); // Environment.MachineName <=> "." 本地服务器名。
builder.AttachDBFilename = @"|DataDirectory|/ProductSet.mdf"; // "|DataDirectory|" <=> "." 当前工作目录。
builder.IntegratedSecurity = true;
builder.UserInstance = true;
builder.TypeSystemVersion = "SQL Server 2008";

SqlConnection sql = new SqlConnection(builder.ConnectionString);