public void AddTableNormalWay(ActionRunner runner)
{
runner.AddTable(
op =>
{
op.TableName = TABLE_NAME;
op.AddColumn(new Column { Name = "id", DbType = DbType.Int32, Property = ColumnProperty.PrimaryKeyWithIdentity });
op.AddColumn(new Column { Name = "street1", DbType = DbType.String, Size = 50 });
op.AddColumn(new Column { Name = "street2", DbType = DbType.String, Size = 50 });
op.AddColumn(new Column { Name = "city", DbType = DbType.String, Size = 50 });
op.AddColumn(new Column { Name = "state", DbType = DbType.String, Size = 2 });
op.AddColumn(new Column { Name = "postalCode", DbType = DbType.String, Size = 12 });
});
runner.Run<IAddReferenceAndFkOperation>(op =>
{
op.Driver = runner.Driver;
op.TableName = AddPersonTable.TABLE_NAME;
op.ColumnName = FK_COL_NAME;
op.ConstraintName = FK_NAME;
op.ReferenceTableName = TABLE_NAME;
op.ReferenceColumnName = "id";
});
}
