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)); }