All of this is entirely up to you as to how you would like to pull the connection string. Since the connection has to be manually specified anyway, it is really easy to have it pull from a config file or some other file. You can also place a test to determine which server you are on. If you host names will be different then you could just use the host name and test on that within the global.asax when defining the connection string.For example, the following code would look to see if the subdomain was different and create a connection based on that:
Dim lcHost As String = Request.Url.Host
Dim lcSubDomain As String = lcHost.Split(New Char() {"."c})(0)
'-- Set the session type
If lcSubDomain.Equals("www", StringComparison.OrdinalIgnoreCase) Then
DataBasics.DataSources.Add(New MicroFour.StrataFrame.Data.SqlDataSourceItem("", "connectionstring1"))
ElseIf lcSubDomain.Equals("support", StringComparison.OrdinalIgnoreCase) Then
DataBasics.DataSources.Add(New MicroFour.StrataFrame.Data.SqlDataSourceItem("", "connectionstring2"))
End If