var Data = from cc in it.dt.CRM_CUSTOMER
join cl in it.dt.CRM_Linkman on cc.CustomerID equals cl.CustomerID
select new
{
customerName = cc.NAME,
linkManName = cl.NAME,
CustomerTag = cc.TAG,
linkPhone = cl.PHONE,
};//内链接
XDocument xdoxml = XDocument.Load(Server.MapPath(@"xmlFile/LinqXml2.xml"));
xdoxml.Root.RemoveAll();//移除父节点中的所有子节点
foreach (var o in Data)
{
xdoxml.Root.Add(new XElement(o.linkManName, new XElement("linkManName", new XText(o.linkManName)),
new XElement("CustomerTag", new XText(o.CustomerTag == null ? "AAA" : o.CustomerTag)),
new XElement("CustomerName", new XText(o.customerName)),
new XElement("linkPhone", new XText(o.linkPhone == null ? "1234567" : o.linkPhone))
));
}
xdoxml.Save(Server.MapPath(@"xmlFile/LinqXml2.xml"));
(以上写法) LinqXml2.xml 文件中首先必须存在一个父节点 如;(MyCustomerAndLinkMan)。。。