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;
            }
        }