public void CanCreateMultiColumnNamedUniqueConstraint()
{
var expression = GeneratorTestHelper.GetCreateMultiColumnNamedUniqueConstraintExpression();
var result = _generator.Generate(expression);
result.ShouldBe("ALTER TABLE [TestTable1] ADD CONSTRAINT [TESTUNIQUECONSTRAINT] UNIQUE ([TestColumn1], [TestColumn2])");
}
public void CanCreateMultiColumnNamedUniqueConstraint()
{
var expression = GeneratorTestHelper.GetCreateMultiColumnNamedUniqueConstraintExpression();
var result = generator.Generate(expression);
result.ShouldBe("ALTER TABLE \"TestTable1\" ADD CONSTRAINT \"TESTUNIQUECONSTRAINT\" UNIQUE (\"TestColumn1\", \"TestColumn2\")");
}
public void CanCreateMultiColmnNamedUniqueConstraint()
{
var expression = GeneratorTestHelper.GetCreateMultiColumnNamedUniqueConstraintExpression();
var result = _generator.Generate(expression);
result.ShouldBe("ALTER TABLE `TestTable1` ADD CONSTRAINT `TESTUNIQUECONSTRAINT` UNIQUE (`TestColumn1`, `TestColumn2`);");
}
public void CanCreateMultiColumnNamedUniqueConstraintWithCustomSchema()
{
var expression = GeneratorTestHelper.GetCreateMultiColumnNamedUniqueConstraintExpression();
expression.Constraint.SchemaName = "TestSchema";
var result = generator.Generate(expression);
result.ShouldBe("ALTER TABLE [TestSchema].[TestTable1] ADD CONSTRAINT [TESTUNIQUECONSTRAINT] UNIQUE ([TestColumn1], [TestColumn2])");
}
public void CanCreateNonClusteredMultiColumnNamedUniqueConstraint()
{
var expression = GeneratorTestHelper.GetCreateMultiColumnNamedUniqueConstraintExpression();
expression.Constraint.AdditionalFeatures.Add(SqlServerExtensions.ConstraintType,
SqlServerConstraintType.NonClustered);
var result = _generator.Generate(expression);
result.ShouldBe("ALTER TABLE [TestTable1] ADD CONSTRAINT [TESTUNIQUECONSTRAINT] UNIQUE NONCLUSTERED ([TestColumn1], [TestColumn2])");
}
