/// <summary>
/// Drops an extended property for database object
/// </summary>
/// <param name="databaseFactory">Instance of <see cref="SqlServerDatabaseFactory"/> class</param>
/// <param name="view">Instance of <see cref="View"/> class</param>
/// <param name="column">Instance of <see cref="Column"/> class</param>
/// <param name="name">Extended property name</param>
public static void DropExtendedProperty(this SqlServerDatabaseFactory databaseFactory, IView view, Column column, string name)
{
using (var connection = databaseFactory.GetConnection())
{
connection.Open();
var repository = new ExtendedPropertyRepository(connection);
repository.DropExtendedProperty(new ExtendedProperty(name, "schema", view.Schema, "view", view.Name, "column", column.Name));
}
}
/// <summary>
/// Drops an extended property for database object
/// </summary>
/// <param name="databaseFactory">Instance of <see cref="SqlServerDatabaseFactory"/> class</param>
/// <param name="table">Instance of <see cref="Table"/> class</param>
/// <param name="name">Extended property name</param>
public static void DropExtendedProperty(this SqlServerDatabaseFactory databaseFactory, ITable table, string name)
{
using (var connection = databaseFactory.GetConnection())
{
connection.Open();
var repository = new ExtendedPropertyRepository(connection);
repository.DropExtendedProperty(new ExtendedProperty(name, "schema", table.Schema, "table", table.Name));
}
}
