/// <summary>
/// Gets the stored procedure creation command
/// </summary>
/// <param name="StoredProcedure">The stored procedure object</param>
/// <returns>The string creating the stored procedure</returns>
private static string GetStoredProcedure(StoredProcedure StoredProcedure)
{
string Definition = Regex.Replace(StoredProcedure.Definition, "-- (.*)", "");
return Definition.Replace("\n", " ").Replace("\r", " ") + "\n";
}
/// <summary>
/// Gets a list of alter commands for a stored procedure
/// </summary>
/// <param name="StoredProcedure">Desired stored procedure</param>
/// <param name="CurrentStoredProcedure">Current stored procedure</param>
/// <returns>A list of commands in a string</returns>
private static string GetAlterStoredProcedure(StoredProcedure StoredProcedure, StoredProcedure CurrentStoredProcedure)
{
StringBuilder Builder = new StringBuilder();
if (StoredProcedure.Definition != CurrentStoredProcedure.Definition)
{
Builder.Append("EXEC dbo.sp_executesql @statement = N'DROP PROCEDURE ").Append(StoredProcedure.Name).Append("'\n");
Builder.Append(GetStoredProcedure(StoredProcedure));
}
return Builder.ToString();
}
