// Private methods
private string ReplaceProcedureNameInProcedureText(string newProcedureName)
{
Tuple <int, int> procedureNameStartAndLength = ScriptingHelpers.FindStoredProcedureNameInCreateScript(_text);
int procedureNameStart = procedureNameStartAndLength.Item1;
return(_text.Remove(procedureNameStart, procedureNameStartAndLength.Item2)
.Insert(procedureNameStart, newProcedureName));
}
public string GenerateDropAndCreateScript(string scriptTemplate, string procedureNameTemplate, bool replaceProcedureNameInProcedureText)
{
string procedureName = String.Format(procedureNameTemplate, _schema.Name, _name);
return(String.Format(
scriptTemplate,
procedureName,
ScriptingHelpers.ConvertBooleanToOnOrOffString(_usesAnsiNulls),
ScriptingHelpers.ConvertBooleanToOnOrOffString(_usesQuotedIdentifiers),
!replaceProcedureNameInProcedureText ? _text : ReplaceProcedureNameInProcedureText(procedureName)));
}