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