public async Task <DetailedGameData> GetDetailedGameData(int appid)
        {
            // 1. Check DB first
            var dbResult = DetailedGame.FirstOrDefault(dgd => dgd.appid == appid);

            if (dbResult != null)
            {
                Console.WriteLine("GetDetailedGameData - Found " + appid + " in DB.");
                return(dbResult.data);
            }

            // 2. Check API for missing
            Console.WriteLine("GetDetailedGameData - Did not find " + appid + " in DB. Pulling from API.");
            var appids = new List <int>()
            {
                appid
            };
            var apiResult = await ApiHelper.Instance.GetDetailedGameInfos(appids);

            // 3. Add API result to database
            var result = apiResult.FirstOrDefault();

            if (!DetailedGame.Any(dgd => dgd.appid == result.steam_appid))  // double check to see if it has been added (async code, could be)
            {
                var serialized = new DetailedGameModelDatabase()
                {
                    appid = result.steam_appid,
                    DetailedGameModelDataString = JsonConvert.SerializeObject(result)
                };
                DetailedGame.Add(serialized);
                SaveChanges();
            }

            return(result);
        }
        public async Task <List <DetailedGameData> > GetDetailedGameDatas(List <int> appids)
        {
            List <DetailedGameData> games = new List <DetailedGameData>();  // return result
            List <int> missingGames       = new List <int>();               // appids not in database yet

            // 1. Check DB first
            foreach (int appid in appids)
            {
                var dbResult = DetailedGame.FirstOrDefault(dgd => dgd.appid == appid);
                if (dbResult != null)
                {
                    Console.WriteLine("GetDetailedGameDatas - Found " + appid + " in DB.");
                    games.Add(dbResult.data);   // found game data in DB
                }
                else
                {
                    Console.WriteLine("GetDetailedGameDatas - Did not find " + appid + " in DB. Will pull from API.");
                    missingGames.Add(appid);    // add appid to retrieve from API
                }
            }

            // 2. Check API for missing
            if (missingGames.Count > 0)
            {
                Console.WriteLine("GetDetailedGameDatas - Pulling " + missingGames.Count + " games from API.");
                List <DetailedGameData> retrievedGames = await ApiHelper.Instance.GetDetailedGameInfos(missingGames);

                games.AddRange(retrievedGames);

                // 3. Add to DB
                Console.WriteLine("GetDetailedGameDatas - Saving " + games.Count + " games retrieved from API.");
                var serialized = retrievedGames.Select(dgd => new DetailedGameModelDatabase()
                {
                    appid = dgd.steam_appid,
                    DetailedGameModelDataString = JsonConvert.SerializeObject(dgd)
                }).ToList();
                DetailedGame.AddRange(serialized);  // TODO: good chance this will crash  - no existing checking
                SaveChanges();
            }


            // 3. Return results
            return(games);
        }