Example #1
0
        private string DropFromDatabase(CompareResultModel model)
        {
            switch (model.ObjectType)
            {
            case ObjectTypeEnum.Column:

                return(Scripting.DropColumn(Integrity.GetTableSchema(model.TableName), model.TableName, model.ObjectName));

            case ObjectTypeEnum.ForeignKeyConstraint:

                string constraintKey = $"{model.TableName}||{model.ObjectName}";

                return(Scripting.DropForeignKey(constraintKey));

            case ObjectTypeEnum.Table:

                return(Scripting.DropTable(model.TableObject));
            }

            return(string.Empty);
        }