When working with SQL files in a VB.Net project, how can the connection parameters be saved for easier development?
There are SQL files in the project, to hold queries for use in the app. When one of the files is opened for editing & testing, the credentials & properties must be entered again - every time!
See screenshot below.
Anything in the Connect
and Advanced Properties
windows is lost each time the file is closed. The credentials are very long, so they must be copied & pasted, and some connection properties need to be set. To redo these every time is annoying & inconvenient.
How can the credentials & properties be saved in the project? (if possible)
Sidenote: I do understand credentials should not be hard-coded into the project, so that need not be discussed. This is just for development, and eventually I will harden it up so the credentials will not be in the project.