public AffiliationDetail ReadAffiliationById(int id)
 {
     using (var ctx = new ApplicationDbContext())
     {
         var characterAffiliationService = new CharacterAffiliationService();
         var entity = ctx.Affiliations.Single(e => e.Id == id);
         return(new AffiliationDetail
         {
             Group = entity.Group,
             Description = entity.Description,
             Characters = characterAffiliationService.ConvertCharAfilToChar(entity.CharacterAffiliations)
         });
     }
 }
 public CharacterDetail ReadCharacterById(int id)
 {
     using (var ctx = new ApplicationDbContext())
     {
         var characterEpisodeService     = new CharacterEpisodeService();
         var characteraffiliationService = new CharacterAffiliationService();
         var entity = ctx.Characters.Single(e => e.Id == id);
         return(new CharacterDetail
         {
             Id = entity.Id,
             Name = entity.Name,
             Alive = entity.Alive,
             EpisodeOfDeath = entity.EpisodeOfDeath,
             House = entity.House.Name,
             Gender = entity.Gender,
             Actor = entity.Actor,
             CauseOfDeath = entity.CauseOfDeath,
             Affiliation = characteraffiliationService.ConvertCharAfilToAfil(entity.CharacterAffiliations),
             Episodes = characterEpisodeService.ConvertCharEpisToEpis(entity.CharacterEpisodes)
         });
     }
 }