本文整理汇总了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)
);
}示例2: GetAlterDefaultConstraintExpression
public static AlterDefaultConstraintExpression GetAlterDefaultConstraintExpression()
{
var expression = new AlterDefaultConstraintExpression
{
ColumnName = TestColumnName1,
DefaultValue = 1,
TableName = TestTableName1
};
return expression;
}示例3: Generate
public override string Generate(AlterDefaultConstraintExpression expression)
{
throw new NotImplementedException();
}示例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));
}示例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();
}示例6: Process
public void Process(AlterDefaultConstraintExpression expression)
{
Process(Generator.Generate(expression));
}示例7: Truncate
public void Truncate(AlterDefaultConstraintExpression expression)
{
expression.TableName = Truncate(expression.TableName);
expression.ColumnName = Truncate(expression.ColumnName);
}示例8: Generate
public abstract string Generate(AlterDefaultConstraintExpression expression);示例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));
}示例10: Generate
public override string Generate(AlterDefaultConstraintExpression expression)
{
return compatabilityMode.HandleCompatabilty("Altering of default constraints is not supporteed for MySql");
}示例11: Generate
public override string Generate(AlterDefaultConstraintExpression expression)
{
throw new DatabaseOperationNotSupportedException();
}示例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)));
}示例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
}));
}