I have a database in a production server with a rather simple structure that I use to generate Context and Model. I have a sandbox server in which I restore the database from a backup that I use for testing.

I wonder what the best approach is to switch between the two servers, ideally they would use the same EF project and just have different connection strings. I just do not get how to make that work.

Alternatively I could have 2 separate (identical) EF projects and instatiate the context that i need at runtime. I'm ,not too hot about this because in the future my database structure might change a lot, and I don't think regenerating 2 EF projects rather than one is such a good idea.

Or am I just not using the right technology? :)