public static void CreateTable(this IQuery query, Type type)
{
var mapInfo = Mapper.GetMapInfo(type);
query.CreateTable(mapInfo.TableName, mapInfo.Columns.ToArray());
foreach (var constraint in mapInfo.Constraints)
{
query.AlterTable(mapInfo.TableName, constraint.AsAddConstraintAction());
}
}
public static void DropDefault(this IQuery query, ObjectName tableName, string columnName)
{
query.AlterTable(tableName, new DropDefaultAction(columnName));
}
public static void SetDefault(this IQuery query, ObjectName tableName, string columnName, SqlExpression expression)
{
query.AlterTable(tableName, new SetDefaultAction(columnName, expression));
}
public static void DropConstraint(this IQuery query, ObjectName tableName, string constraintName)
{
query.AlterTable(tableName, new DropConstraintAction(constraintName));
}
public static void DropPrimaryKey(this IQuery query, ObjectName tableName)
{
query.AlterTable(tableName, new DropPrimaryKeyAction());
}
public static void AddConstraint(this IQuery query, ObjectName tableName, SqlTableConstraint constraint)
{
query.AlterTable(tableName, new AddConstraintAction(constraint));
}
public static void AddColumn(this IQuery query, ObjectName tableName, SqlTableColumn column)
{
query.AlterTable(tableName, new AddColumnAction(column));
}
