c# - 如何从配置文件中获取 ConnectionString 名称

Question

我可以从配置文件中读取连接字符串，但是我需要获取与连接字符串关联的元素名称。

例子

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

我需要从 connectionString 中获取 LocalSqlServer。

Answer 1

根据documentation它应该像这样工作:

ConnectionStringSettingsCollection connections = ConfigurationManager.ConnectionStrings;

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