How to pass connection string to a class library?

Question

I have a project structure like

MySolution
    -FrontEnd
         -webforms
         -console
         -Mvc
    -Repositories
         -Dapper   (Class library)
    -Tests

How do I reference the connection string in my repository class library? I tried adding App.Config in my class library project but it is not available in Add New Items. I am using Visual Studio 2013 express for web. Thanks, Damien.

It's strange, check for Application Configuration File in "Add new item..." menu again. If there is none, create it manually and then include in project. Also, this question might be useful — Fedor
– Fedor, Commented Jan 27, 2014 at 7:03
@Aishvarya that does not help me as I cannot access ConfigurationManager inside my Class Library maybe because I have started from a Blank application project. — Zo Has
– Zo Has, Commented Jan 27, 2014 at 7:10
I got this answer for more or less the same question: stackoverflow.com/questions/5894153/… — Christian Wattengård
– Christian Wattengård, Commented Jan 27, 2014 at 8:20

jnovo · Accepted Answer · 2014-01-27 08:28:17Z

7

The .Config that applies to libraries is the one of the executing assembly using those libraries, so you don't have to add an App.Config to your project, it will use the App or Web.Config of your startup project.

In order to get access to the ConfigurationManager you need to add a reference to System.Configuration in your library project.

answered Jan 27, 2014 at 8:28

jnovo

5,8092 gold badges41 silver badges56 bronze badges

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

1 Comment

Zo Has Over a year ago

Thanks, for some odd reason I could not reference using ConfigurationManager, however it worked using WebConfigurationManager.

Max · Accepted Answer · 2014-01-27 12:53:12Z

3

Use web.config in the FrontEnd project. Do not use app.config in the Repositories project.

This article explains how to read the value from web.config.

http://www.connectionstrings.com/store-connection-string-in-webconfig/

answered Jan 27, 2014 at 12:53

Max

3,3582 gold badges29 silver badges31 bronze badges

Collectives™ on Stack Overflow

How to pass connection string to a class library?

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related