Read connectionstring from external file

Vote:

I was wondering if there were any changes in EPiServer 7.5+ which enabled reading of connectionstrings from external files?

I have earlier created this topic http://world.episerver.com/Modules/Forum/Pages/Thread.aspx?id=76526 which was more concerned with the earlier versions of EPiServer 7.

With the implemented method described in the above topic, I get a .NET exception complaining that the SQL-profile provider cannot read the connectionstring "EPiServerDB":

Any thoughts?

Best regards

Jesper

#87348

Jun 11, 2014 10:21

Dejan Caric

Vote:

Can you show us connectionStrings element from web.config?

#87356

Jun 11, 2014 11:52

Vote:

Sure it looks like:

This is the connectionstring I want to move to an external file.

#87394

Jun 12, 2014 11:30

valdis

Vote:

Are you still adding connection string manually or you have connectionStrings.config file as source for <connectionStrings> element?

#87486

Jun 13, 2014 17:47

Vote:

I want to have an XML file containing connectionstrings for my dev, staging and prod development. In this XML file there is one setting that stores which of the connectionstrings to use.

So at the moment, we are not adding connectionstrings manually, but we are using the standard setup with a connectionstrings-file. If possible, we want to move all connectionstrings to an xml-file.

#87495

Jun 16, 2014 8:12

valdis

Vote:

How does <connectionString> element looks in web.config?

And I would recommend to use configuration file transformations to deploy correct connection string for staging or production environment - cleans up config file and this is preferred way to deal with various environments and configurations.

#87502

Jun 16, 2014 9:58

Aby Joseph

Vote:

So did you get this fixed, becasue the same thing happened when I updated to 9.7 and moved the connections strings to an external config file in the root. I also configured to use another DB for membership user management.

#145899

Mar 15, 2016 8:06