Deployment to different envoironments

Topics: Customizing Orchard, General, Installing Orchard
Jan 7 at 5:33 PM
Hello,
What is best practice when deploying to multiple environments (dev, stage, prod) in Orchard?

In my regular MVC - projects I am using web.config transformations when I want to deploy to different environments and have different connections string per environment. This works great but as what I can see Orchard is using settings.txt to store db connection settings?

How can I deploy from VS and use web.config transformations?

Also, Using VS publish/deploy might not be the way to go here with Orchard?