Auto Encryption of web.config connection string

Question

I want to encrypt the connection string in web.config, the problem is each time a developer changes the connection string in web.config and publishes, it needs to be encrypted every time in the web server. Is there any way that the connection string can encrypted automatically every time someone publishes it?

Note :- All of us work on our local machines other than the server. So encryption using local machine key is not an option.

Answer 1

Check for the web deployment project option below is link of the whole article

http://weblogs.asp.net/scottgu/archive/2005/11/06/429723.aspx