public void AddColumnDefinition(StringBuilder sb, Column c)
{
sb.AppendFormat(QUOTE_FORMAT, c.Name);
sb.Append(" ").Append(DbTypeMap.GetTypeName(c.DbType, c.Size));
if (c.Property.Match(ColumnProperty.Identity))
{
sb.Append(" IDENTITY(1,1)");
}
sb.Append(c.Property.Match(ColumnProperty.Null) ? " NULL" : " NOT NULL");
if (null != c.DefaultValue)
{
sb.Append(" DEFAULT ").Append(c.DefaultValue);
}
}
public void AddColumn(Column c)
{
Columns.Add(c);
}
/// <summary>
/// Checks if a column exists and creates it if it doesn't.
/// </summary>
/// <param name="c">The column definition to check and create.</param>
public void EnsureColumn(Column c)
{
if (!Driver.Inspect<IColumnExistsOperation>(op =>
{
op.TableName = SCHEMA_VERSION_TABLE;
op.ColumnName = c.Name;
}))
{
Driver.Run<IAddColumnOperation>(op =>
{
op.TableName = SCHEMA_VERSION_TABLE;
op.Column = c;
});
}
}