static string AlterOrCreate(HuntingDog.Config.EAlterOrCreate alterOrCreate) { if (alterOrCreate == HuntingDog.Config.EAlterOrCreate.Alter) { return("ALTER"); } else { return("CREATE"); } }
public static void OpenFunctionForModification(UserDefinedFunction userDefinedFunction, SqlConnectionInfo connInfo, HuntingDog.Config.EAlterOrCreate alterOrCreate) { try { var builder = new StringBuilder(1000); lock (userDefinedFunction) { userDefinedFunction.Refresh(); builder.AppendLine(UseDataBaseGo(userDefinedFunction.Parent)); builder.Append(userDefinedFunction.ScriptHeader(alterOrCreate == EAlterOrCreate.Alter)); builder.Append(userDefinedFunction.TextBody); } CreateSQLDocumentWithHeader(builder.ToString(), connInfo); } catch (Exception ex) { log.Error("OpenFunctionForModification failed.", ex); } }