如何从Web.config XML文件获取属性值

Question

我有一个web.config文件，我想检索特定键名的连接字符串值。

<connectionStrings> 
     <add name="abc" connectionString="Server=(local);Initial Catalog=abc;Integrated Security=SSPI;Max Pool Size=25" providerName="System.Data.SqlClient" /> 
     <add name="cde" connectionString="Server=(local);Initial Catalog=cde; Integrated Security=SSPI;Max Pool Size=50" providerName="System.Data.SqlClient" /> 
    </connectionStrings> 

我知道我可以通过配置管理器获取连接字符串，但我想通过XML阅读器来获取。目前我正在使用

XDocument document = XDocument.Load(fullPath); 
var connectionString = from c in document.Descendants(connectionStrings) 
select c ; 

我得到了两个连接字符串。但我想获得特定的“abc”连接字符串。你能帮我解决吗？

Answer 1

XDocument document = XDocument.Load(fullPath); 
var connectionString = from c in document.Descendants("connectionStrings").Descendants("add") 
    where c.Attribute("name").Value == "abc"     
    select c; 

Answer 2

试试这个

XDocument document = XDocument.Load(fullPath); 
var connectionString = from c in document.Descendants("connectionStrings") 
         where c.name=="abc"    
         select c ; 

Answer 3

的替代（用少量流利语法）

var connectionString = document.Descendants("connectionStrings") 
         .Descendants("add") 
         .First(x => x.Attribute("name").Value == "abc").Attribute("connectionString").Value;