IC. Thanks.
>Make it local in between:
>
>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);
> }
>}
>
If things have the tendency to go your way, do not worry. It won't last. Jules Renard.