コード例 #1
0
        protected static DatabaseDefinitions Fk_Change_Composite_NameChange_Dds(SqlEngineVersion version)
        {
            var ddOriginal = new ForeignKeyComposite();

            ddOriginal.GetTable("Order").AddInt32("LineNumber2");
            ddOriginal.GetTable("Order").AddUniqueConstraintWithName("UQ_Order_OrderHeaderId_LineNumber_LineNumber2", "OrderHeaderId", "LineNumber", "LineNumber2");
            ddOriginal.GetTable("TopOrdersPerCompany").AddInt32("Top2C");
            ddOriginal.SetVersions(version.GetTypeMapper());

            var ddFkChanged = new ForeignKeyComposite2();

            ddFkChanged.SetVersions(version.GetTypeMapper());

            return(new DatabaseDefinitions(ddOriginal, ddFkChanged, "ForeignKeyComposite", "ForeignKeyComposite2_Fk_Change_Composite_NameChange"));
        }
コード例 #2
0
        protected static DatabaseDefinitions Fk_Change_Composite_NoNameChange_Dds(SqlEngineVersion version)
        {
            var ddOriginal = new ForeignKeyComposite();

            ddOriginal.GetTable("Order").AddInt32("LineNumber2");
            ddOriginal.GetTable("Order").AddUniqueConstraintWithName("UQ_Order_OrderHeaderId_LineNumber_LineNumber2", "OrderHeaderId", "LineNumber", "LineNumber2");
            ddOriginal.GetTable("TopOrdersPerCompany").AddInt32("Top2C");
            ddOriginal.SetVersions(version.GetTypeMapper());

            var fkOriginal = ddOriginal
                             .GetTable("TopOrdersPerCompany").Properties
                             .OfType <ForeignKey>()
                             .First(fk => fk.ForeignKeyColumns.Any(fkcm => fkcm.ForeignKeyColumn.Name == "Top2A"));

            fkOriginal.Name = "FK_TopOrdersPerCompany_2";

            var ddFkChanged = new ForeignKeyComposite2();

            ddFkChanged.SetVersions(version.GetTypeMapper());

            return(new DatabaseDefinitions(ddOriginal, ddFkChanged, "ForeignKeyComposite", "ForeignKeyComposite2_Fk_Change_Composite_NoNameChange"));
        }