How to use connection string stored in web.config to formulate MySQL connection query in ASP .NET Razor MVC

Question

I'm successfully able to connect to my database with the following method, however I have a connection string stored in my web.config that I obviously would rather use than this way where the credentials are exposed in code. However I haven't found a good way to do this. WebMatrix gives me a fatal connection error of 18 and I don't know how else I can do this off the top of my head.

Any ideas?

David · Accepted Answer · 2018-05-31 11:58:34Z

2

You can read the connection string from Web.config with something like this:

System.Configuration.ConfigurationManager.ConnectionStrings["someName"].ConnectionString;

which returns a string, just like myBuilder.ConnectionString does. So you can use it directly in place of what you have:

string connString = ConfigurationManager.ConnectionStrings["someName"].ConnectionString;
MySqlConnection myconn = new MySqlConnection(connString);

answered May 31, 2018 at 11:58

David

221k42 gold badges246 silver badges338 bronze badges

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

7 Comments

sushi7777 Over a year ago

hey david. I tried that and I'm getting "Unable to connect to any of the specified MySQL hosts.' SocketException: No such host is known" on myconn.Open();

sushi7777 Over a year ago

This is how it looks in the config. <connectionStrings> <add name="jj_booking_system" connectionString="server=rds-booking-system.andtherestoftheendpoint.com,3306;database=jj_booking_system;uid=saydin;pwd=somepassword" providerName="System.Data.SqlClient" /> </connectionStrings>

David Over a year ago

@sushi7777: When you debug, have you confirmed that it's finding the right connection string from the config? If the connection string is correct and it can't connect then, well, it can't connect.

sushi7777 Over a year ago

server=rds-booking-system.andtherestoftheendpoint.com,3306;database=jj_booking_system;uid=saydin;pwd=somepassword is literally what is in the connString variable. Bear in mind the above screenshot works fine...

David Over a year ago

@sushi7777: In your original working version, what was the runtime value for myBuilder.ConnectionString? Was it identical to the new runtime value?

|

Collectives™ on Stack Overflow

How to use connection string stored in web.config to formulate MySQL connection query in ASP .NET Razor MVC

1 Answer 1

7 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

7 Comments

Your Answer

Sign up or log in

Post as a guest

Related