linq转换为XML.如何访问这些数据
本文关键字:访问 数据 转换 XML 何访问 linq | 更新日期: 2023-09-27 17:58:08
如果下面的示例不可读,我正在访问的XML元素:就在这里:http://api.petfinder.com/pet.find?&动物=狗&计数=150&位置=90605&密钥=a94884c2349b56975ec84fb51ac3ec4
<pets>
<pet>
<id>19575609</id>
<shelterId>CA699</shelterId> <shelterPetId/>
<name>Louie</name>
<animal>Dog</animal>
<breeds>
<breed>Basset Hound</breed>
</breeds>
<mix>no</mix>
<age>Adult</age>
<sex>M</sex>
<size>M</size>
<options> ... </options>
<description>
<![CDATA[<div>Hi, my name is Louie. I'm a great looking houndthat really really wants his next home to be his final loving one. I'm looking for an adult home that will have patience with me as I learn to trust humans again. I like other dogs and tolerate cats. I've got lovely big front feet - just like a Basset should have. I walk well on a leash, and I'm house-trained. I'm a shy boy but I warm up once I get to know you and with lots of love and patience I'm sure in no time I'll turn into a hound that is a happy-go-lucky boy. I'm up to date on all vaccines and my adoption fee is $200.00. Please consider meeting me - I think once you do you will want to take me home and love me for the rest of my life. </div> <br/><a href="http://www.petfinder.com/petdetail/19575609">View this pet on Petfinder.com</a> ]]>
</description>
<lastUpdate>2011-05-16T19:22:23Z</lastUpdate>
<status>A</status>
<media>
<photos>
<photo size="x" id="1">http://photocache.petfinder.com/fotos/CA699/CA699.19575609-1-x.jpg</photo>
<photo size="t" id="1">http://photocache.petfinder.com/fotos/CA699/CA699.19575609-1-t.jpg</photo>
<photo size="pn" id="1">http://photocache.petfinder.com/fotos/CA699/CA699.19575609-1-pn.jpg</photo>
<photo size="pnt" id="1">http://photocache.petfinder.com/fotos/CA699/CA699.19575609-1-pnt.jpg</photo>
<photo size="fpm" id="1">http://photocache.petfinder.com/fotos/CA699/CA699.19575609-1-fpm.jpg</photo>
<photo size="x" id="2">http://photocache.petfinder.com/fotos/CA699/CA699.19575609-2-x.jpg</photo>
<photo size="t" id="2">http://photocache.petfinder.com/fotos/CA699/CA699.19575609-2-t.jpg</photo>
<photo size="pn" id="2">http://photocache.petfinder.com/fotos/CA699/CA699.19575609-2-pn.jpg</photo>
<photo size="pnt" id="2">http://photocache.petfinder.com/fotos/CA699/CA699.19575609-2-pnt.jpg</photo>
<photo size="fpm" id="2">http://photocache.petfinder.com/fotos/CA699/CA699.19575609-2-fpm.jpg</photo>
<photo size="x" id="3">http://photocache.petfinder.com/fotos/CA699/CA699.19575609-3-x.jpg</photo>
<photo size="t" id="3">http://photocache.petfinder.com/fotos/CA699/CA699.19575609-3-t.jpg</photo>
<photo size="pn" id="3">http://photocache.petfinder.com/fotos/CA699/CA699.19575609-3-pn.jpg</photo>
<photo size="pnt" id="3">http://photocache.petfinder.com/fotos/CA699/CA699.19575609-3-pnt.jpg</photo>
<photo size="fpm" id="3">http://photocache.petfinder.com/fotos/CA699/CA699.19575609-3-fpm.jpg</photo>
</photos>
</media>
</pet>
</pets>
下面是我尝试使用的代码。我试图返回的属性是url。
void processXML(XElement _xml)
{
XNamespace ns = "";
var pets = from item in
_xml.Elements(ns + "pets").Elements(ns + "pet")
select item;
foreach (var pet in pets)
{
Pet _pet = new Pet();
_pet.id = (string)pet.Element(ns + "id");
_pet.breeds = (string)pet.Element(ns + "breeds").Element(ns + "breed");
_pet.name = (string)pet.Element(ns + "name");
_pet.animal = (string)pet.Element(ns + "animal");
**_pet.media = (string)pet.Element(ns + "media")
.Element(ns + "photos").Element(ns + "photo")
.Attribute(ns + "fpm");**
Results.Items.Add(_pet);
}
}
提前感谢您的指导。
浓
如果我知道你必须这样做:
XmlElement photoList=pet.Element(ns + "media").Element(ns + "photos");
var url = from i in photoList.Descendants("photo")
where i.attribute("size").Equals("fpm")
select i.value;
现在我无法编译它,但我认为这是一个很好的起点!
更新
void processXML(XElement _xml)
{
var pets = from item in
_xml.Elements("pet")
select item;
foreach (var pet in pets)
{
//Pet _pet = new Pet();
string id = (string)pet.Element("id");
string breeds = (string)pet.Element("breeds").Element("breed");
string name = (string)pet.Element("name");
string animal = (string)pet.Element("animal");
/*string media = (string)pet.Element(ns + "media")
.Element(ns + "photos").Element(ns + "photo")
.Attribute(ns + "fpm");*/
var url = from i in pet.Descendants().Elements("photo")
where i.Attribute("size").Value.Equals("fpm")
select i.Value;
//Results.Items.Add(_pet);
}
}