如何使用Linq轻松解析XML - 需要一些示例代码[关闭](How to use Linq to parse through XML easly - Need some sample code [closed])

 我在我的SQL Server中使用XML Auto来查询数据。 我想知道如何最好地解析它提供的数据。 
 
 我的最终目标是提供带有值的项目列表，但我不知道有多少列或列的名称将至少在运行时从SQL中提取数据。 
 
 这是一个示例XML 
 
  <animals>
    <animal name="Pig">
      <meat>
        <name>Prosciutto</name>
      </meat>
      <meat>
        <name>Speck</name>
      </meat>
    </animal>
    <animal name="Cow">
      <meat>
        <name>Clod</name>
      </meat>
      <meat>
        <name>Brisket</name>
      </meat>
      <meat>
        <name>Tri-tip</name>
      </meat>
    </animal>
    <animal name="Chicken">
      <meat>
        <name>Drumstick</name>
      </meat>
    </animal>
  </animals>
 
 如何在列表中显示，并执行Linq2SQL（或Linq2XML）？ 

I am using XML Auto in my SQL Server to query data out. I want to know how best to parse through the data that it provides.
 
My end goal is to provide a list of items with their values, but I don't know how many columns or what the names of the columns will be until at least the data is pulled form SQL at runtime.
 
Here is a sample XML
 
  <animals>
    <animal name="Pig">
      <meat>
        <name>Prosciutto</name>
      </meat>
      <meat>
        <name>Speck</name>
      </meat>
    </animal>
    <animal name="Cow">
      <meat>
        <name>Clod</name>
      </meat>
      <meat>
        <name>Brisket</name>
      </meat>
      <meat>
        <name>Tri-tip</name>
      </meat>
    </animal>
    <animal name="Chicken">
      <meat>
        <name>Drumstick</name>
      </meat>
    </animal>
  </animals>
 
How can I show this in a list, and perform Linq2SQL (or Linq2XML)?

原文：