>Hi,
>
>I'm using the Entity Framework to access a local SQLServer database with a bunch of methods using the ObjectContext as generated by the designer.
>
>I'd like to be able to use the same methods against an ObjectContext generated from an identical database on a different server but can't see how it can be done.
>
>Is it possible? Any suggestions?
>TIA,
>Viv

It's been some time, but I did try this a couple of months ago and never quite figured it out. What I did learn at that time is that you cannot change the connection string once the first connection has been done in objectcontext. I could only create a connection by creating an entirely new instance of the objectcontext and I had to let go the entities first. I also ran into problems when the objectcontext went out of scope because the disposing of the objectcontext happens but the database connection didn't close. I had to clear all connections manually. Had something to do with pooling and I think it can be turned off if I remember correctly. If you want, I can look for my code but you're probably further along than I ever got with it.

I never got past that I am interested if you learn of a way to do it. I was working with the entity framework for my own research, not for work so I didn't have a lot of time to work on it.