Manipulating connection strings
Every once in a while I see devs struggling with connection strings. As a rule they seem inclined to use string concatenation, string.Replace or even string.SubString In case you didn't know here is the correct way to do it: SqlConnectionStringBuilder