internal void DropTable(View view)
{
SqlSchema sqlSchema = new SqlSchema();
IDbCommand command = sqlSchema.GetCommand();
using (command.Connection = sqlSchema.GetConnection(view.Database.ConnectionString))
{
command.Connection.Open();
if (sqlSchema.IsViewExists(view.Name, command))
{
sqlSchema.DropView(view.Name, command);
if (!string.IsNullOrEmpty(view.EditableTableName))
{
if (sqlSchema.IsTableExists(view.EditableTableName, command))
{
sqlSchema.DropTable(view.EditableTableName, command);
}
}
}
else
{
if (sqlSchema.IsTableExists(view.Name, command))
{
sqlSchema.DropTable(view.Name, command);
}
}
logger.Log("ProductMaintenance", "RemoveApp", "DropTable", null, 3, "In Catalog " + command.Connection.Database + " view:" + view.Name + " and his editable table was droped ");
}
}