public static string[] GetStoreProcedureDrop(Guid scheduledTaskGuid, Project dteProject) { var cc = new CloudCoreProject(dteProject); var sTaskGuid = scheduledTaskGuid.ToString().Replace("{", string.Empty).Replace("}", string.Empty).Replace("-", "_"); var sTaskStoreProcedureName = string.Format(@"[cloudcore].[CCScheduledTask_{0}]", sTaskGuid); var retString = string.Format("IF OBJECTPROPERTY(object_id('{0}'), N'IsProcedure') = 1\" + Environment.NewLine + \"BEGIN\" + Environment.NewLine + \"DROP PROCEDURE {0}\" + Environment.NewLine + \"END \"+ Environment.NewLine", sTaskStoreProcedureName).Split('\n'); return retString; }
public ScheduledTaskDte(Store store) { _store = store; _DiagramContainerProject = DiagramContainerProject; }