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

C# Expressions.AlterDefaultConstraintExpression类代码示例

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

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



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

示例1: Generate

 public override string Generate(AlterDefaultConstraintExpression expression)
 {
     truncator.Truncate(expression);
     return String.Format("ALTER TABLE {0} ALTER COLUMN {1} SET DEFAULT {2}",
         Quoter.QuoteTableName(expression.TableName),
         Quoter.QuoteColumnName(expression.ColumnName),
         Quoter.QuoteValue(expression.DefaultValue)
         );
 }
开发者ID:SaltyDH,项目名称:fluentmigrator,代码行数:9,代码来源:FirebirdGenerator.cs


示例2: GetAlterDefaultConstraintExpression

 public static AlterDefaultConstraintExpression GetAlterDefaultConstraintExpression()
 {
     var expression = new AlterDefaultConstraintExpression
                          {
                              ColumnName = TestColumnName1,
                              DefaultValue = 1,
                              TableName = TestTableName1
                          };
     return expression;
 }
开发者ID:hazzik,项目名称:fluentmigrator,代码行数:10,代码来源:GeneratorTestHelper.cs


示例3: Generate

 public override string Generate(AlterDefaultConstraintExpression expression)
 {
     throw new NotImplementedException();
 }
开发者ID:ibebbs,项目名称:fluentmigrator,代码行数:4,代码来源:GenericGeneratorTests.cs


示例4: Generate

 public override string Generate(AlterDefaultConstraintExpression expression)
 {
     return String.Format("ALTER TABLE {0}.{1} ALTER {2} DROP DEFAULT, ALTER {2} {3}", Quoter.QuoteSchemaName(expression.SchemaName), Quoter.QuoteTableName(expression.TableName), Quoter.QuoteColumnName(expression.ColumnName), ((PostgresColumn)Column).FormatAlterDefaultValue(expression.ColumnName, expression.DefaultValue));
 }
开发者ID:VSoftTechnologies,项目名称:fluentmigrator,代码行数:4,代码来源:PostgresGenerator.cs


示例5: Generate

        public override string Generate(AlterDefaultConstraintExpression expression)
        {
            // before we alter a default constraint on a column, we have to drop any default value constraints in SQL Server
            var builder = new StringBuilder();

            builder.AppendLine(Generate(new DeleteDefaultConstraintExpression
                                            {
                                                ColumnName = expression.ColumnName,
                                                SchemaName = expression.SchemaName,
                                                TableName = expression.TableName
                                            }));

            builder.AppendLine();

            builder.Append(String.Format("-- create alter table command to create new default constraint as string and run it\r\nALTER TABLE {0} WITH NOCHECK ADD CONSTRAINT {3} DEFAULT({2}) FOR {1};",
                Quoter.QuoteTableName(expression.TableName),
                Quoter.QuoteColumnName(expression.ColumnName),
                Quoter.QuoteValue(expression.DefaultValue),
                Quoter.QuoteConstraintName(SqlServerColumn.GetDefaultConstraintName(expression.TableName, expression.ColumnName))));

            return builder.ToString();
        }
开发者ID:kramerpr,项目名称:fluentmigrator,代码行数:22,代码来源:SqlServer2000Generator.cs


示例6: Process

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


示例7: Truncate

 public void Truncate(AlterDefaultConstraintExpression expression)
 {
     expression.TableName = Truncate(expression.TableName);
     expression.ColumnName = Truncate(expression.ColumnName);
 }
开发者ID:BarsBarsovich,项目名称:fluentmigrator,代码行数:5,代码来源:FirebirdTruncator.cs


示例8: Generate

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


示例9: Generate

        public override string Generate(AlterDefaultConstraintExpression expression)
        {
            const string sql =
                @"
            DECLARE @default sysname, @sql nvarchar(max);

            -- get name of default constraint
            SELECT @default = name
            FROM sys.default_constraints
            WHERE parent_object_id = object_id('{0}')
            AND type = 'D'
            AND parent_column_id = (
                SELECT column_id
                FROM sys.columns
                WHERE object_id = object_id('{0}')
                AND name = '{1}'
            );

            -- create alter table command to drop contraint as string and run it
            SET @sql = N'ALTER TABLE {0} DROP CONSTRAINT ' + @default;
            EXEC sp_executesql @sql;

            -- create alter table command to create new default constraint as string and run it
            SET @sql = N'ALTER TABLE {0} WITH NOCHECK ADD CONSTRAINT [' + @default + '] DEFAULT({2}) FOR {1}';
            EXEC sp_executesql @sql;";

            return String.Format(sql,Quoter.QuoteTableName(expression.TableName), Quoter.QuoteColumnName(expression.ColumnName),Quoter.QuoteValue(expression.DefaultValue));
        }
开发者ID:xalzan,项目名称:fluentmigrator,代码行数:28,代码来源:SqlServer2000Generator.cs


示例10: Generate

 public override string Generate(AlterDefaultConstraintExpression expression)
 {
     return compatabilityMode.HandleCompatabilty("Altering of default constraints is not supporteed for MySql");
 }
开发者ID:xalzan,项目名称:fluentmigrator,代码行数:4,代码来源:JetGenerator.cs


示例11: Generate

 public override string Generate(AlterDefaultConstraintExpression expression)
 {
     throw new DatabaseOperationNotSupportedException();
 }
开发者ID:BarsBarsovich,项目名称:fluentmigrator,代码行数:4,代码来源:SqlServerCeGenerator.cs


示例12: Generate

        public override string Generate(AlterDefaultConstraintExpression expression)
        {
            const string sql =
                @"
            DECLARE @default sysname, @sql nvarchar(max);

            -- get name of default constraint
            SELECT @default = name
            FROM sys.default_constraints
            WHERE parent_object_id = object_id('{1}{2}')
            AND type = 'D'
            AND parent_column_id = (
                SELECT column_id
                FROM sys.columns
                WHERE object_id = object_id('{1}{2}')
                AND name = '{3}'
            );

            -- create alter table command to drop contraint as string and run it
            SET @sql = N'ALTER TABLE {0}[{2}] DROP CONSTRAINT ' + @default;
            EXEC sp_executesql @sql;

            -- create alter table command to create new default constraint as string and run it
            SET @sql = N'ALTER TABLE {0}[{2}] WITH NOCHECK ADD CONSTRAINT [' + @default + '] DEFAULT({4}) FOR {3}';
            EXEC sp_executesql @sql;";

            return FormatExpression(sql, FormatSchema(expression.SchemaName), FormatSchema(expression.SchemaName, false), expression.TableName, expression.ColumnName, FormatSqlEscape(GetConstantValue(expression.DefaultValue)));
        }
开发者ID:briandonahue,项目名称:fluentmigrator,代码行数:28,代码来源:SqlServer2000Generator.cs


示例13: Generate

 public override string Generate(AlterDefaultConstraintExpression expression)
 {
     return String.Format(AlterColumn, Quoter.QuoteTableName(expression.TableName), Column.Generate(new ColumnDefinition
     {
         ModificationType = ColumnModificationType.Alter,
         Name = expression.ColumnName,
         DefaultValue = expression.DefaultValue
     }));
 }
开发者ID:SaltyDH,项目名称:fluentmigrator,代码行数:9,代码来源:OracleGenerator.cs



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


鲜花

握手

雷人

路过

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

请发表评论

全部评论

专题导读
上一篇:
C# Expressions.AlterSchemaExpression类代码示例发布时间:2022-05-26
下一篇:
C# Expressions.AlterColumnExpression类代码示例发布时间: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