linq到xml遍历结果(linq to xml iterate through results)

 我是新手使用linq特别是linq到xml，我很难尝试迭代结果。 我的xml文档有多个同名的节点嵌套在单个父节点中，我使用了以下linq查询，它返回正确的结果集。 
 
var listingAgentElements = from p in _xElement.Descendants("commercial") select p.Elements("listingAgent");
 
 我的xml具有以下格式： 
 
<commercial>
    <listingAgent id="1">
    <listingAgent id="2">
    <listingAgent id="3">
 </commercial>       
 
 我得到一个包含所有列表代理的结果集，虽然由于某种原因，当我尝试对listingAgentElements执行以下foreach循环时，我尝试循环的每个元素似乎具有完全相同的结果集，仍然具有所有三个listingAgents： 
 
foreach (var element in listingAgentElements)
{
    var test = element;
}
 
 每个listingAgent都有一组子元素，我想循环并获取存储在数据库中的值，因为我正在做一个xml导入控制台应用程序。 
 
 看来他们可能是查询的问题，但我真的不确定，有人可以帮忙吗？ 

I'm new to using linq in particular linq to xml and am having trouble trying to iterate through the results. My xml document has multiple nodes of the same name nested in a single parent node and I have used the following linq query which returns the correct result set. 
 
var listingAgentElements = from p in _xElement.Descendants("commercial") select p.Elements("listingAgent");
 
My xml has the following format: 
 
<commercial>
    <listingAgent id="1">
    <listingAgent id="2">
    <listingAgent id="3">
 </commercial>       
 
I am getting a result set containing all of the listing agents although for some reason when I try do the following foreach loop over listingAgentElements each element I try to loop over seems to have exactly the same result set as in still has all three listingAgents:
 
foreach (var element in listingAgentElements)
{
    var test = element;
}
 
Each listingAgent has a set of child elements in which I would like to loop over and get the values of to store in a DB as I'm doing an xml import console app.
 
It appears that their may be a problem with the query but I'm really not sure, could someone please assist?

原文：https://stackoverflow.com/questions/19087778