Is there any way to override the SqlDataAdapter's (or the Server Explorer's) annoying tendency to replace any connection to a database connection to localhost\sqlexpress with 'machine name'\sqlexpress?

While we are overriding it at runtime based upon configuration, in design mode, creating a new data adapter creates new SqlConnection object which it really doesn't need, even though there is an existing connection configured for localhost\sqlexpress.

Andrew Raymond