SqlSyncProviderAdapterConfiguration Class

Represents synchronization adapter configuration for a table in a SQL Server database.

Inheritance Hierarchy

System.Object
  Microsoft.Synchronization.Data.SqlServer.SqlSyncProviderAdapterConfiguration

Namespace:  Microsoft.Synchronization.Data.SqlServer
Assembly:  Microsoft.Synchronization.Data.SqlServer (in Microsoft.Synchronization.Data.SqlServer.dll)

Syntax

'Declaration
Public Class SqlSyncProviderAdapterConfiguration
'Usage
Dim instance As SqlSyncProviderAdapterConfiguration
public class SqlSyncProviderAdapterConfiguration
public ref class SqlSyncProviderAdapterConfiguration
type SqlSyncProviderAdapterConfiguration =  class end
public class SqlSyncProviderAdapterConfiguration

The SqlSyncProviderAdapterConfiguration type exposes the following members.

Constructors

  Name Description
Public method SqlSyncProviderAdapterConfiguration Initializes a new instance of the SqlSyncProviderAdapterConfiguration class.

Top

Properties

  Name Description
Public property BulkDeleteProcName Gets or sets the name of the stored procedure that Sync Framework uses to delete data in bulk in a base table during synchronization.
Public property BulkInsertProcName Gets or sets the name of the stored procedure that Sync Framework uses to add data in bulk in a base table during synchronization.
Public property BulkTableTypeName Gets or sets the table type name that Sync Framework uses for bulk procedures.
Public property BulkUpdateProcName Gets or sets the name of the stored procedure that Sync Framework uses to update data in bulk in a base table during synchronization.
Public property Columns Gets a collection of DbSyncColumnDescription objects that represent all columns in a table.
Public property DeleteMetadataProcName Gets or sets the name of the stored procedure that Sync Framework uses to delete metadata from a tracking table.
Public property DeleteProcName Gets or sets the name of the stored procedure that Sync Framework uses to delete data from a base table during synchronization.
Public property DeleteTriggerName Gets or sets the name of the delete trigger that Sync Framework creates on a base table to update metadata in a tracking table.
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 FilterColumns Gets the list of columns that are used for filtering.
Public property FilterParameters Gets a collection of parameters that are used for filtering and that are specified in FilterClause.
Public property GlobalTableName Gets or sets the name, including database-specific delimiters that other nodes in a synchronization topology use to identify a table.
Public property InsertMetadataProcName Gets or sets the name of the stored procedure that Sync Framework uses to insert metadata into a tracking table.
Public property InsertProcName Gets or sets the name of the stored procedure that Sync Framework uses to insert data into a base table during synchronization.
Public property InsertTriggerName Gets or sets the name of the insert trigger that Sync Framework creates on a base table to update metadata in a tracking table.
Public property SelectChangesProcName Gets or sets the name of the stored procedure that Sync Framework uses to select changes from a base table during synchronization.
Public property SelectRowProcName Gets or sets the name of the stored procedure that Sync Framework uses to select conflicting rows from a base table during synchronization.
Public property TableName Gets or sets the name, not including database-specific delimiters, that the local node in a synchronization topology uses to identify a table.
Public property TrackingTableName Gets the name, not including database-specific delimiters, of the tracking table for a specific base table.
Public property UnmappedElements Gets or sets an array of any XML configuration elements that are not recognized by Sync Framework when an adapter is configured.
Public property UnquotedTrackingTableName Gets the name, not including database-specific delimiters, of the tracking table for a specific base table.
Public property UpdateMetadataProcName Gets or sets the name of the stored procedure that Sync Framework uses to update metadata in a tracking table.
Public property UpdateProcName Gets or sets the name of the stored procedure that Sync Framework uses to update data in a base table during synchronization.
Public property UpdateTriggerName Gets or sets the name of the update trigger that Sync Framework creates on a base table to update metadata in a tracking table.

Top

Methods

  Name Description
Public method BuildAdapter Creates and returns a DbSyncAdapter object that represents a table in a SQL Server database.
Public method Equals (Inherited from Object.)
Protected method Finalize (Inherited from Object.)
Public method GetHashCode (Inherited from Object.)
Public method GetType (Inherited from Object.)
Protected method MemberwiseClone (Inherited from Object.)
Public method ToString (Inherited from Object.)

Top

Remarks

Sync Framework uses this class to create a DbSyncAdapter object for each table that is provisioned for synchronization in a SQL Server database. For SqlSyncProvider, you typically do not interact directly with DbSyncAdapter objects, but you can use SqlSyncProviderAdapterConfiguration to set the names of the objects that Sync Framework creates in a database. For more information about provisioning and configuration, see How To: Execute Database Synchronization (SQL Server).

Thread Safety

Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

See Also

Reference

Microsoft.Synchronization.Data.SqlServer Namespace