• 设为首页
  • 点击收藏
  • 手机版
    手机扫一扫访问
    迪恩网络手机版
  • 关注官方公众号
    微信扫一扫关注
    迪恩网络公众号

C# Expressions.CreateForeignKeyExpression类代码示例

原作者: [db:作者] 来自: [db:来源] 收藏 邀请

本文整理汇总了C#中FluentMigrator.Expressions.CreateForeignKeyExpression的典型用法代码示例。如果您正苦于以下问题:C# CreateForeignKeyExpression类的具体用法?C# CreateForeignKeyExpression怎么用?C# CreateForeignKeyExpression使用的例子?那么恭喜您, 这里精选的类代码示例或许可以为您提供帮助。



CreateForeignKeyExpression类属于FluentMigrator.Expressions命名空间,在下文中一共展示了CreateForeignKeyExpression类的20个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于我们的系统推荐出更棒的C#代码示例。

示例1: GetCreateForeignKeyExpression

        public static CreateForeignKeyExpression GetCreateForeignKeyExpression()
        {
            var expression = new CreateForeignKeyExpression();
            expression.ForeignKey.Name = "FK_Test";
            expression.ForeignKey.PrimaryTable = TestTableName2;
            expression.ForeignKey.ForeignTable = TestTableName1;
            expression.ForeignKey.PrimaryColumns = new[] { TestColumnName2 };
            expression.ForeignKey.ForeignColumns = new[] { TestColumnName1 };

            return expression;
        }
开发者ID:hazzik,项目名称:fluentmigrator,代码行数:11,代码来源:GeneratorTestHelper.cs


示例2: CanCreateForeignKey

        public void CanCreateForeignKey()
        {
            var expression = new CreateForeignKeyExpression();
            expression.ForeignKey.Name = "FK_Test";
            expression.ForeignKey.PrimaryTable = "TestPrimaryTable";
            expression.ForeignKey.ForeignTable = "TestForeignTable";
            expression.ForeignKey.PrimaryColumns = new[] { "Column1", "Column2" };
            expression.ForeignKey.ForeignColumns = new[] { "Column3", "Column4" };

            string sql = generator.Generate(expression);
            sql.ShouldBe("ALTER TABLE TestForeignTable ADD CONSTRAINT FK_Test FOREIGN KEY (Column3,Column4) REFERENCES TestPrimaryTable (Column1,Column2)");
        }
开发者ID:nats,项目名称:fluentmigrator,代码行数:12,代码来源:OracleGeneratorTests.cs


示例3: CanCreateForeignKey

        public void CanCreateForeignKey()
        {
            var expression = new CreateForeignKeyExpression();
            expression.ForeignKey.Name = "FK_Test";
            expression.ForeignKey.PrimaryTable = "TestPrimaryTable";
            expression.ForeignKey.ForeignTable = "TestForeignTable";
            expression.ForeignKey.PrimaryColumns = new[] { "Column1", "Column2" };
            expression.ForeignKey.ForeignColumns = new[] { "Column3", "Column4" };

            var sql = generator.Generate(expression);
            sql.ShouldBe(
                "ALTER TABLE [TestForeignTable] ADD CONSTRAINT FK_Test FOREIGN KEY ([Column3],[Column4]) REFERENCES [TestPrimaryTable] ([Column1],[Column2])");
        }
开发者ID:briandonahue,项目名称:fluentmigrator,代码行数:13,代码来源:SqlServer2000GeneratorTests.cs


示例4: Generate

        public override string Generate(CreateForeignKeyExpression expression)
        {
            string primaryColumns = GetColumnList(expression.ForeignKey.PrimaryColumns);
            string foreignColumns = GetColumnList(expression.ForeignKey.ForeignColumns);

            string sql = "ALTER TABLE {0} ADD CONSTRAINT {1} FOREIGN KEY ({2}) REFERENCES {3} ({4})";

            return String.Format(sql,
                            expression.ForeignKey.ForeignTable,
                            expression.ForeignKey.Name,
                            foreignColumns,
                            expression.ForeignKey.PrimaryTable,
                            primaryColumns
                            );
        }
