Linq to XML 查询返回字符串列表

Question

我有以下类

public class CountrySpecificPIIEntity
{
    public string Country { get; set; }
    public string CreditCardType { get; set; }
    public String Language { get; set; }
    public List<String> PIIData { get; set; }        
}

我有以下 XML，我想使用 Linq-to-xml 进行查询并将其整形为上面的类

            <?xml version="1.0" encoding="utf-8" ?>
            <piisettings>
              <piifilter country="DE" creditcardype="37" language="ALL" >
                <filters>
                  <filter>FIRSTNAME</filter>
                  <filter>SURNAME</filter>
                  <filter>STREET</filter>
                  <filter>ADDITIONALADDRESSINFO</filter>
                  <filter>ZIP</filter>
                  <filter>CITY</filter>
                  <filter>STATE</filter>
                  <filter>EMAIL</filter>
                </filters>
              </piifilter>
              <piifilter country="DE" creditcardype="37" Language="en" >
                <filters>
                  <filter>EMAIL</filter>
                </filters>
              </piifilter>
            </piisettings>

我正在使用以下查询，但我在最后一个属性（即 PIIList）上遇到了问题。

            var query = from pii in xmlDoc.Descendants("piifilter")
            select new CountrySpecificPIIEntity
            {
               Country = pii.Attribut("country").Value,
               CreditCardType = pii.Attribute("creditcardype").Value,
               Language = pii.Attribute("Language").Value,
               PIIList = (List<string>)pii.Elements("filters")
            };

            foreach (var entity in query)
            {
            Debug.Write(entity.Country);
            Debug.Write(entity.CreditCardType);
            Debug.Write(entity.Language);
            Debug.Write(entity.PIIList);
            }

如何获取查询以返回要合并到 PIIList 属性中的列表。

Answer 1

var query = from pii in xmlDoc.Descendants("piifilter")
select new CountrySpecificPIIEntity
{
   Country = pii.Attribut("country").Value,
   CreditCardType = pii.Attribute("creditcardype").Value,
   Language = pii.Attribute("Language").Value,
   PIIList = pii.Elements("filters").Select(xe => xe.Value).ToList();
};

Answer 2

我不确定，你能检查一下你的类定义吗？

public List<String> PIIList { get; set; }

如果这是正确的，那么试试这个：

select new CountrySpecificPIIEntity
{
 Country = pii.Attribute("country").Value,
 CreditCardType = pii.Attribute("creditcardype").Value,
 Language = pii.Attribute("Language").Value,
 PIIList = pii.Elements("filters").Cast<string>().ToList()
}