Loading connection strings from class library in web application

Question

I have a fairly straightforward problem that I imagine has a simple solution. However, it's not clear to me. Here's the problem:

I have a web application that references a class library. That class library needs to access the connection strings in the web.config. From what I've read, this shouldn't be a problem.

Here's the code that I'm using to access the connection strings:

Dim connectionStrings As ConnectionStringSettingsCollection = ConfigurationManager.ConnectionStrings

When I run this code in the web application, I get all of my connection strings back. However, when this exact same code is run in the class library (called from the web application), it reverts to the machine.config for some reason and gets the entry from there. i.e.

data source=.\SQLEXPRESS;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|aspnetdb.mdf;User Instance=true

I'm not sure if it matters or not, but the web side of this is a WCF RIA services web site that backs a Silverlight application. I didn't see anything funny in the config that could justify this strange behavior. Any thoughts on why I'm seeing this behavior?

Thanks,
Matt

This question may be related to your problem: stackoverflow.com/questions/4939577/… — patmortech
– patmortech, Commented Apr 11, 2011 at 3:51
@patmortech - I don'tn think this is the sae problem. The author states, "If I paste the connection string back into the Web.Config it all works just fine", however, this is not the case for me (I would happily accept the situation if it were and Consider this questions resolve. Any other thoughts? — Matt Ruwe
– Matt Ruwe, Commented Apr 12, 2011 at 11:01

Ricky · Accepted Answer · 2011-04-11 01:30:58Z

0

There's a "WebConfigurationManager" Class, I guess it may solve your problem.

answered Apr 11, 2011 at 1:30

Ricky

10.8k3 gold badges29 silver badges31 bronze badges

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

1 Comment

Matt Ruwe Over a year ago

Thank you for your answer. I should've mentioned that my class library references the entity framework, which uses the ConfigurationManager internally, so using the WebConfigurationManager is not an option. The class library shouldn't know anything about web environment anyway, so that would probably not be a good solution anyway.

Collectives™ on Stack Overflow

Loading connection strings from class library in web application

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related