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

C# Expressions.AlterColumnExpression类代码示例

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

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



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

示例1: CanAlterColumn

 public void CanAlterColumn()
 {
     var expression = new AlterColumnExpression
                          {
                              Column = new ColumnDefinition { Type = DbType.String, Name = "Col1" },
                              SchemaName = "Schema1",
                              TableName = "Table1"
                          };
     var sql = generator.Generate(expression);
     sql.ShouldBe(String.Empty);
 }
开发者ID:ibebbs,项目名称:fluentmigrator,代码行数:11,代码来源:FirebirdGeneratorTests.cs


示例2: Generate

 public override string Generate(AlterColumnExpression expression)
 {
     var alterStatement = new StringBuilder();
     alterStatement.Append(String.Format("ALTER TABLE {0}.{1} {2}", Quoter.QuoteSchemaName(expression.SchemaName), Quoter.QuoteTableName(expression.TableName), ((PostgresColumn)Column).GenerateAlterClauses(expression.Column)));
     var descriptionStatement = DescriptionGenerator.GenerateDescriptionStatement(expression);
     if (!string.IsNullOrEmpty(descriptionStatement))
     {
         alterStatement.Append(";");
         alterStatement.Append(descriptionStatement);
     }
     return alterStatement.ToString();
 }
开发者ID:akema-fr,项目名称:fluentmigrator,代码行数:12,代码来源:PostgresGenerator.cs


