Question

c#数据库网络编程的一个问题

SqlConnectionStringBuilder到底有什么用，怎么用？能不能通俗的讲一下啊？

Answer 1

SqlConnectionStringBuilder builder =
new SqlConnectionStringBuilder(GetConnectionString());

// The input connection string used the
// Server key, but the new connection string uses
// the well-known Data Source key instead.
Console.WriteLine(builder.ConnectionString);

// Pass the SqlConnectionStringBuilder an existing
// connection string, and you can retrieve and
// modify any of the elements.
builder.ConnectionString = "server=(local);user id=ab;" +
"password= a!Pass113;initial catalog=AdventureWorks";

// Now that the connection string has been parsed,
// you can work with individual items.
Console.WriteLine(builder.Password);
builder.Password = "new@1Password";
builder.AsynchronousProcessing = true;

// You can refer to connection keys using strings,
// as well. When you use this technique (the default
// Item property in Visual Basic, or the indexer in C#),
// you can specify any synonym for the connection string key
// name.
builder["Server"] = ".";
builder["Connect Timeout"] = 1000;
builder["Trusted_Connection"] = true;
Console.WriteLine(builder.ConnectionString);

Answer 2

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";
builder.IntegratedSecurity = true;
builder.UserInstance = true;
builder.TypeSystemVersion = "SQL Server 2008";

SqlConnection sql = new SqlConnection(builder.ConnectionString);