Connection Strings at Run Time
If you have a scenario where you want to generate the connection string at runtime or you have the part of a connection string in config file and want to form the remaining part of it at run time. And sometimes, it’s the requirement saying not to store this kind of sensitive information in the configuration files. Using DbConnectionStringBuilder class you can achieve the same. Below are some of the useful Microsoft articles on this: http://msdn.microsoft.com/enus/library/system.data.common.dbconnectionstringbuilder(v=vs.80).aspx#Y1208 http://msdn.microsoft.com/en-us/library/ms254947(v=vs.80).aspx