Share 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
Public method SqlSyncAdapterBuilder Overloaded. Initializes a new instance of the SqlSyncAdapterBuilder class.

Top

Public Properties

(see also Protected Properties )

  Name Description
Public property 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.
Public property Connection Gets or sets the connection to the server database.
Public property Container  (Inherited from Component.)
Public property CreationOriginatorIdColumn Gets or sets the column in the base table that is used to track who inserts a row.
Public property CreationTrackingColumn Gets or sets the column in the base table that is used to track when a row is inserted.
Public property DataColumns Gets a collection of data columns to be synchronized. This enables you to synchronize a subset of the columns in the table.
Public property DeletionOriginatorIdColumn Gets or sets the column in the tombstone table that is used to track who deletes a row.
Public property DeletionTrackingColumn Gets or sets the column in the tombstone table that is used to track when a row is deleted.
Public property FilterClause Specifies the SQL WHERE clause (without the WHERE keyword) that is used to filter the result set from the base table.
Public property FilterParameters Gets a collection of filter parameters that are used in the FilterClause.
Public property QuotePrefix Specifies the left delimiter (such as a left square bracket) that is used for database object names, such as tables and columns.
Public property QuoteSuffix Specifies the right delimiter (such as a right square bracket) that is used for database object names, such as tables and columns.
Public property RowGuidColumn Gets or sets a column of uniqueidentifier data type that is used to identify rows in the base table and the tombstone table.
Public property Site  (Inherited from Component.)
Public property SyncDirection Specifies the direction of synchronization from the perspective of the client, with a default direction of Bidirectional.
Public property TableName Gets or sets the name of the base table for which to create a SyncAdapter object.
Public property TombstoneDataColumns Gets a collection of data columns to be synchronized. This enables you to synchronize a subset of the columns in the table.
Public property TombstoneFilterClause Specifies the SQL WHERE clause (without the WHERE keyword) that is used to filter the result set from the tombstone table.
Public property TombstoneFilterParameters Gets a collection of filter parameters that are used in the TombstoneFilterClause.
Public property TombstoneTableName Gets or sets the name of the tombstone table that is used to synchronize deletes.
Public property UpdateOriginatorIdColumn Gets or sets the column in the base table that is used to track who updates a row.
Public property 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
Protected property CanRaiseEvents  (Inherited from Component.)
Protected property DesignMode  (Inherited from Component.)
Protected property Events  (Inherited from Component.)

Top

Public Methods

(see also Protected Methods )

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

Top

Protected Methods

  Name Description
Protected method Dispose  Overloaded. (Inherited from Component.)
Protected method Finalize  (Inherited from Component.)
Protected method GetService  (Inherited from Component.)
Protected method MemberwiseClone  Overloaded. (Inherited from MarshalByRefObject.)

Top

Public Events

  Name Description
Public event Disposed  (Inherited from Component.)

Top

See Also

Reference

SqlSyncAdapterBuilder Class
Microsoft.Synchronization.Data.Server Namespace