Dynamically Changing connection string in LINQ to SQL data context not working

Question

DataContext context = new DataContext("portalConnectionString-Prod");

 context = new DataContext("portalConnectionString-Test");

Is not working Why?

Answer 1

Hi erchowdary;

Please try it like this. You will need to add a reference to the dll file System.configuration.dll and the using statement:

using System.Configuration;

string connStr = ConfigurationManager.ConnectionStrings["portalConnectionString-Prod"].ConnectionString;
DataContext context = new DataContext(connStr);

  

---

Fernando (MCSD)

If a post answers your question, please click "Mark As Answer" on that post and "Mark as Helpful".

Answer 2

When you passed portalConnectionString-Test as a paramtere to data context, it considered this string as a connection string.

The problem why your DataContext didn't work is that it recieved incorrect string as a connection string. Pass the correct connection string as a value and everything will work fine.

---

Please Mark as Reply and Vote as Helpful if I helped.

Also please visit my blog http://msguy.net/