public void GetById_ShouldReturnNull_WhenWrongId()
        {
            // Arrange
            var context = GetContext(TestData.constructionMaterials);
            var repo    = new SqlConstructionMaterialRepo(context);

            // Act
            var constructionMaterial = repo.GetById(999);

            // Assert
            Assert.Null(constructionMaterial);

            context.Database.EnsureDeleted();
            context.Dispose();
        }
        public void GetAll_ShouldReturnConstructionMaterials()
        {
            // Arrange
            var context = GetContext(TestData.constructionMaterials);
            var repo    = new SqlConstructionMaterialRepo(context);

            // Act
            var constructionMaterials = repo.GetAll();

            // Assert
            Assert.Equal(TestData.constructionMaterials, constructionMaterials);

            context.Database.EnsureDeleted();
            context.Dispose();
        }
        public void GetById_ShouldReturnConstructionMaterial()
        {
            // Arrange
            var context = GetContext(TestData.constructionMaterials);
            var repo    = new SqlConstructionMaterialRepo(context);

            var id = _rnd.Next(1, TestData.constructionMaterials.Count());

            // Act
            var constructionMaterial = repo.GetById(id);

            // Assert
            Assert.Equal(TestData.constructionMaterials.SingleOrDefault(v => v.Id == id),
                         constructionMaterial);

            context.Database.EnsureDeleted();
            context.Dispose();
        }