Do you change connection string manually while deploying to different environments or do you create connection strings dynamically based on URL?
I check URL to see the environment and use the connection string accordingly. Is there a better way to avoid changing them manually?