Could somone explain the process of using the Database Connection menu?

I understand there is an encryption of the connection information, but how does this tie into the APP_CONNECTION_KEY,APP_CONNECTION_DATABASE,APP_CONNECTION_TITLE?

I see that the GettingConnectionSting, static method, gets called that references the above constants, but do you have to manually change the constants, or does the Connection Menu do this?

The connection string management works like this:



All connection strings are stored by a "key." When you want to retrieve the connection string, you tell the GetConnectionString static method the "key" you want to use. That key is the APPLICATION_KEY constant. If you don't have a connection string for the given key, the manager displays the wizard asking you to configure one. So, if you want to have several applications use the same connection string, give them all the same APPLICATION_KEY. When you create a new application, the APPLICATION_KEY constant is just set to the name of the project.



Also, if it's an internal application and you don't want to use the connection string management, you can just replace the call to the static GetConnectionString method and hard-code your own connection string (bad programming practice, shame on me for mentioning it ).