开发者ID:jtreuting,项目名称:fluentmigrator,代码行数:15,代码来源:OracleGenerator.cs


示例5: ToStringIsDescriptive

 public void ToStringIsDescriptive()
 {
     var sql = new CreateForeignKeyExpression
                 {
                     ForeignKey = new ForeignKeyDefinition
                                     {
                                         ForeignColumns = new Collection<string> { "User_id" },
                                         ForeignTable = "UserRoles",
                                         PrimaryColumns = new Collection<string> { "Id" },
                                         PrimaryTable = "User",
                                         Name = "FK"
                                     }
                 }.ToString();
     sql.ShouldBe("CreateForeignKey FK UserRoles(User_id) User(Id)");
 }
开发者ID:paulbatum,项目名称:fluentmigrator,代码行数:15,代码来源:CreateForeignKeyExpressionTests.cs


示例6: Generate

        public override string Generate(CreateForeignKeyExpression expression)
        {
            var primaryColumns = GetColumnList(expression.ForeignKey.PrimaryColumns);
            var foreignColumns = GetColumnList(expression.ForeignKey.ForeignColumns);

            const string sql = "ALTER TABLE {0}[{1}] ADD CONSTRAINT {2} FOREIGN KEY ({3}) REFERENCES {4}[{5}] ({6})";

            return string.Format(sql,
                                 FormatSchema(expression.ForeignKey.ForeignTableSchema),
                                 expression.ForeignKey.ForeignTable,
                                 expression.ForeignKey.Name,
                                 foreignColumns,
                                 FormatSchema(expression.ForeignKey.PrimaryTableSchema),
                                 expression.ForeignKey.PrimaryTable,
                                 primaryColumns
                );
        }
开发者ID:briandonahue,项目名称:fluentmigrator,代码行数:17,代码来源:SqlServer2000Generator.cs


示例7: Generate

        public override string Generate(CreateForeignKeyExpression expression)
        {
            string primaryColumns = GetColumnList(expression.ForeignKey.PrimaryColumns);
            string foreignColumns = GetColumnList(expression.ForeignKey.ForeignColumns);

            string sql = "ALTER TABLE `{0}` ADD CONSTRAINT {1} FOREIGN KEY ({2}) REFERENCES {3} ({4}){5}{6}";

            return String.Format(sql,
                            expression.ForeignKey.ForeignTable,
                            expression.ForeignKey.Name,
                            foreignColumns,
                            expression.ForeignKey.PrimaryTable,
                            primaryColumns,
                            FormatCascade("DELETE", expression.ForeignKey.OnDelete),
                            FormatCascade("UPDATE", expression.ForeignKey.OnUpdate)
                            );
        }
开发者ID:Ang3lFir3,项目名称:fluentmigrator,代码行数:17,代码来源:MySqlGenerator.cs


示例8: Generate

        public override string Generate(CreateForeignKeyExpression expression)
        {
            var primaryColumns = GetColumnList(expression.ForeignKey.PrimaryColumns);
            var foreignColumns = GetColumnList(expression.ForeignKey.ForeignColumns);

            const string sql = "ALTER TABLE {0}.{1} ADD CONSTRAINT {2} FOREIGN KEY ({3}) REFERENCES {4}.{5} ({6}){7}{8}";

            return string.Format(sql,
                                Quoter.QuoteSchemaName(expression.ForeignKey.ForeignTableSchema),
                                Quoter.QuoteTableName(expression.ForeignKey.ForeignTable),
                                Quoter.Quote(expression.ForeignKey.Name),
                                foreignColumns,
                                Quoter.QuoteSchemaName(expression.ForeignKey.PrimaryTableSchema),
                                Quoter.QuoteTableName(expression.ForeignKey.PrimaryTable),
                                primaryColumns,
                                FormatCascade("DELETE", expression.ForeignKey.OnDelete),
                                FormatCascade("UPDATE", expression.ForeignKey.OnUpdate)
                );
        }
