SqlSyncTableProvisioning.FilterClause Property

  • Article

Gets or sets the SQL WHERE clause (without the WHERE keyword) that is used to filter the result set from the base table.

Namespace: Microsoft.Synchronization.Data.SqlServer
Assembly: Microsoft.Synchronization.Data.SqlServer (in microsoft.synchronization.data.sqlserver.dll)

Syntax

'Declaration
Public Property FilterClause As String
'Usage
Dim instance As SqlSyncTableProvisioning
Dim value As String

value = instance.FilterClause

instance.FilterClause = value

public string FilterClause { get; set; }

public:
property String^ FilterClause {
    String^ get ();
    void set (String^ value);
}

/** @property */
public String get_FilterClause ()

/** @property */
public void set_FilterClause (String value)

public function get FilterClause () : String

public function set FilterClause (value : String)

Property Value

The SQL WHERE clause (without the WHERE keyword) that is used to filter the result set from the base table.

Remarks

The filter clause is a WHERE clause without the WHERE keyword. It includes an alias of [side] for the Sync Framework change-tracking table. For example, if you want to filter a table so that only results for customers in California are returned, the filter clause would be similar to the following: [side].[SalesTerritory] = 'CA'. Use AddFilterColumn to specify the columns that are included in this filter clause.

See Also

Reference

SqlSyncTableProvisioning Class
SqlSyncTableProvisioning Members
Microsoft.Synchronization.Data.SqlServer Namespace