private void InsertViewPrefix(Models.SqlItem item)
{
var stringBuilder = new StringBuilder();
stringBuilder.AppendLine(
$"IF OBJECT_ID('[{item.Schema}].[{item.Name}]') IS NOT NULL\n" +
$" DROP VIEW [{item.Schema}].[{item.Name}]\n" +
$"GO");
stringBuilder.AppendLine();
stringBuilder.AppendLine();
stringBuilder.Append(item.Text);
item.SqlTextWithPrefix = stringBuilder.ToString();
}
private void ReplaceCreateViewText(Models.SqlItem sqlItem)
{
sqlItem.Text = Regex.Replace(sqlItem.Text, CreateViewText, CreateViewText, RegexOptions.IgnoreCase);
}
private void ReplaceCreateProcedureText(Models.SqlItem sqlItem)
{
sqlItem.Text = Regex.Replace(sqlItem.Text, CreateProcedureText2, CreateProcedureText1, RegexOptions.IgnoreCase);
sqlItem.Text = Regex.Replace(sqlItem.Text, CreateProcedureText1, CreateProcedureText1, RegexOptions.IgnoreCase);
}
