> 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); > } > } > } >>This breaks here :
> System.Xml.Serialization.XmlSerializer x = new System.Xml.Serialization.XmlSerializer(q.GetType()); >>Cannot serialize anonymous types.