public IEnumerable <Game> findComingSoonGames(int?MemberId) { List <int?> ComingSoonGameID = db.FindComingSoonGames(MemberId).ToList(); List <Game> ListofGames = new List <Game>();; foreach (int i in ComingSoonGameID) { Game game = db.Games.Find(i); ListofGames.Add(game); } //IEnumerable<Game> comingSoonGames = db.Games.Include(x => x.ProductInGames).Where(x => (x.GameState.ToLower() == "prepare" || x.GameState.ToLower() == "released" || x.GameState.ToLower() == "active") && x.MemberInGames.Count(y => y.MemberID == MemberId) > 0); return(ListofGames); }