SqlRuleFilter Class
Definition
Important
Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.
Represents a filter which is a composition of an expression and an action that is executed in the pub/sub pipeline.
public class SqlRuleFilter : Azure.Messaging.ServiceBus.Administration.RuleFiltertype SqlRuleFilter = class
inherit RuleFilterPublic Class SqlRuleFilter
Inherits RuleFilter- Inheritance
- Derived
Remarks
A SqlRuleFilter holds a SQL-like condition expression that is evaluated in the broker against the arriving messages' user-defined properties and system properties. All system properties (which are all properties explicitly listed on the ServiceBusMessage class) must be prefixed with sys. in the condition expression. The SQL subset implements testing for existence of properties (EXISTS), testing for null-values (IS NULL), logical NOT/AND/OR, relational operators, numeric arithmetic, and simple text pattern matching with LIKE.
Constructors
| SqlRuleFilter(String) |
Initializes a new instance of the SqlRuleFilter class using the specified SQL expression. |
Properties
| Parameters |
Sets the value of a filter expression. Allowed types: string, int, long, bool, double |
| SqlExpression |
Gets the SQL expression. |
Methods
| Equals(Object) |
Determines whether the specified object is equal to the current object. |
| Equals(RuleFilter) |
Indicates whether the current object is equal to another object of the same type. |
| GetHashCode() |
Serves as the default hash function. |
| ToString() |
Returns a string representation of SqlRuleFilter. |
Operators
| Equality(SqlRuleFilter, SqlRuleFilter) |
Compares two SqlRuleFilter values for equality. |
| Inequality(SqlRuleFilter, SqlRuleFilter) |
Compares two SqlRuleFilter values for inequality. |
