public void NotNullColumnViolation()
{
var expected = Is.InstanceOf<ConstraintViolationException>()
.And.TypeOf<NotNullColumnViolationException>()
.And.Property("TableName").EqualTo(ObjectName.Parse("APP.test_table"))
.And.Property("ColumnName").EqualTo("active");
Assert.Throws(expected, () => AdminQuery.Insert(new ObjectName("test_table"),
new[] { "first_name", "last_name", "birth_date", "active" },
new SqlExpression[] {
SqlExpression.Constant("Antonello"),
SqlExpression.Constant("Provenzano"),
SqlExpression.Constant(new SqlDateTime(1980, 06, 04)),
SqlExpression.Constant(Field.Null())
}));
}