CODEWITHSUNDEEP
c#
user9969
user9969

Reputation: 16040

How can I get ConnectionString Name from config file

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.

Upvotes: 9

Views: 12906

Answers (3)

Martin Buberl
Martin Buberl

Reputation: 47114

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;
    }
}

Upvotes: 19

ktm5124
ktm5124

Reputation: 12123

You access it programmatically through the API.

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

Upvotes: 2

Aliostad
Aliostad

Reputation: 81660

Use 

ConfigurationManager.ConnectionStrings[0].Name

Upvotes: 3

Related Questions