ASP.NET MVC Apply web.config transformss on "Publish"

I'm using VS2010 and I have a Web appl开发者_StackOverflowication that I deploy using the "Publish" command.

I have defined a couple of transformations in the Web.Release.Config file to change the connection string and other settings that need to change in the "live" server.

The problem I'm seeing is that when I execute the "Publish" command it doesn't apply the transformations defined in the web.release.config file.

Any idea on how to achieve this?

Thanks

---

On visual studio, there should be a select box top on the menu. You need to select the type of your build (Release, Debug, etc.).

Something like below :

Be careful that it is set to Release.