public static void CreateColumn(string tableName, DataColumn column, bool isNotNull, string quality)
{
string query = string.Format("ALTER TABLE {0} ADD {1} {2}{4} {3}",
tableName, column.ColumnName, column.DataType.Name.ToUpper(), isNotNull ? "NOT NULL" : "", quality);
DataBaseConnector.ExecuteNonQuery(query);
}
/// <summary>Удаялет строку или несколько строк найденых по условию</summary>
public static void DeleteRows(string tableName, string columnName, string value)
{
var sourceRows = SelectRowsFromTable(tableName, columnName, value);
string query = CreateDeleteQuery(tableName, columnName, value);
if (DataBaseConnector.ExecuteNonQuery(query))
{
DeleteRows(sourceRows);
}
}