开发者ID:VSoftTechnologies,项目名称:fluentmigrator,代码行数:19,代码来源:PostgresGenerator.cs


示例9: Truncate

 public void Truncate(CreateForeignKeyExpression expression)
 {
     Truncate(expression.ForeignKey);
 }
开发者ID:BarsBarsovich,项目名称:fluentmigrator,代码行数:4,代码来源:FirebirdTruncator.cs


示例10: Generate

 public override string Generate(CreateForeignKeyExpression expression)
 {
     return string.Format("{0};", base.Generate(expression));            
 }
开发者ID:SaltyDH,项目名称:fluentmigrator,代码行数:4,代码来源:HanaGenerator.cs


示例11: GenerateForeignKeyName

 public virtual string GenerateForeignKeyName(CreateForeignKeyExpression expression)
 {
     return string.Format("FK_{0}_{1}", expression.ForeignKey.PrimaryTable.Substring(0, 5), expression.ForeignKey.ForeignTable.Substring(0, 5));
 }
开发者ID:robertmircea,项目名称:fluentmigrator,代码行数:4,代码来源:GenericGenerator.cs


示例12: ForeignKey

 public ICreateForeignKeyFromTableSyntax ForeignKey()
 {
     var expression = new CreateForeignKeyExpression();
     _context.Expressions.Add(expression);
     return new CreateForeignKeyExpressionBuilder(expression);
 }
开发者ID:fire-eagle,项目名称:fluentmigrator,代码行数:6,代码来源:CreateExpressionRoot.cs


示例13: Generate

 public override string Generate(CreateForeignKeyExpression expression)
 {
     return compatabilityMode.HandleCompatabilty("Forign keys are not supported in Sqlite");
 }
开发者ID:robinvarg,项目名称:fluentmigrator,代码行数:4,代码来源:SqliteGenerator.cs


示例14: CanForeignKeyToUniqueColumn

        public void CanForeignKeyToUniqueColumn()
        {
            // Arrange

              var create = new CreateTableExpression
              {
              TableName = "Foo",
              Columns = new[]{
                   new ColumnDefinition {Name = "Id", Type = DbType.Int32, IsPrimaryKey = true}
                   , new ColumnDefinition {Name = "Type", Type = DbType.Int32}
                    }
              };

              var index = new CreateIndexExpression
              {
              Index =
                 new IndexDefinition()
                 {
                     Name = "IDX_FooType",
                     TableName = "Foo",
                     IsUnique = true,
                     Columns = new List<IndexColumnDefinition> { new IndexColumnDefinition { Name = "Type" } }
                 }
              };

              var secondTable = new CreateTableExpression
              {
              TableName = "Bar",
              Columns = new[]{
                   new ColumnDefinition {Name = "Id", Type = DbType.Int32, IsPrimaryKey = true}
                   , new ColumnDefinition {Name = "FooType", Type = DbType.Int32}
                    }
              };

              var foreignKey = new CreateForeignKeyExpression
              {
              ForeignKey =
                 new ForeignKeyDefinition()
                 {
                     Name = "FK_FooType",
                     ForeignTable = "Bar",
                     ForeignColumns = new [] { "FooType" },
                     PrimaryTable= "Foo",
                     PrimaryColumns = new[] { "Type" }
                 }
              };

              // Act
              MigrateToOracleWithData(new List<IMigrationExpression> { create, index, secondTable, foreignKey }, 2);

              // Assert
        }
开发者ID:garchibald,项目名称:fluentmigrator,代码行数:52,代码来源:SqlServerToOracleMigrationTests.cs


示例15: CallingOnUpdateSetsOnUpdateToSpecifiedRule

 public void CallingOnUpdateSetsOnUpdateToSpecifiedRule(Rule rule)
 {
     var expression = new CreateForeignKeyExpression();
     var builder = new CreateForeignKeyExpressionBuilder(expression);
     builder.OnUpdate(rule);
     Assert.That(expression.ForeignKey.OnUpdate, Is.EqualTo(rule));
     Assert.That(expression.ForeignKey.OnDelete, Is.EqualTo(Rule.None));
 }
