public async Task HandleShouldReturnOk()
        {
            // Arrange
            var mapperMock = new Mock <IMapper>();

            mapperMock.Setup(x => x.Map <IEnumerable <SiteModel> >(It.IsAny <object>())).Returns(Enumerable.Empty <SiteModel>());
            var mapper = mapperMock.Object;

            var siteReadRepositoryMock = new Mock <ISiteReadRepository>();

            siteReadRepositoryMock.Setup(x => x.ListAsync(It.IsAny <Expression <Func <Site, bool> > >(), It.IsAny <int?>(), It.IsAny <int?>())).Returns(Task.FromResult(Enumerable.Empty <Site>()));
            var siteReadRepository = siteReadRepositoryMock.Object;

            var siteOdataProviderMock = new Mock <ISiteOdataProvider>();

            siteOdataProviderMock.Setup(x => x.GetFilterPredicate(It.IsAny <string>())).Returns((Expression <Func <Site, bool> >)null);
            var SiteOdataProvider = siteOdataProviderMock.Object;

            var query = new ListSiteQuery(null, null, null);

            var handler = new ListSiteQueryHandler(mapper, siteReadRepository, SiteOdataProvider);

            // Act
            var result = await handler.Handle(query, CancellationToken.None);

            // Assert
            result.IsFailure.Should().BeFalse();
            result.Should().BeOfType(typeof(Result <SitesModel>));
        }
        public async Task HandleShouldReturnFailWhenDatabaseSpecificErrorOccurs()
        {
            // Arrange
            var mapperMock = new Mock <IMapper>();

            mapperMock.Setup(x => x.Map <IEnumerable <SiteModel> >(It.IsAny <object>())).Returns(Enumerable.Empty <SiteModel>());
            var mapper = mapperMock.Object;

            var siteReadRepositoryMock = new Mock <ISiteReadRepository>();

            siteReadRepositoryMock.Setup(x => x.ListAsync(It.IsAny <Expression <Func <Site, bool> > >(), It.IsAny <int?>(), It.IsAny <int?>())).Throws <SomeDatabaseSpecificException>();
            var siteReadRepository = siteReadRepositoryMock.Object;

            var siteOdataProviderMock = new Mock <ISiteOdataProvider>();

            siteOdataProviderMock.Setup(x => x.GetFilterPredicate(It.IsAny <string>())).Returns((Expression <Func <Site, bool> >)null);
            var siteOdataProvider = siteOdataProviderMock.Object;

            var query = new ListSiteQuery(null, null, null);

            var handler = new ListSiteQueryHandler(mapper, siteReadRepository, siteOdataProvider);

            // Act
            var result = await handler.Handle(query, CancellationToken.None);

            // Assert
            result.IsFailure.Should().BeTrue();
            result.Failures.Should().OnlyContain(x => x.Message == CustomFailures.ListSiteFailure);
        }