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

If you enjoyed this post, please consider leaving a comment or subscribing to the RSS feed to have future articles delivered to your feed reader.

3 Comments

  1. bi May 28, 2011 Reply
  2. Creating ConnectionString with SqlConnectionStringBuilder Class in C# August 8, 2011 Reply
  3. johny August 9, 2011 Reply

Leave a Reply


x

Interesting BlogPosts to read

Event on Building intelligent bots with the Microsoft Bot Framework in Manchester
Want to learn about building intelligent bots using Microsoft's Bot Framework. Here's an interesting...
Barracuda Introduces Email Threat Scan for Microsoft Office 365
With the number of advanced threats on the rise and affecting companies of all sizes, Barracuda toda...
How to get an Enumerator from range of elements from ArrayList in C# ?
The code snippet shown in this blog post demonstrates how you can get the enumeraor from a range of ...