Wednesday, April 29, 2009

Parse SQL Connection String in C#

It is actually very easy, but not very popular
SqlConnectionStringBuilder scsb = new SqlConnectionStringBuilder(connectionString);

Then you can alter different properties for example modify timeout to 5 min from default.
scsb.ConnectTimeout = 300;

Finally to use it simply execute
scsb.ToString();

Enjoy
J.