>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);
>	}
>}
>