Tag Archives: connection strings

“All Your Database Are Belong To Us!”

My first technical post in this blog involves a solution that my team and I implemented at work recently. The project is a .NET Web project in Visual Studio 2012.

The Problem:

Each developer on the team has a personal copy of the database for a web application. How will you store each connection string for each developer, without revealing your login information to others?

A Path to a Solution:

(A) Each developer could place their connection string in the Web.config file, without checking in their file. This is not a good choice, because they will eventually need to make other changes to the Web.config file and would have to remember to revert the connection string before each check-in. If they accidentally check in the file with their connection string, they would be sharing it with everyone.

Continue reading