ConnectionString management for many projects on one server, should I make my own ConnectionString provider for our code

Question

I have on a single Windows Server about 10 different .NET projects, mostly .NET 4.0 but some .NET 2.0

Some of these projects are asp.net, some are background utilities/services.

These projects interact with over a hundred different databases in our infrastructure. The ConnectionStrings they use to do that changes at least a few times a month.

The issue here is that forgetting to put a ConnectionString in one of these projects can cause a lot of problems, and new projects/updates are deployed to the server all the time by many different programmers.

My new attempt at a solution is to override the System.ConfigurationManager class in all projects and replace it with my own implementation that reads from a shared config file that I can maintain. Then I would just recompile each project once and deploy it.

I could also try to maintain the ConnectionStrings in the machine.config file that's shared between all projects, but I would have to do it for every version of the .NET framework used by a project which is at least three, and making a mistake in this file seems like it could be dangerous.

Does anybody have a recommendation of which way to proceed?

Thanks.

Andre Calil · Accepted Answer · 2018-12-05T17:31:12.120

5

Besides the machine.config, you can create common appSettings files. You won't need to develop anything new, just place your shared settings on this file and reference it on your specific config files.

Hope this helps.

Since the link is dead, here's a couple examples.

To fully load a section from an external file:

<connectionStrings configSource="ConnectionStrings.config" />

To complement a section from an external file (+ what's in the section itself):

<appSettings file="FileService.config">
...
</appSettings>

edited Dec 05 '18 at 17:31

answered Jul 06 '12 at 13:38

Andre Calil

7,652
34
41

I've tried this for web.config files before and it seems to restrict the use of external config files to ones found in the same directory or subdirectories only, unless I'm mistaken. – Ryan Weir Jul 06 '12 at 19:49
Nope, take a look at the link I've provided. You can have a dir such as C:\OneConfigToRuleThemAll\TheOne.config, and the rest could be at wwwroot or wherever. – Andre Calil Jul 06 '12 at 19:54
Thanks! This looks like exactly what I need to get this under control. – Ryan Weir Jul 06 '12 at 20:26
Link is dead.. :( – BeanFlicker Dec 05 '18 at 15:53

score 0 · Answer 2 · answered Jul 06 '12 at 13:37

0

Between the machine.config and the other solution there are the ALIAS. The limitation here is : it will do only for sql server.

answered Jul 06 '12 at 13:37

tschmit007

7,559
2
35
43

I'm trying to limit the fallout of this change to where the connection strings are retrieved and looks like doing it your way would involve other changes to how databases connections are established in code. Also I have several other database types than SQL Server. Thanks anyway. – Ryan Weir Jul 06 '12 at 19:38

ConnectionString management for many projects on one server, should I make my own ConnectionString provider for our code

2 Answers2

Linked