Where to set MVC 3 Connection Strings in code

Question

I would like to connect to an existing database, and I put the connection string in the ConnectionStrings section of the Web.Config. But where and how do you refer to this connection in the code. For example, I try things like

string connString = System.Configuration.ConfigurationManager.ConnectionStrings["MyDatabase"].ToString();

in my C# code right before I read the database.

The only way I can make it work is to hard-code the connection string in the C# code, because I don't know how to get it from Web.Config.

Why didn't the snippet you posted work?

Ahmed
– Ahmed

2011-05-24 21:23:47 +00:00
Commented May 24, 2011 at 21:23 — Ahmed
– Ahmed, Commented May 24, 2011 at 21:23

bkaid · Accepted Answer · 2011-05-24 22:27:09Z

1

That code you have is correct (i fixed one small typo with it). Make sure you add a reference to System.Configuration to your project. And obviously make sure that "MyDatabase" exists as a connection string in the project's web.config.

edited May 24, 2011 at 22:27

answered May 24, 2011 at 21:50

bkaid

52.2k23 gold badges115 silver badges128 bronze badges

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

Collectives™ on Stack Overflow

Where to set MVC 3 Connection Strings in code

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related