SqlRuleAction SqlRuleAction Class

Represents set of actions written in SQL language-based syntax that is performed against a BrokeredMessage.

Syntax

Declaration

[DataContract(Name = "SqlRuleAction", Namespace = "http://schemas.microsoft.com/netservices/2010/10/servicebus/connect")]
public sealed class SqlRuleAction : RuleAction, IExtensibleDataObject<DataContract(Name:="SqlRuleAction", Namespace:="http://schemas.microsoft.com/netservices/2010/10/servicebus/connect")>
Public NotInheritable Class SqlRuleAction
    Inherits RuleAction
    Implements IExtensibleDataObject

Inheritance Hierarchy

Inherited Members

Microsoft.ServiceBus.Messaging.RuleAction.System.Runtime.Serialization.IExtensibleDataObject.ExtensionData
Microsoft.ServiceBus.Messaging.RuleAction.System.Runtime.Serialization.IExtensibleDataObject.ExtensionData
,
Microsoft.ServiceBus.Messaging.RuleAction.System.Runtime.Serialization.IExtensibleDataObject.ExtensionData
Microsoft.ServiceBus.Messaging.RuleAction.System.Runtime.Serialization.IExtensibleDataObject.ExtensionData
, , , , , , , , , , ,

Constructors summary

Initializes a new instance of the SqlRuleAction class with the specified SQL expression.

Initializes a new instance of the SqlRuleAction class with the specified SQL expression and compatibility level.

Properties summary

This property is reserved for future use. An integer value showing the compatibility level, currently hard-coded to 20.

Sets the value of a rule action.

Gets a value indicating whether the SqlRuleAction requires preprocessing.

Gets the SQL expression.

Methods summary

Executes the SqlRuleAction object.

Gets the pre-processed RuleAction expression.

Returns a string representation of SqlRuleAction.

Validates the SQL expression against the SQL 92 syntax and rules.

Constructors

  • SqlRuleAction(String)
    SqlRuleAction(String)

    Initializes a new instance of the SqlRuleAction class with the specified SQL expression.

    public SqlRuleAction(string sqlExpression)Public Sub New(sqlExpression As String)

    Parameters

  • SqlRuleAction(String, Int32)
    SqlRuleAction(String, Int32)

    Initializes a new instance of the SqlRuleAction class with the specified SQL expression and compatibility level.

    public SqlRuleAction(string sqlExpression, int compatibilityLevel)Public Sub New(sqlExpression As String, compatibilityLevel As Integer)

    Parameters

    • sqlExpression

      The SQL expression.

    • compatibilityLevel

      Reserved for future use. An integer value showing compatibility level. Currently hard-coded to 20.

Properties

  • CompatibilityLevel
    CompatibilityLevel

    This property is reserved for future use. An integer value showing the compatibility level, currently hard-coded to 20.

    [DataMember(Name = "CompatibilityLevel", Order = 65538, EmitDefaultValue = false, IsRequired = false)]
    public int CompatibilityLevel { get; }<DataMember(Name:="CompatibilityLevel", Order:=65538, EmitDefaultValue:=False, IsRequired:=False)>
    Public ReadOnly Property CompatibilityLevel As Integer

    Property Value

    • An integer value showing the compatibility level

  • Parameters
    Parameters

    Sets the value of a rule action.

    public IDictionary<string, object> Parameters { get; }Public ReadOnly Property Parameters As IDictionary(Of String, Object)

    Property Value

  • RequiresPreprocessing
    RequiresPreprocessing

    Gets a value indicating whether the SqlRuleAction requires preprocessing.

    public override bool RequiresPreprocessing { get; }Public Overrides ReadOnly Property RequiresPreprocessing As Boolean

    Property Value

    • true if the SQL rule action requires preprocessing; otherwise, false. Currently always returns true.

  • SqlExpression
    SqlExpression

    Gets the SQL expression.

    [DataMember(Name = "SqlExpression", Order = 65537, EmitDefaultValue = false, IsRequired = true)]
    public string SqlExpression { get; }<DataMember(Name:="SqlExpression", Order:=65537, EmitDefaultValue:=False, IsRequired:=True)>
    Public ReadOnly Property SqlExpression As String

    Property Value

Methods

Details

Assembly

Microsoft.ServiceBus.dll