public void Verify_Search_WithSelectStatement_Should_ReturnAListOfDynamicObjects()
        {
            // Arrange
            Mock <IDbSet <EpisodeCharacterFirstAppearance> > mockSetEpisodeCharacterFirstAppearances;
            var mockContext = EpisodeCharacterFirstAppearancesMockingSetup.DoMockingSetupForContext(true, out mockSetEpisodeCharacterFirstAppearances, true);
            var repository  = new EpisodeCharacterFirstAppearancesRepository(mockContext.Object);
            var searchModel = new Mock <IEpisodeCharacterFirstAppearanceSearchModel>();
            // Act
            var episodeCharacterFirstAppearances = repository.Search(searchModel.Object, i => new { i.Id, MyApiDetailUrl = i.ApiDetailUrl }).ToArray();

            // Assert
            Assert.Equal(1, episodeCharacterFirstAppearances.Length);
            Assert.Equal(2, episodeCharacterFirstAppearances[0].Id);
            Assert.Equal("/TEST/NIVEN-LARRY", episodeCharacterFirstAppearances[0].MyApiDetailUrl);
            // Stephen King was filtered out because he was Inactive
        }
        public void Verify_Search_WithPaging_Should_ReturnAListOfEpisodeCharacterFirstAppearancesWithDataMatchingSearchParameters()
        {
            // Arrange
            Mock <IDbSet <EpisodeCharacterFirstAppearance> > mockSetEpisodeCharacterFirstAppearances;
            var mockContext = EpisodeCharacterFirstAppearancesMockingSetup.DoMockingSetupForContext(true, out mockSetEpisodeCharacterFirstAppearances);
            var repository  = new EpisodeCharacterFirstAppearancesRepository(mockContext.Object);
            var searchModel = new EpisodeCharacterFirstAppearanceSearchModel {
                Paging = new Paging {
                    Skip = 1, Take = 1
                }
            };
            // Act
            var episodeCharacterFirstAppearances = repository.Search(searchModel /*.Object*/).ToArray();

            // Assert
            Assert.Equal(1, episodeCharacterFirstAppearances.Length);
            Assert.Equal(2, episodeCharacterFirstAppearances[0].Id);
            Assert.Equal("/TEST/NIVEN-LARRY", episodeCharacterFirstAppearances[0].ApiDetailUrl);
            // Stephen King was filtered out because he was Skipped
        }
        public void Verify_Search_WithModifiedSince_Should_ReturnAListOfEpisodeCharacterFirstAppearancesWithDataMatchingSearchParameters()
        {
            // Arrange
            Mock <IDbSet <EpisodeCharacterFirstAppearance> > mockSetEpisodeCharacterFirstAppearances;
            var mockContext = EpisodeCharacterFirstAppearancesMockingSetup.DoMockingSetupForContext(true, out mockSetEpisodeCharacterFirstAppearances, true);
            var repository  = new EpisodeCharacterFirstAppearancesRepository(mockContext.Object);
            var createDate  = new System.DateTime(2015, 05, 28, 10, 45, 00).AddDays(1).AddMinutes(-1);
            //var searchModel = new Mock<IEpisodeCharacterFirstAppearanceSearchModel>();
            //searchModel.Setup(m => m.ModifiedSince).Returns(() => createDate);
            var searchModel = new EpisodeCharacterFirstAppearanceSearchModel {
                ModifiedSince = createDate
            };
            // Act
            var episodeCharacterFirstAppearances = repository.Search(searchModel /*.Object*/).ToArray();

            // Assert
            Assert.Equal(1, episodeCharacterFirstAppearances.Length);
            Assert.Equal(2, episodeCharacterFirstAppearances[0].Id);
            Assert.Equal("/TEST/NIVEN-LARRY", episodeCharacterFirstAppearances[0].ApiDetailUrl);
            // Stephen King was filtered out because he was created before the modified since date
        }