public void GetByUniqueKey_ShouldReturnNull_WhenWrongKey()
        {
            // Arrange
            var context = GetContext();
            var repo    = new SqlStandardConstructionRepo(context);

            var specificationId = _standardConstructions[0].Specification.Id;
            var name            = _standardConstructions[0].Name;

            // Act
            var additionalWork1 = repo.GetByUniqueKey(999, name);
            var additionalWork2 = repo.GetByUniqueKey(specificationId, "NotFound");

            // Assert
            Assert.Null(additionalWork1);
            Assert.Null(additionalWork2);

            context.Database.EnsureDeleted();
            context.Dispose();
        }
        public void GetByUniqueKey_ShouldReturnstandardConstruction()
        {
            // Arrange
            var context = GetContext();
            var repo    = new SqlStandardConstructionRepo(context);

            var specificationId = _standardConstructions[0].Specification.Id;
            var name            = _standardConstructions[0].Name;

            // Act
            var standardConstruction = repo.GetByUniqueKey(specificationId, name);

            // Assert
            Assert.Equal(_standardConstructions.SingleOrDefault(
                             v => v.Specification.Id == specificationId &&
                             v.Name == name), standardConstruction);

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