how can I swap Entity Framework connection strings easily when I test on different servers (i.e. different databases)

Question

how can I swap Entity Framework connection strings easily when I test on different servers (i.e. different databases) - at the moment it is a bit tedious going into the design parameters and trying to swap back and forth each time I change.

Answer 1

Use the ObjectContext constructor that takes a name of the app.config entry and hold several app.config entries for the necessary databases.

Answer 2

Is this a web app? If so you can use web.config transforms.