开发者ID:guillaume86,项目名称:fluentmigrator,代码行数:8,代码来源:CreateForeignKeyExpressionBuilderTests.cs


示例16: Process

 public virtual void Process(CreateForeignKeyExpression expression)
 {
     Process(Generator.Generate(expression));
 }
开发者ID:Ang3lFir3,项目名称:fluentmigrator,代码行数:4,代码来源:ProcessorBase.cs


示例17: GetCreateForeignKeyExpression

        public static CreateForeignKeyExpression GetCreateForeignKeyExpression()
        {
            var expression = new CreateForeignKeyExpression();
            expression.ForeignKey.PrimaryTable = TestTableName2;
            expression.ForeignKey.ForeignTable = TestTableName1;
            expression.ForeignKey.PrimaryColumns = new[] { TestColumnName2 };
            expression.ForeignKey.ForeignColumns = new[] { TestColumnName1 };

            expression.ApplyConventions(new MigrationConventions());
            return expression;
        }
开发者ID:haf,项目名称:fluentmigrator,代码行数:11,代码来源:GeneratorTestHelper.cs


示例18: Generate

 public abstract string Generate(CreateForeignKeyExpression expression);
开发者ID:ibebbs,项目名称:fluentmigrator,代码行数:1,代码来源:GeneratorBase.cs


示例19: Generate

 public override string Generate(CreateForeignKeyExpression expression)
 {
     // Ignore foreign keys for SQLite
     return "";
 }
开发者ID:paulbatum,项目名称:fluentmigrator,代码行数:5,代码来源:SqliteGenerator.cs


示例20: CanCreateForeignKeyToDifferentSchema

        public void CanCreateForeignKeyToDifferentSchema()
        {
            var expression = new CreateForeignKeyExpression();
            expression.ForeignKey.Name = "FK_Test";
            expression.ForeignKey.PrimaryTable = "TestPrimaryTable";
            expression.ForeignKey.ForeignTable = "TestForeignTable";
            expression.ForeignKey.PrimaryColumns = new[] { "Column1", "Column2" };
            expression.ForeignKey.ForeignColumns = new[] { "Column3", "Column4" };
            expression.ForeignKey.PrimaryTableSchema = "wibble";

            string sql = generator.Generate(expression);
            sql.ShouldBe("ALTER TABLE \"public\".\"TestForeignTable\" ADD CONSTRAINT \"FK_Test\" FOREIGN KEY (\"Column3\",\"Column4\") REFERENCES \"wibble\".\"TestPrimaryTable\" (\"Column1\",\"Column2\")");
        }
开发者ID:timscott,项目名称:fluentmigrator,代码行数:13,代码来源:PostgresGeneratorTests.cs



注:本文中的FluentMigrator.Expressions.CreateForeignKeyExpression类示例由纯净天空整理自Github/MSDocs等源码及文档管理平台,相关代码片段筛选自各路编程大神贡献的开源项目,源码版权归原作者所有,传播和使用请参考对应项目的License;未经允许,请勿转载。


鲜花

握手

雷人

路过

鸡蛋
该文章已有0人参与评论

请发表评论

全部评论

专题导读
上一篇:
C# Expressions.CreateIndexExpression类代码示例发布时间:2022-05-26
下一篇:
C# Expressions.CreateConstraintExpression类代码示例发布时间:2022-05-26
热门推荐
阅读排行榜

扫描微信二维码

查看手机版网站

随时了解更新最新资讯

139-2527-9053

在线客服(服务时间 9:00~18:00)

在线QQ客服
地址:深圳市南山区西丽大学城创智工业园
电邮:jeky_zhao#qq.com
移动电话:139-2527-9053

Powered by 互联科技 X3.4© 2001-2213 极客世界.|Sitemap