public static IAlterTableAddColumnOrAlterColumnSyntax AsForeignKeyReference(
this IAlterTableColumnAsTypeSyntax column,
string foreignTable,
string idColumn = "Id",
bool deleteOnCascade = true)
{
var attrs = column.AsInt64().ForeignKey(foreignTable, idColumn);
return(deleteOnCascade ? attrs.OnDelete(Rule.Cascade) : attrs);
}
public static IAlterTableColumnOptionOrAddColumnOrAlterColumnSyntax AsDateTimeOffset(this IAlterTableColumnAsTypeSyntax alter)
{
return(alter.AsCustom("DateTimeOffset"));
}
public static IAlterTableColumnOptionOrAddColumnOrAlterColumnSyntax AsStringMax(
this IAlterTableColumnAsTypeSyntax column
)
{
return(column.AsString(10000));
}
public static IAlterTableColumnOptionOrAddColumnOrAlterColumnSyntax AsMaxString(this IAlterTableColumnAsTypeSyntax column)
{
return(column.AsString(int.MaxValue));
}
public static IAlterTableColumnOptionOrAddColumnOrAlterColumnSyntax AsMaxString(this IAlterTableColumnAsTypeSyntax syntax)
{
return(syntax.AsCustom("nvarchar(MAX)"));
}
