Read ConnectionString from Application Settings in Web.config

Question

I'm working on a .NET Framework 4.5.2 legacy application.

I need the plain ConnectionString of my application, but I don't know how to read it.

Unfortunately the Web.config file of the app, does not have a section "connectionStrings".

Instead, in the Web.config file, there is a section "applicationSettings" which contains the necessary parameters:

<applicationSettings>
  <MyApp.Properties.Settings xdt:Transform="Replace">
    <setting name="Url" serializeAs="String">
      <value>myapp.com</value>
    </setting>
    <setting name="User" serializeAs="String">
      <value>admin</value>
    </setting>
    <setting name="PW" serializeAs="String">
      <value>Password1</value>
    </setting>
    <setting name="Domain" serializeAs="String">
      <value>Fruits</value>
    </setting>
    <setting name="Port" serializeAs="String">
      <value>123</value>
    </setting>
    <setting name="UseSSL" serializeAs="String">
      <value>True</value>
    </setting>
  </MyApp.Properties.Settings>
</applicationSettings>

I need the plain connection string as a text in notepad - because I need to store the connectionstring in my Azure DevOps environment.

Do you know how to retrieve the connectionString?

By any chance, do you know how to solve this issue?

If you have a code. Why don't you look into the code from where it is reading connection string. Moreover is it a Web application. We can also check in Machine Config. — शेखर
– शेखर, Commented Apr 5, 2022 at 15:04

dredg87 · Accepted Answer · 2022-04-05 14:47:41Z

I'm not sure if I understood correctly your problem, but I think you should be able to use the ConfigurationManager.AppSettings property to read the values from the Web.config file.

But instead I would add the connection string inside the Configuration section (in the Web.config), like this:

<?xml version="1.0" encoding="utf-8" ?>  
<configuration> 
..
<connectionStrings>  
      <add name="MyConnection" connectionString="Data Source=.\SQLEXPRESS;Initial Catalog=MyDatabase;Integrated Security=True;Pooling=False" />
</connectionStrings>    
<appSettings>
 ..
</appSettings>

Then is just a matter to get the connection from the ConnectionStrings property: ConfigurationManager.ConnectionString["MyConnection"], and that's it.

If you need further information can see the following links:

https://learn.microsoft.com/en-us/dotnet/api/system.configuration.configurationmanager.connectionstrings?view=dotnet-plat-ext-6.0

https://learn.microsoft.com/en-us/dotnet/api/system.configuration.configurationmanager.appsettings?view=dotnet-plat-ext-6.0

M Rizwan · Accepted Answer · 2022-04-06 05:39:43Z

0

To retrieve the connectionString you can use the following code

string cn=ConfigurationManager.ConnectionStrings[yourConnectionStringName].ConnectionString;

answered Apr 6, 2022 at 5:39

M Rizwan

1088 bronze badges

Collectives™ on Stack Overflow

Read ConnectionString from Application Settings in Web.config

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related