public static void ColumnDelete(this DbContext context, string tableName, string columnName) { if (context.ColumnExists(tableName, columnName)) { context.Database.ExecuteSqlCommand("ALTER TABLE {0} DROP COLUMN {1}".FormatWith(tableName, columnName)); } }
public static void ColumnEnsure(this DbContext context, string tableName, string columnName, string columnDataType) { if (!context.ColumnExists(tableName, columnName)) { //context.Database.ExecuteSqlCommand("ALTER TABLE dbo.[{0}] ADD {1} {2}".FormatWith(tableName, columnName, columnDataType)); context.Database.ExecuteSqlCommand("ALTER TABLE {0} ADD {1} {2}".FormatWith(tableName, columnName, columnDataType)); } }