将 Linq 对象实例化为 XML 查询

Question

我有以下类，

public class CountrySpecificPIIEntity
{
 public string Country { get; set; }

 public string CreditCardType { get; set; }

 public String Api { get; set; }

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

我尝试使用 linq to XMl 查询来创建 CountrySpecificPIIEntity 类型的实例列表。 XML 如下：

<piisettings>
 <country countrycode="DE">
  <creditcardype credicardtype="mastercard">
   <api api="INSERT_FILTERS">
    <filters>     
     <filter>FIRSTNAME</filter>
     <filter>HOUSENUMBER</filter>
     <filter>ADDITIONALADDRESSINFO</filter>
     <filter>EMAIL</filter>
    </filters>
   </api>
  </creditcardype>
  <creditcardype credicardtype="visa">
   <api api="INSERT_FILTERS">
    <filters>
     <filter>STATE</filter>
     <filter>EMAIL</filter>
    </filters>
   </api>
  </creditcardype>
  <creditcardype credicardtype="visa">
   <api api="UPDATE_FILTERS">
    <filters>
     <filter>STATE</filter>
     <filter>EMAIL</filter>
    </filters>
   </api>
  </creditcardype>      
 </country>
 <country countrycode="GB">
  <creditcardype credicardtype="americanexpress">
   <api api="INSERT_FILTERS">
    <filters>
     <filter>STREET</filter>
     <filter>ZIP</filter>
     <filter>CITY</filter>
     <filter>STATE</filter>
     <filter>EMAIL</filter>
    </filters>
   </api>
  </creditcardype>
  <creditcardype credicardtype="debank">
   <api api="INSERT_FILTERS">
    <filters>
     <filter>IPADDRESSCUSTOMER</filter>
     <filter>FIRSTNAME</filter>
     <filter>SURNAME</filter>
     <filter>HOUSENUMBER</filter>
     <filter>STREET</filter>
     <filter>ZIP</filter>
     <filter>CITY</filter>
     <filter>STATE</filter>
     <filter>EMAIL</filter>
    </filters>
   </api>
  </creditcardype>
 </country> 
</piisettings>

Linq to XML 查询应该是什么？

Answer 1

怎么样：

    var qry = from country in XElement.Parse(xml).Elements("country")
              from cc in country.Elements("creditcardype")
              let api = cc.Element("api")
              select new CountrySpecificPIIEntity
              {
                  Country = (string)country.Attribute("countrycode"),
                  CreditCardType = (string)cc.Attribute("credicardtype"),
                  Api = (string)api.Attribute("api"),
                  FilterList = new List<string>(
                      from filter in api.Element("filters").Elements("filter")
                      select filter.Value)
              };