How can I get ConnectionString Name from config file

Question

I can read the connection strings from the config file, however I need to get the element name that is associated with connection string.

Example

<connectionStrings>
<add 
  name="LocalSqlServer" 
  connectionString="data source=.\SQLEXPRESS;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|aspnetdb.mdf;User Instance=true" 
  providerName="System.Data.SqlClient"   />
 </connectionStrings>

I need to get LocalSqlServer out of the connectionString.

Community · Accepted Answer · 2015-12-23 14:41:31Z

19

According to the documentation it should work like this:

ConnectionStringSettingsCollection connections = ConfigurationManager.ConnectionStrings;

if (connections.Count != 0)
{
    foreach (ConnectionStringSettings connection in connections)
    {
        string name = connection.Name;
    }
}

edited Dec 23, 2015 at 14:41

CommunityBot

11 silver badge

answered Jan 16, 2011 at 18:24

Martin Buberl

47.4k26 gold badges103 silver badges146 bronze badges

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

2 Comments

Saeed Amiri Over a year ago

No OP wants to get LocalSqlServer.

Martin Buberl Over a year ago

Yeah, i saw that a second after my answer. I changed it.

Aliostad · Accepted Answer · 2011-01-16 18:28:22Z

3

Use

ConfigurationManager.ConnectionStrings[0].Name

answered Jan 16, 2011 at 18:28

Aliostad

81.9k21 gold badges164 silver badges209 bronze badges

1 Comment

iBobb Over a year ago

If ConfigurationManager is not available for you, you could add it by right clicking References>Add Reference and adding System.Configuration

ktm5124 · Accepted Answer · 2011-01-16 18:28:56Z

2

You access it programmatically through the API.

http://msdn.microsoft.com/en-us/library/system.configuration.configurationmanager.connectionstrings.aspx

answered Jan 16, 2011 at 18:28

ktm5124

12.2k23 gold badges87 silver badges130 bronze badges

Collectives™ on Stack Overflow

How can I get ConnectionString Name from config file

3 Answers 3

2 Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related