How can I switch between 2 Connection Strings in my Web.Config (Activate one for DBML)
- by Alex
Hello!
I have two connection strings (both in Web.Config: CS_Local and CS_Production) for my DBML (Linq to SQL).
In my Global.Asax/Application_Start I run some production preparation methods if the request is non-local (!HttpContext.Current.Request.IsLocal). Within that part, I'd also like to change the current connection string used by my DBML from the standard CS_Local to CS_Production.
How would I do that? Some help please..