use a different connection string

Go to solution

Press Ctrl / CMD + C to copy this to your clipboard.

Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at

Donatello 5 posts 44 karma points

Mar 18, 2015 @ 15:35

0

Use a different connection string

Using Umbraco 7

Hi

We're trying to have Umbraco use a connection string we pass it from the code. Reason being, we get the connection string from outside of the web.config and we can't change this constraint.

Is it possible to do this? We are not allowed to modify the web.config from the source code as well so editing it from the code to add the UmbracoDbDSN parameter is not an option...

Thanks

Copy Link

Alex Skrypnyk 6132 posts 23951 karma points MVP 7x admin c-trib

Mar 18, 2015 @ 16:44

Hi Donatello,

Welcome to our community,

Try to look at this code :

Configuration config = ConfigurationManager.OpenExeConfiguration(ConfigurationUserLevel.None);
config.AppSettings.Settings["umbracoDbDSN"].Value = “New Connection String”;
config.Save(ConfigurationSaveMode.Modified, true);
ConfigurationManager.RefreshSection("appSettings");

Thanks, Alex

Copy Link

Donatello 5 posts 44 karma points

Mar 18, 2015 @ 16:57

0

Hi Alex

thanks a lot for your help.

We've tried and used this successfuly but we are unfortunately not allowed to modified the web.config file anymore...so this solution couldn't work for us.

Copy Link
Alex Skrypnyk 6132 posts 23951 karma points MVP 7x admin c-trib

Mar 18, 2015 @ 17:07

0

Looks like here is solution of your problem - https://our.umbraco.org/forum/developers/api-questions/56150-Connection-string-in-code

Copy Link
Donatello 5 posts 44 karma points

Mar 18, 2015 @ 19:30

100

Spent some time testing this solution as well but whichever way I try to access the configuration it is read only (ApplicationContext.DatabaseContext.Database.Connection.ConnectionString is readonly)

What I was hoping for was a way to hook up in the Umbraco database layer initialization and being able to "inject" a different connection string. But looking at the Umbraco source code, it doesn't seem to be feasable...any suggestion would be appreciated.

Copy Link
NAGENDRA 2 posts 71 karma points

Feb 11, 2020 @ 21:08

0

Hi Donatello,

just want check with you, did you find any way to resolve your issue. I'm also facing the same issue.

Thanks, Nagendra

Copy Link
is working on a reply...

Please Sign in or register to post replies

Flag this post as spam?