How to read <connectionstring> of web.config from a console application?

Question

I have VB.net console application. I would like to read the (ConnectionString) from a web.config.

Web.config is located at a particular path in my virtual PC, say "C:/mywebConfig"

<add name="MY_DB" connectionString="Data Source=DATASOURCE;Initial Catalog=DB;Persist 

Security Info=False; User ID=***;Password=****;" providerName="System.Data.SqlClient" />

My code:

Dim connString As String = String.Empty

connString = ConfigurationManager.ConnectionStrings("MY_DB").ConnectionString

Whenever I try to access it, i get the error not set to an instance of an object or something like that :)

Help please.

I tried to add the web.config in my Project, but still get the error.

Felipe Miosso · Accepted Answer · 2016-11-13 14:41:38Z

2

If you do indeed want to read the app.config or web.config of another (web) app, take a look at ConfigurationManager.OpenMappedExeConfiguration.

edited Nov 13, 2016 at 14:41

Felipe Miosso

7,3396 gold badges46 silver badges56 bronze badges

answered Dec 20, 2011 at 9:57

Arnout

2,79014 silver badges12 bronze badges

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

Comments

Mike · Accepted Answer · 2011-12-20 10:00:04Z

0

As Matt suggested for a console app you need to include a app.config file instead. For easy reading of that file you can reference the System.Configuration assembly and then use the System.Configuration.ConfigurationManager.ConnectionStrings property.

For example:

string connectionString = System.Configuration.ConfigurationManager.ConnectionStrings["dbconnectionString"].ConnectionString;

EDIT

I've just re-read your post and it might be a good idea to check your app has permission to read .config files from the c:\ drive.

edited Dec 20, 2011 at 10:00

answered Dec 20, 2011 at 9:53

Mike

6715 silver badges10 bronze badges

Comments

Community · Accepted Answer · 2017-05-23 12:13:42Z

0

web.config is used for web applications - you will need a app.config file.

Have a look at this link for the differences:

dotNET - app.config and web.config

Also this stack overflow question what is app.config for

edited May 23, 2017 at 12:13

CommunityBot

11 silver badge

answered Dec 20, 2011 at 8:54

Matt Wilko

27.4k10 gold badges99 silver badges146 bronze badges

Collectives™ on Stack Overflow

How to read <connectionstring> of web.config from a console application?

3 Answers 3

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related