xml的数据怎么导入mysql,从XML到数据库中导入数据

i would like to import data into my database through an xml file:

var doc = XDocument.Load(XMLFile);

var nodes = from e in doc.Descendants("Person")

where e.Element("PersonID").Value == "1"

select e;

The person table has same structure as the data from nodes. Is it handy to use entity framework/linq-to-xml ?

解决方案

If the XML's format is right - i.e. if it uses the same format that the DataSet uses - you can just read it using DataSet.ReadXml() and then use all of the normal ADO tools for inserting the data into your database. Though it really helps if you've actually generated the XML from a DataSet in the first place and thus have a schema for ReadXml to use, because that resolves a lot of data type conversion issues that you'd otherwise have to take care of explicitly.