public void ReadAllElementsByParentElementId_Valid_Data_In_Table()
        {
            var picMock = Utils.CreateMockDbSet(new List <IngredientPicture>
            {
                new IngredientPicture()
                {
                    IngredientID        = 1,
                    Ingredient          = new Ingredient(),
                    IngredientPictureID = 1
                }
            });


            var dbContext = new Mock <IDbContext>();

            dbContext.Setup(d => d.IngredientPictures).Returns(picMock.Object);
            var logger       = new Mock <ILogger <IngredientPicturesDbService> >();
            var picDbService = new IngredientPicturesDbService(dbContext.Object, logger.Object);

            var results = picDbService.ReadAllElementsByParentElementId(1);

            logger.Verify(l => l.Log(It.IsAny <LogLevel>(), It.IsAny <EventId>(), It.IsAny <FormattedLogValues>(), It.IsAny <Exception>(), It.IsAny <Func <object, Exception, string> >()), Times.Never);
            Assert.True(results.Count == 1);

            var result = results.FirstOrDefault();

            Assert.True(result.IngredientID == 1);
            Assert.True(result.IngredientPictureID == 1);
            Assert.NotNull(result.Ingredient);
        }
        public void ReadAllElementsByParentElementId_Invalid_Input()
        {
            var dbContext = new Mock <IDbContext>();
            var logger    = new Mock <ILogger <IngredientPicturesDbService> >();

            var corDbService = new IngredientPicturesDbService(dbContext.Object, logger.Object);

            Assert.Null(corDbService.ReadAllElementsByParentElementId(0));
            Assert.Null(corDbService.ReadAllElementsByParentElementId(-1));
        }
        public void ReadAllElementsByParentElementId_Valid_Input_No_Such_Table()
        {
            var dbContext = new Mock <IDbContext>();
            var logger    = new Mock <ILogger <IngredientPicturesDbService> >();

            var corDbService = new IngredientPicturesDbService(dbContext.Object, logger.Object);

            var result = corDbService.ReadAllElementsByParentElementId(1);

            logger.Verify(l => l.Log(It.IsAny <LogLevel>(), It.IsAny <EventId>(), It.IsAny <FormattedLogValues>(), It.IsAny <Exception>(), It.IsAny <Func <object, Exception, string> >()), Times.Once);
            Assert.Null(result);
        }