public IEnumerable <TVShow> GetTVShows() { return (from tvShow in _context.TVShows join cast in _context.Casts.DefaultIfEmpty() on tvShow.ID equals cast.TVShowId into Casts select new TVShow() { ID = tvShow.ID, Name = tvShow.Name, Cast = Casts.ToList() }); }