示例3: GetAlterColumnExpression

        public static AlterColumnExpression GetAlterColumnExpression()
        {
            var expression = new AlterColumnExpression();
            expression.TableName = TestTableName1;

            expression.Column = new ColumnDefinition();
            expression.Column.Name = TestColumnName1;
            expression.Column.Type = DbType.String;
            expression.Column.Size = 20;
            expression.Column.IsNullable = false;

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


示例4: GenerateDescriptionStatement

        public override string GenerateDescriptionStatement(AlterColumnExpression expression)
        {
            if (string.IsNullOrEmpty(expression.Column.ColumnDescription))
                return string.Empty;

            var formattedSchemaName = FormatSchemaName(expression.SchemaName);

            // For this, we need to remove the extended property first if exists (or implement verification and use sp_updateextendedproperty)
            var columnVerificationStatement = string.Format(ColumnDescriptionVerificationTemplate, formattedSchemaName, expression.TableName, expression.Column.Name);
            var removalStatement = string.Format("{0} {1}", columnVerificationStatement, GenerateColumnDescriptionRemoval(formattedSchemaName, expression.TableName, expression.Column.Name));
            var newDescriptionStatement = GenerateColumnDescription(formattedSchemaName, expression.TableName, expression.Column.Name, expression.Column.ColumnDescription);

            return string.Join(";", new[] { removalStatement, newDescriptionStatement });
        }
开发者ID:BarsBarsovich,项目名称:fluentmigrator,代码行数:14,代码来源:SqlServer2005DescriptionGenerator.cs


示例5: Process

        public override void Process(AlterColumnExpression expression)
        {
            var tableDefinition = GetTableSchema(expression.TableName);

            var columnDefinitions = tableDefinition.Columns.ToList();
            var columnIndex = columnDefinitions.FindIndex(c => c.Name == expression.Column.Name);

            if (columnIndex == -1)
            {
                throw new ApplicationException(string.Format("Column {0} does not exist on table {1}.", expression.Column.Name, expression.TableName));
            }

            columnDefinitions[columnIndex] = expression.Column;

            tableDefinition.Columns = columnDefinitions;

            ProcessAlterTable(tableDefinition);
        }
开发者ID:Djohnnie,项目名称:Sonarr,代码行数:18,代码来源:NzbDroneSqliteProcessor.cs


示例6: Process

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


示例7: Generate

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


示例8: Truncate

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


示例9: CanAlterColumn

 public void CanAlterColumn()
 {
     var expression = new AlterColumnExpression
                          {
                              Column = new ColumnDefinition {Type = DbType.String, Name = "Col1"},
                              SchemaName = "Schema1",
                              TableName = "Table1"
                          };
     var sql = generator.Generate(expression);
     sql.ShouldBe("ALTER TABLE \"Schema1\".\"Table1\" ALTER \"Col1\" TYPE text");
 }
开发者ID:timscott,项目名称:fluentmigrator,代码行数:11,代码来源:PostgresGeneratorTests.cs


示例10: ToStringIsDescriptive

 public void ToStringIsDescriptive()
 {
     var expression = new AlterColumnExpression { TableName = "Bacon", Column = { Name = "BaconId", Type = DbType.Int32 } };
     expression.ToString().ShouldBe("AlterColumn Bacon BaconId Int32");
 }
开发者ID:BarsBarsovich,项目名称:fluentmigrator,代码行数:5,代码来源:AlterColumnExpressionTests.cs


示例11: Generate

        public override string Generate(AlterColumnExpression expression)
        {
            var descriptionStatement = DescriptionGenerator.GenerateDescriptionStatement(expression);

            if (string.IsNullOrEmpty(descriptionStatement))
                return base.Generate(expression);

            var wrappedAlterColumnStatement = WrapStatementInExecuteImmediateBlock(base.Generate(expression));

            var alterColumnWithDescriptionBuilder = new StringBuilder(wrappedAlterColumnStatement);
            alterColumnWithDescriptionBuilder.Append(WrapStatementInExecuteImmediateBlock(descriptionStatement));

            return WrapInBlock(alterColumnWithDescriptionBuilder.ToString());
        }
开发者ID:BarsBarsovich,项目名称:fluentmigrator,代码行数:14,代码来源:OracleGenerator.cs


示例12: Generate

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


示例13: CanAlterColumnAndSetAsNullable

        public void CanAlterColumnAndSetAsNullable()
        {
            var expression = new AlterColumnExpression
            {
                Column = new ColumnDefinition { Type = DbType.String, Name = "TestColumn1", IsNullable = true },
                SchemaName = "TestSchema",
                TableName = "TestTable1"
            };

            var result = Generator.Generate(expression);
            result.ShouldBe("ALTER TABLE \"TestSchema\".\"TestTable1\" ALTER \"TestColumn1\" TYPE text, ALTER \"TestColumn1\" DROP NOT NULL");
        }
开发者ID:BarsBarsovich,项目名称:fluentmigrator,代码行数:12,代码来源:PostgresGeneratorTests.cs


示例14: Generate

 public override string Generate(AlterColumnExpression expression)
 {
     return compatabilityMode.HandleCompatabilty("Sqlite does not support alter column");
 }
开发者ID:robinvarg,项目名称:fluentmigrator,代码行数:4,代码来源:SqliteGenerator.cs


示例15: CanAlterColumnAndSetAsNullable

        public void CanAlterColumnAndSetAsNullable()
        {
            var expression = new AlterColumnExpression
            {
                Column = new ColumnDefinition { Type = DbType.String, Name = "TestColumn1", IsNullable = true },
                SchemaName = "TestSchema",
                TableName = "TestTable1"
            };

            var result = Generator.Generate(expression);
            result.ShouldBe("ALTER TABLE TestSchema.TestTable1 ALTER COLUMN TestColumn1 SET DATA TYPE DBCLOB(1048576) CCSID 1200");
        }
开发者ID:BhuvanB,项目名称:fluentmigrator,代码行数:12,代码来源:Db2GeneratorTests.cs


示例16: GenerateDescriptionStatement

 public string GenerateDescriptionStatement(AlterColumnExpression expression)
 {
     return string.Empty;
 }
开发者ID:BarsBarsovich,项目名称:fluentmigrator,代码行数:4,代码来源:EmptyDescriptionGenerator.cs


示例17: CanAlterColumn

        public void CanAlterColumn()
        {
            var expression = new AlterColumnExpression();
            expression.TableName = "Table1";

            expression.Column = new ColumnDefinition();
            expression.Column.Name = "Column1";
            expression.Column.Type = DbType.String;
            expression.Column.Size = 20;
            expression.Column.IsNullable = false;

            var sql = generator.Generate(expression);
            sql.ShouldBe("ALTER TABLE [Table1] ALTER COLUMN [Column1] VARCHAR(20) NOT NULL");
        }
开发者ID:gliljas,项目名称:fluentmigrator,代码行数:14,代码来源:JetGeneratorTests.cs


示例18: Generate

 public override string Generate(AlterColumnExpression expression)
 {
     return String.Format("ALTER TABLE {0}[{1}] ALTER COLUMN {2}", FormatSchema(expression.SchemaName), expression.TableName, Column.Generate(expression.Column));
 }
开发者ID:carlhoerberg,项目名称:fluentmigrator,代码行数:4,代码来源:SqlServer2000Generator.cs


示例19: Column

 public IAlterColumnOnTableSyntax Column(string columnName)
 {
     var expression = new AlterColumnExpression { Column = { Name = columnName } };
     _context.Expressions.Add(expression);
     return new AlterColumnExpressionBuilder(expression, _context);
 }
开发者ID:SaltyDH,项目名称:fluentmigrator,代码行数:6,代码来源:AlterExpressionRoot.cs


示例20: Generate

 public override string Generate(AlterColumnExpression expression)
 {
     return String.Format("ALTER TABLE {0} MODIFY {1}", expression.TableName, Column.Generate(expression.Column));
 }
开发者ID:jtreuting,项目名称:fluentmigrator,代码行数:4,代码来源:OracleGenerator.cs



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


鲜花

握手

雷人

路过

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

请发表评论

全部评论

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