Delen via


SqlSyncAdapterBuilder Members

Creates a SyncAdapter and the SQL commands that are required to synchronize a client with a SQL Server database.

The following tables list the members exposed by the SqlSyncAdapterBuilder type.

Public Constructors

  Name Description
SqlSyncAdapterBuilder Overloaded. Initializes a new instance of the SqlSyncAdapterBuilder class.

Top

Public Properties

(see also Protected Properties )

  Name Description
Bb686930.pubproperty(en-US,SQL.90).gif ChangeTrackingType Specifies whether the server database uses the change tracking feature in SQL Server or a custom coupled change tracking system, with a default of CoupledChangeTracking.
Bb686930.pubproperty(en-US,SQL.90).gif Connection Gets or sets the connection to the server database.
Bb686930.pubproperty(en-US,SQL.90).gif Container  (inherited from Component )
Bb686930.pubproperty(en-US,SQL.90).gif CreationOriginatorIdColumn Gets or sets the column in the base table that is used to track who inserts a row.
Bb686930.pubproperty(en-US,SQL.90).gif CreationTrackingColumn Gets or sets the column in the base table that is used to track when a row is inserted.
Bb686930.pubproperty(en-US,SQL.90).gif DataColumns Gets a collection of data columns to be synchronized. This enables you to synchronize a subset of the columns in the table.
Bb686930.pubproperty(en-US,SQL.90).gif DeletionOriginatorIdColumn Gets or sets the column in the tombstone table that is used to track who deletes a row.
Bb686930.pubproperty(en-US,SQL.90).gif DeletionTrackingColumn Gets or sets the column in the tombstone table that is used to track when a row is deleted.
Bb686930.pubproperty(en-US,SQL.90).gif FilterClause Specifies the SQL WHERE clause (without the WHERE keyword) that is used to filter the result set from the base table.
Bb686930.pubproperty(en-US,SQL.90).gif FilterParameters Gets a collection of filter parameters that are used in the FilterClause.
Bb686930.pubproperty(en-US,SQL.90).gif QuotePrefix Specifies the left delimiter (such as a left square bracket) that is used for database object names, such as tables and columns.
Bb686930.pubproperty(en-US,SQL.90).gif QuoteSuffix Specifies the right delimiter (such as a right square bracket) that is used for database object names, such as tables and columns.
Bb686930.pubproperty(en-US,SQL.90).gif RowGuidColumn Gets or sets a column of uniqueidentifier data type that is used to identify rows in the base table and the tombstone table.
Bb686930.pubproperty(en-US,SQL.90).gif Site  (inherited from Component )
Bb686930.pubproperty(en-US,SQL.90).gif SyncDirection Specifies the direction of synchronization from the perspective of the client, with a default direction of Bidirectional.
Bb686930.pubproperty(en-US,SQL.90).gif TableName Gets or sets the name of the base table for which to create a SyncAdapter object.
Bb686930.pubproperty(en-US,SQL.90).gif TombstoneDataColumns Gets a collection of data columns to be synchronized. This enables you to synchronize a subset of the columns in the table.
Bb686930.pubproperty(en-US,SQL.90).gif TombstoneFilterClause Specifies the SQL WHERE clause (without the WHERE keyword) that is used to filter the result set from the tombstone table.
Bb686930.pubproperty(en-US,SQL.90).gif TombstoneFilterParameters Gets a collection of filter parameters that are used in the TombstoneFilterClause.
Bb686930.pubproperty(en-US,SQL.90).gif TombstoneTableName Gets or sets the name of the tombstone table that is used to synchronize deletes.
Bb686930.pubproperty(en-US,SQL.90).gif UpdateOriginatorIdColumn Gets or sets the column in the base table that is used to track who updates a row.
Bb686930.pubproperty(en-US,SQL.90).gif UpdateTrackingColumn Gets or sets the column in the base table that is used to track when a row is updated.

Top

Protected Properties

  Name Description
Bb686930.protproperty(en-US,SQL.90).gif CanRaiseEvents  (inherited from Component )
Bb686930.protproperty(en-US,SQL.90).gif DesignMode  (inherited from Component )
Bb686930.protproperty(en-US,SQL.90).gif Events  (inherited from Component )

Top

Public Methods

(see also Protected Methods )

  Name Description
Bb686930.pubmethod(en-US,SQL.90).gif CreateObjRef  (inherited from MarshalByRefObject )
Bb686930.pubmethod(en-US,SQL.90).gif Dispose  Overloaded. (inherited from Component )
Bb686930.pubmethod(en-US,SQL.90).gif Equals  Overloaded. (inherited from Object )
Bb686930.pubmethod(en-US,SQL.90).gif GetHashCode  (inherited from Object )
Bb686930.pubmethod(en-US,SQL.90).gif GetLifetimeService  (inherited from MarshalByRefObject )
Bb686930.pubmethod(en-US,SQL.90).gif GetType  (inherited from Object )
Bb686930.pubmethod(en-US,SQL.90).gif InitializeLifetimeService  (inherited from MarshalByRefObject )
Bb686930.pubmethod(en-US,SQL.90).gif Bb686930.static(en-US,SQL.90).gif ReferenceEquals  (inherited from Object )
Bb686930.pubmethod(en-US,SQL.90).gif ToString  (inherited from Component )
Bb686930.pubmethod(en-US,SQL.90).gif ToSyncAdapter Overloaded. Creates a synchronization adapter for the table specified in TableName.

Top

Protected Methods

  Name Description
Bb686930.protmethod(en-US,SQL.90).gif Dispose  Overloaded. (inherited from Component )
Bb686930.protmethod(en-US,SQL.90).gif Finalize  (inherited from Component )
Bb686930.protmethod(en-US,SQL.90).gif GetService  (inherited from Component )
Bb686930.protmethod(en-US,SQL.90).gif MemberwiseClone  Overloaded. (inherited from MarshalByRefObject )

Top

Public Events

  Name Description
Bb686930.pubevent(en-US,SQL.90).gif Disposed  (inherited from Component )

Top

See Also

Reference

SqlSyncAdapterBuilder Class
Microsoft.Synchronization.Data.Server Namespace