Manages the synchronization of data between source and destination databases.

Namespace

Base Types

object
QueryHelper

graph BT Type-->Base0["QueryHelper"] click Base0 "/api/DbSyncKit.DB.Helper/QueryHelper" Base0-->Base1["object"] Type["Synchronization"] class Type type-node

Syntax

public class Synchronization : QueryHelper

Constructors

Name	Summary
Synchronization()	Initializes a new instance of the `Synchronization` class with default instances of `DataContractFetcher` and `QueryBuilder`.
Synchronization(DataContractFetcher, QueryBuilder, DataContractMismatchIdentifier)	Initializes a new instance of the `Synchronization` class with custom instances of `DataContractFetcher`, `QueryBuilder`, and `DataContractMismatchIdentifier`.

Properties

Name	Property Type	Summary
ContractFetcher	DataContractFetcher	Gets or sets the instance of `DataContractFetcher` for fetching data using data contracts.
MismatchIdentifier	DataContractMismatchIdentifier	Gets or sets the instance of `DataContractMismatchIdentifier` used for identifying mismatches during the synchronization process.
QueryBuilder	QueryBuilder	Gets or sets the instance of `QueryBuilder` for building SQL queries.

Methods

Name	Return Value	Summary
GetAllColumns<T>()	List<string>	Gets the names of all properties for a specified type. Inherited from QueryHelper
GetComparableProperties<T>()	PropertyInfo[]	Retrieves an array of `System.Reflection.PropertyInfo` objects representing the properties that are used for data comparison in objects of type T. Inherited from QueryHelper
GetExcludedColumns<T>()	List<string>	Gets the names of properties marked as excluded properties for a specified type. Inherited from QueryHelper
GetIdentityColumns<T>()	List<string>	Retrieves a list of identity columns for a specified data contract type T. Inherited from QueryHelper
GetIncludeIdentityInsert<T>()	bool	Gets whether the type specifies to include database-specific SQL statements for identity insert behavior during insert query generation, considering the GenerateInsertWithIDAttribute if present. Inherited from QueryHelper
GetInsertWithID<T>()	bool	Gets whether the type specifies to generate an INSERT query with ID, considering the GenerateInsertWithIDAttribute if present. Inherited from QueryHelper
GetKeyColumns<T>()	List<string>	Gets the names of properties marked as key columns for a specified type. Inherited from QueryHelper
GetKeyProperties<T>()	PropertyInfo[]	Retrieves an array of `System.Reflection.PropertyInfo` objects representing the properties that are used as key properties for uniquely identifying objects of type T. Inherited from QueryHelper
GetTableName<T>()	string	Gets the table name of a specified type, considering the TableNameAttribute if present. Inherited from QueryHelper
GetTableSchema<T>()	string	Gets the table schema of a specified type, considering the TableSchemaAttribute if present. Inherited from QueryHelper
SyncData<T>(IDatabase, IDatabase, FilterCallback<T>, Direction)	Result<T>	Synchronizes data of a specific type between source and destination databases.