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

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

            var productionSiteReadRepositoryMock = new Mock <IProductionSiteReadRepository>();

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

            var productionSiteOdataProviderMock = new Mock <IProductionSiteOdataProvider>();

            productionSiteOdataProviderMock.Setup(x => x.GetFilterPredicate(It.IsAny <string>())).Returns((Expression <Func <ProductionSite, bool> >)null);
            var productionSiteOdataProvider = productionSiteOdataProviderMock.Object;

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

            var handler = new ListProductionSiteQueryHandler(mapper, productionSiteReadRepository, productionSiteOdataProvider);

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

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

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

            var productionSiteReadRepositoryMock = new Mock <IProductionSiteReadRepository>();

            productionSiteReadRepositoryMock.Setup(x => x.ListAsync(It.IsAny <Expression <Func <ProductionSite, bool> > >(), It.IsAny <int?>(), It.IsAny <int?>())).Throws <SomeDatabaseSpecificException>();
            var productionSiteReadRepository = productionSiteReadRepositoryMock.Object;

            var productionSiteOdataProviderMock = new Mock <IProductionSiteOdataProvider>();

            productionSiteOdataProviderMock.Setup(x => x.GetFilterPredicate(It.IsAny <string>())).Returns((Expression <Func <ProductionSite, bool> >)null);
            var productionSiteOdataProvider = productionSiteOdataProviderMock.Object;

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

            var handler = new ListProductionSiteQueryHandler(mapper, productionSiteReadRepository, productionSiteOdataProvider);

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

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