在 VB.NET 中查询 LINQ to XML 源

Question

我有以下 XML，通过 XDocument.Load(uri) 或 XElement.Load(uri) 加载。我无法通过 LINQ 获取 元素的集合。

这是我尝试查询的 XML 片段：

<assetCollection xmlns="tag:aisle7.net,2009:/api/1.0">
      <title>All Assets</title>
      <description>Collection containing all assets in the system</description>
      <resourcePath>/us/assets/~all</resourcePath>
      <link rel="self" href="http://web.aisle7.net/api/1.0/us/assets/~all?apikey=1234567890&amp;Format=XML" />
      <link rel="first" href="http://web.aisle7.net/api/1.0/us/assets/~all?apikey=1234567890&amp;Format=XML" />
      <link rel="next" href="http://web.aisle7.net/api/1.0/us/assets/~all?apikey=1234567890&amp;Format=XML&amp;page=2" />
      <link rel="last" href="http://web.aisle7.net/api/1.0/us/assets/~all?apikey=1234567890&amp;Format=XML&amp;page=66" />
      <updated>2011-03-01T19:01:49.667Z</updated>
      <assets>
        <asset>
          <title>Homeopathy</title>
          <resourcePath>/us/assets/toc/homeopathy</resourcePath>
          <link rel="alternate" href="http://web.aisle7.net/api/1.0/us/assets/toc/homeopathy?apikey=1234567890&amp;Format=XML" />
          <updated>2011-03-01T19:01:49.667Z</updated>
        </asset>
        <asset>
          <title>What Is Homeopathy?</title>
          <resourcePath>/us/assets/generic/what-is-homeopathy_13615_1</resourcePath>
          <link rel="alternate" href="http://web.aisle7.net/api/1.0/us/assets/generic/what-is-homeopathy_13615_1?apikey=1234567890&amp;Format=XML" />
          <updated>2011-03-01T19:00:17.680Z</updated>
        </asset>
    ...

这是我尝试使用的代码：

Dim uri As String = HttpUtility.UrlDecode(ConfigurationManager.AppSettings("Aisle7_Index_Url"))

Dim assets = (From a In XElement.Load(uri)
                               .Element("assets")
                               .Elements("asset")
             Select a)

For Each asset In assets
  Console.WriteLine(asset)
Next

Answer 1

尝试

Dim assets = From a In XElement.Load(uri).Descendants("asset") Select a

或

Dim assets = From a In XDocument.Load(uri).Root.Element("assets").Elements("asset") Select a

Answer 2

这是使用 xml 文字语法的版本：

Dim xml = XElement.Load(uri)
Dim q = From a In xml.<assets>...<asset> 
        Select a