public static List <ScraperMaster> GetMasterList() { List <ScraperMaster> mList = new List <ScraperMaster>(); // get from masterview List <MasterView> mv = ScrapeDB.AllScrapeData; //MasterView.GetMasterView(); // get gamedocs List <Game_Doc> docs = Game_Doc.GetDocs(); // iterate through foreach (var entry in mv) { ScraperMaster sm = new ScraperMaster(); sm.gid = entry.gid; sm.pid = entry.pid; sm.mid = entry.mid; sm.GDBTitle = entry.GDBTitle; sm.GDBPlatformName = entry.PlatformName; sm.GDBPlatformAlias = entry.PlatformAlias; sm.GDBYear = entry.GDBYear; sm.MOBYTitle = entry.MOBYTitle; sm.MOBYAlias = entry.MOBYAlias; sm.MOBYPlatformName = entry.MOBYPlatformName; sm.MOBYPlatformAlias = entry.MOBYPlatformAlias; sm.MOBYYear = entry.MOBYYear; List <string> ds = (from a in docs where a.gid == sm.gid select a.downloadUrl).ToList(); if (ds.Count > 0) { sm.Game_Docs.AddRange(ds); } mList.Add(sm); } return(mList); }