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