A DB Connection question

[chispavip]

A good programming technique is not to leave a static connection string, because it could be modified dynamically, and this way we void re-compile the code with the new string.

The problem merge when we use some wizards, the components ask for a connection and it should be done in a static way, so my questions is:

How can I change my connection string of my datasource if I created using the wizards?

 

[jmeckley]

what is the "wizard"? it sounds like your using a 3rd party app to generate code based on a db. Much like an OR Mapper. or generating strongly typed dataset.

you want to map the connection string to the app.config file (or web.config if it's an asp.net project). this will allow you to change the connection string without re-compiling the code.

if your using .net 2.0 you can encrypt the connection string so others cannot read the information in the config file.

if your not using 2.0 you'll either need to hard code the values in the system, or store the data in the registry.(this is what MS recommends for security, but i've never gone that far).

Jason Meckley
Programmer
Specialty Bakers, Inc.