Changing the Connection String of LINQ dmbl programmaticaly

Question

I have two seperate databases, one is production the other is test. Before LINQ, I could simply change the connection string to swtich db's. However, the string is read only, and I have no way to change the string.

How can I change the Connection String programmatically?

Edited for Clarity

Im using my.settings to store all of this inforomation

Chris Shaffer · Accepted Answer · 2009-06-02 16:13:46Z

2

The DataContext object should have a constructor that takes a Connection String as a parameter. Alternatively, the default behavior is to pull it from the config file, so you can change it in the app.config/web.config file.

answered Jun 2, 2009 at 16:13

Chris Shaffer

32.6k5 gold badges52 silver badges61 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Aaron M · Accepted Answer · 2009-06-04 21:46:36Z

0

I found a simple solution to the problem. Change the type from connection string to string, and set the Scope back to user.

Works just like it did before.

This does cause a different problem through. any time the dmbl file is updated, it causes an issue with the underlying vb file. the workaround I am using is to create a new contructor and make sure that the connection string is being pointed to properly

edited Jun 4, 2009 at 21:46

answered Jun 2, 2009 at 16:31

Aaron M

2,5931 gold badge23 silver badges38 bronze badges

Collectives™ on Stack Overflow

Changing the Connection String of LINQ dmbl programmaticaly

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related