public void ConstraintWriter()
{
ConstraintWriter writer = new ConstraintWriter();
writer.Write(new ConstraintTemplate("T", new List <TypeTemplate> {
Code.Type("type")
}), this.output);
Assert.AreEqual("\r\n where T : type", this.output.ToString());
}
public void TestSqlServerCheckConstraint()
{
//arrange
var table = new DatabaseTable {
Name = "Orders"
};
var check = new DatabaseConstraint
{
ConstraintType = ConstraintType.Check,
Expression = "[Quantity] > 0",
Name = "ValidationRule"
};
table.AddConstraint(check);
var writer = new ConstraintWriter(table);
//act
var txt = writer.WriteCheckConstraints();
//assert
Assert.IsTrue(txt.Contains("ALTER TABLE [Orders] ADD CONSTRAINT [ValidationRule] CHECK ([Quantity] > 0);"));
}
