How to access a connection string from within a library

Question

I have a web project (mvc) and data access layer in a separated class library project. I need to access to a connection string in app.config which sits in that library project.

ConfigurationManager.ConnectionStrings[0].ConnectionString pulls something strange. I don't have this kind of settings neither in the library's config nor in the web project's config files.

the App.config looks like that:

<?xml version="1.0" encoding="utf-8" ?>
 <configuration>
  <connectionStrings>
   <add name="DALConnectionString" connectionString="User ID=sa;Password=pass;Initial     Catalog=db;Data Source=srv\SQL2005;" />
 </connectionStrings>
</configuration>

Unmesh Kondolikar · Accepted Answer · 2011-03-07 16:41:51Z

7

Your library should use dependency injection in this case for inversion of control.

Your class in the data access layer (DAL) library should take the connection string as a constructor argument or a property value.

This will make sure that your DAL can be used in other projects also and is not tied to your your mvc web application.

Let the code which will consume the DAL read the connection string from the config file and inject it into your class's constructor.

answered Mar 7, 2011 at 16:41

Unmesh Kondolikar

9,2924 gold badges41 silver badges53 bronze badges

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

Comments

Joe Ratzer · Accepted Answer · 2011-03-07 16:42:49Z

5

By default, a class library can't access a config file.

The client of the class library, in this case your web project, can provide config settings.

Therefore, put all the relevant settings, the connection strings, in the web's config file. The ConfigurationManager code in the class library will use the web projects config settings.

answered Mar 7, 2011 at 16:42

Joe Ratzer

18.6k3 gold badges40 silver badges52 bronze badges

Comments

Davide Piras · Accepted Answer · 2011-03-07 16:37:05Z

0

you should add the fragment shown above in the web.config then at runtime the configuration manager will use it even if running inside your class library.

answered Mar 7, 2011 at 16:37

Davide Piras

44.7k10 gold badges103 silver badges150 bronze badges

Comments

Aliostad · Accepted Answer · 2011-03-07 16:37:42Z

0

You cannot access a app.config for a DLL.

app.config only works for the entry point assembly or web.config for a web project.

Try copying the connection to the entry point config or load the config by parsing the configuration XML - not recommended.

answered Mar 7, 2011 at 16:37

Aliostad

81.9k21 gold badges164 silver badges209 bronze badges

Collectives™ on Stack Overflow

How to access a connection string from within a library

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related