Exemplos de GeneratorTestHelper.GetCreateMultiColumnNamedPrimaryKeyExpression em C# (CSharp)

Exemplo n.º 1

Arquivo: OracleAlterTableTests.cs Projeto: PrinceLunga/FluentMigrator

        public void CanCreateMultiColmnNamedPrimaryKeyConstraint()
        {
            var expression = GeneratorTestHelper.GetCreateMultiColumnNamedPrimaryKeyExpression();
            var result     = generator.Generate(expression);

            result.ShouldBe("ALTER TABLE \"TestTable1\" ADD CONSTRAINT \"TESTPRIMARYKEY\" PRIMARY KEY (\"TestColumn1\", \"TestColumn2\")");
        }

Exemplo n.º 2

        public void CanCreateMultiColumnNamedPrimaryKeyConstraint()
        {
            var expression = GeneratorTestHelper.GetCreateMultiColumnNamedPrimaryKeyExpression();
            var result     = _generator.Generate(expression);

            result.ShouldBe("ALTER TABLE [TestTable1] ADD CONSTRAINT [TESTPRIMARYKEY] PRIMARY KEY ([TestColumn1], [TestColumn2])");
        }

Exemplo n.º 3

Arquivo: MySqlAlterTableTestscs.cs Projeto: ibebbs/fluentmigrator

        public void CanCreateMultiColmnNamedPrimaryKeyConstraint()
        {
            var expression = GeneratorTestHelper.GetCreateMultiColumnNamedPrimaryKeyExpression();
            var result     = _generator.Generate(expression);

            result.ShouldBe("ALTER TABLE `TestTable1` ADD CONSTRAINT `TESTPRIMARYKEY` PRIMARY KEY (`TestColumn1`, `TestColumn2`);");
        }

Exemplo n.º 4

        public void CanCreateNonClusteredMultiColumnNamedPrimaryKeyConstraint()
        {
            var expression = GeneratorTestHelper.GetCreateMultiColumnNamedPrimaryKeyExpression();

            expression.Constraint.AdditionalFeatures.Add(SqlServerExtensions.ConstraintType,
                                                         SqlServerConstraintType.NonClustered);

            var result = _generator.Generate(expression);

            result.ShouldBe("ALTER TABLE [TestTable1] ADD CONSTRAINT [TESTPRIMARYKEY] PRIMARY KEY NONCLUSTERED ([TestColumn1], [TestColumn2])");
        }