public async Task <IActionResult> GetShowAsync([FromRoute] string id)
        {
            var show = await _showsRepository.GetShowAsync(id);

            if (show == null)
            {
                return(NotFound());
            }
            return(Ok(show));
        }
        /// <inheritdoc />
        protected override async Task Handle(SyncTvMazeDbCommand request, CancellationToken cancellationToken)
        {
            var tvMazeShows = await GetNextPageShowsAsync();

            while (tvMazeShows.Any())
            {
                foreach (var tvMazeShow in tvMazeShows)
                {
                    // Perharps another thread (or instance of service) has already added the row with same ID
                    var showEntity = await _showsRepository.GetShowAsync(tvMazeShow.ID);

                    if (showEntity == null)
                    {
                        showEntity = new Show(tvMazeShow.ID, tvMazeShow.Name);

                        // Use eventual consistency and idempotent inserts instead of UoW.
                        // Firstly insert all the cast of the show, and only then that show.
                        // Even if the job fails it will start again and repeat the previous operation.

                        var tvMazeCasts = await _tvMazeService.GetShowCastsAsync(tvMazeShow.ID);

                        foreach (var tvMazeCast in tvMazeCasts)
                        {
                            if (tvMazeCast.Person != null)
                            {
                                var personEntity = new Person(tvMazeCast.Person.ID, tvMazeCast.Person.Name, String.IsNullOrEmpty(tvMazeCast.Person.Birthday) ? (DateTime?)null : DateTime.Parse(tvMazeCast.Person.Birthday));
                                personEntity = await _personsRepository.InsertIfNotExistsAsync(personEntity);

                                showEntity.AddCast(personEntity);
                            }
                        }

                        await _showsRepository.InsertIfNotExistsAsync(showEntity);
                    }
                }

                tvMazeShows = await GetNextPageShowsAsync();
            }
        }