What is the best approach to allow users to configure database connections? The connection could either be SQL or Oracle. I'm building a WPF desktop application. Ideally this is the type of setting that is configured once and then forgotten about.
Some ideas I've had-
- Just have a config file and have the user edit the connection string in there.
- Have a configuration/connection tab in my application and have the user enter a connection string.
- Have a configuration/connection tab in my application and user enters user name, password, server, etc all in different fields and I build the connection string.
- YOUR IDEA HERE :-)