Delivery provider tip - Delivery provider routing options - m_RoutingType GUID

Tips and Tricks

   Note that Delivery providers have been replaced by Action Providers from Infiniti v8.0 onwards. Please see more about Action Providers in this article.

Ever been bitten by routing options needing to change but having to manually remove them from your DB before running the updated Delivery Provider code? Here’s a neat little solution:

Note this solution requires a module-level constant declared called m_RoutingType which is the GUID you are using for your routing type.

Public Sub New() 
    Dim cn As New OleDb.OleDbConnection(Configuration.ConfigurationManager.ConnectionStrings("ConnectionString").ConnectionString) 
    cn.Open() 
    Dim cmd As New OleDb.OleDbCommand() 
    cmd.CommandType = CommandType.Text 
    cmd.Connection = cn 
    cmd.CommandText = "delete routing_type where routingtypeid = '" & m_RoutingType.ToString & "'" 
    cmd.ExecuteNonQuery() 
    cmd.CommandText = "delete routing_elementtype where routingtypeid = '" & m_RoutingType.ToString & "'" 
    cmd.ExecuteNonQuery() 
    cn.Close()

    MyBase.RegisterRoutingType(m_RoutingType, "Output Channel Delivery") 
    MyBase.RegisterRoutingTypeAttribute(m_RoutingType, m_RoutingOptionFailAddress, "Fail Notification Email Address", 1, False)     MyBase.RegisterRoutingTypeAttribute(m_RoutingType, m_RoutingOptionHideDocumentLinks, "Hide Document Links true", 1, False)     MyBase.RegisterRoutingTypeAttribute(m_RoutingType, m_RoutingOptionEnabled, "Enabled true", 1, False) MyBase.RegisterRoutingTypeAttribute(m_RoutingType,     m_RoutingOptionEmailDisplayUI, "Email UI Display none", 1, False) 
End Sub