public static ICreatedTableWithAddedColumn WithChangeStamp(this ICreatedTableBase table)
{
return(table
.WithNotNullableColumn("CreatedDate", DbType.DateTime)
.WithNotNullableColumn("CreatedBy", DbType.AnsiString).OfSize(256)
.WithNotNullableColumn("ModifiedDate", DbType.DateTime)
.WithNotNullableColumn("ModifiedBy", DbType.AnsiString).OfSize(256));
}
public static ICreatedTableWithAddedColumn WithForeignKeyColumnTo(this ICreatedTableBase table, string otherTable, string columnName, bool required = true)
{
return(required
? table.WithNotNullableColumn(ForeignKeyColumnTo(otherTable), DbType.Guid)
: table.WithNullableColumn(ForeignKeyColumnTo(otherTable), DbType.Guid));
}