SqlFilter SqlFilter SqlFilter Class

Definition

Represents a filter which is a composition of an expression and an action that is executed in the pub/sub pipeline.

public class SqlFilter : Microsoft.Azure.ServiceBus.Filter
type SqlFilter = class
    inherit Filter
Public Class SqlFilter
Inherits Filter
Inheritance
SqlFilterSqlFilterSqlFilter
Derived

Remarks

A SqlFilter 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 Message 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

SqlFilter(String) SqlFilter(String) SqlFilter(String)

Initializes a new instance of the SqlFilter class using the specified SQL expression.

Properties

Parameters Parameters Parameters

Sets the value of a filter expression. Allowed types: string, int, long, bool, double

SqlExpression SqlExpression SqlExpression

Gets the SQL expression.

Methods

Equals(Filter) Equals(Filter) Equals(Filter)
Equals(Object) Equals(Object) Equals(Object)
GetHashCode() GetHashCode() GetHashCode()
ToString() ToString() ToString()

Returns a string representation of SqlFilter.

Operators

Equality(SqlFilter, SqlFilter) Equality(SqlFilter, SqlFilter) Equality(SqlFilter, SqlFilter)
Inequality(SqlFilter, SqlFilter) Inequality(SqlFilter, SqlFilter) Inequality(SqlFilter, SqlFilter)

Applies to