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])"); }