>using (var context = new PICSEntities(Config.model.SqlServer)) >{ > var q = from p in context.Parcels > join t in context.TransactionDetails on p.Parcels_Id equals t.Parcels_Id > select new > { > Parcels_Id = p.Parcels_Id, > Goods = p.GoodsType.Description, > Inventory = p.ParcelInventoryType.Description, > RSReference = p.RSReference, > Transaction_Nr = t.TransactionHeaders_Id, > Transaction_Type = t.TransactionHeader.TransactionType.Description, > Date = t.TransactionHeader.TransactionDate, > Weight = t.Weight, > Amount = t.Amount > }; > > >XDocument asXmlDocument = >new XDocument( > new XDeclaration("1.0", "utf-8", ""), > new XElement("Parcels", > from p in q.AsEnumerable() > select new XElement("Parcel", > new XAttribute("Parcels_Id", p.Parcels_Id), > new XAttribute("Goods", p.Goods), > new XAttribute("Inventory", p.Inventory), > new XAttribute("RSReference", p.RSReference), > new XAttribute("Transaction_Nr", p.Transaction_Nr), > new XAttribute("Transaction_Type", p.Transaction_Type), > new XAttribute("Date", p.Date), > new XAttribute("Weight", p.Weight), > new XAttribute("Amount", p.Amount) > ) > ) > ); > using (XmlWriter xw = XmlWriter.Create(@"c:\docs\q.xml")) > { > asXmlDocument.Save(xw); > } >} >