Creating ConnectionString with SqlConnectionStringBuilder Class in C#

The SqlConnectionStringBuilder was introduces in .NET 2.0 that is used to build the database connection string specific for the SQL Server .

The MSDN defines it as “Provides a simple way to create and manage the contents of connection strings used by the SqlConnection class. ”

The SqlConnectionStringBuilder is defined in the namespace System.Data.SqlClient and can help you build the connection string or even parse an existing connection string to retreive the properties .

private void Form1_Load(object sender, EventArgs e)
{
     SqlConnectionStringBuilder connectionString = new SqlConnectionStringBuilder();
     connectionString.DataSource = @".\SQLEXPRESS";
     connectionString.InitialCatalog = "MyDatabase";
     connectionString.IntegratedSecurity = true;
     MessageBox.Show(connectionString.ConnectionString);
}

Some other notable properties that SqlConnectionStringBuilder provides include

• AsynchronousProcessing to indicate if the asynchronous processing is allowed for the connection .
• UserID – Username for the SQL Server
• Password – Password for the SQL Server
• etc.

References

• MSDN – ConnectionStringBuilder Class
  

• 
  How to fill a string with repeated characters in C# ?

• 
  Anonymous Type Differs in C# and VB.NET

• 
  How to find if the Network is Available in WP7 using C#

• 
  How to retreive the list of files from Directory in C# ?

• 
  String vs string in c#

• 
  Retreive the country name in Windows Phone 7

• 
  Optional and Named Parameters in C# 4.0

• 
  Retreive the Device Information from Windows Phone

• 
  How to mark a method as Obsolete or Deprecated in C# ?

• 
  Using Lambda Expression and LINQ to Concatenate strings in C#