public List<Models.Title> GetAll() { using (var db = new TitlesEntities()) { List<Models.Title> titles = (from t in db.Titles select new Models.Title { TitleID = t.TitleId, TitleName = t.TitleName, ReleaseYear = t.ReleaseYear, Genre = t.TitleGenres.FirstOrDefault().Genre.Name } ).ToList(); return titles; } }
public Models.Title Get(int id) { using (var db = new TitlesEntities()) { var dbTitle = db.Titles.FirstOrDefault(t => t.TitleId == id); Models.Title title = new Models.Title { TitleName = dbTitle.TitleName, ReleaseYear = dbTitle.ReleaseYear, Genre = dbTitle.TitleGenres.FirstOrDefault().Genre.Name, StoryLine = dbTitle.StoryLines.FirstOrDefault().Description, Participants = dbTitle.TitleParticipants.Select(p => p.Participant.Name).ToList(), Awards = dbTitle.Awards.Select(a => a.Award1 + " (" + a.AwardYear + ")").ToList() }; return title; } }