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