I now have to decide at design time to which database I am going to connect and this is stored in constant. Which means I have to restart the app everytime I want to change.
In my application I connect to +/- 30 Different databases that all have exactly the same schema.
I would like the path, username and password to be added to the activity properties, so I can set them in runtime.
Hi Edwin,
I agree with your thoughts. I also always prefer using variables with parameterized queries in my External Database Connector. It's the safest and most maintainable way to interact with external databases.