public static void GetTransactions()
        {
            using (var context = new PICSEntities(Config.model.SqlServer))
            {
                var q = from p in context.Parcels
                        join pt in context.ParcelInventoryTypes on p.ParcelInventoryTypes_Id equals pt.ParcelInventoryTypes_Id
                        join t in context.TransactionDetails on p.Parcels_Id equals t.Parcels_Id
                        join h in context.TransactionHeaders on t.TransactionHeaders_Id equals h.TransactionHeaders_Id
                        join g in context.GoodsTypes on p.GoodsTypes_Id equals g.GoodsTypes_Id
                        join tt in context.TransactionTypes on h.TransactionTypes_Id equals tt.TransactionTypes_Id
                        select new
                        {
                            Parcels_Id = p.Parcels_Id,
                            Goods = g.Description,
                            Inventory = pt.Description,
                            RSReference = p.RSReference,
                            Transaction_Nr = h.TransactionHeaders_Id,
                            Transaction_Type = tt.TransactionTypes_Id,
                            Date = h.TransactionDate,
                            Weight = t.Weight,
                            Amount = t.Amount
                        };
                // Json.serialize(q, @"c:\docs\q.json");
                Monitor.Console($"Extracted {q.Count()} records.");
                using (var fs = new System.IO.FileStream(@"c:\docs\q.xml", System.IO.FileMode.Create))
                {
                    System.Xml.Serialization.XmlSerializer x = new System.Xml.Serialization.XmlSerializer(q.GetType());
                    x.Serialize(fs, q);
                }
            }
        }

                    System.Xml.Serialization.XmlSerializer x = new System.Xml.Serialization.XmlSerializer(q.GetType());