/// <summary> /// /// </summary> /// <param name="list"></param> /// <param name="tableName"></param> /// <param name="schema"></param> /// <param name="columns"></param> /// <param name="disableIndexList"></param> /// <param name="disableAllIndexes"></param> /// <param name="sourceAlias"></param> /// <param name="targetAlias"></param> /// <param name="customColumnMappings"></param> /// <param name="sqlTimeout"></param> /// <param name="bulkCopyTimeout"></param> /// <param name="bulkCopyEnableStreaming"></param> /// <param name="bulkCopyNotifyAfter"></param> /// <param name="bulkCopyBatchSize"></param> /// <param name="sqlBulkCopyOptions"></param> /// <param name="ext"></param> public BulkInsertOrUpdate(IEnumerable <T> list, string tableName, string schema, HashSet <string> columns, HashSet <string> disableIndexList, bool disableAllIndexes, string sourceAlias, string targetAlias, Dictionary <string, string> customColumnMappings, int sqlTimeout, int bulkCopyTimeout, bool bulkCopyEnableStreaming, int?bulkCopyNotifyAfter, int?bulkCopyBatchSize, SqlBulkCopyOptions sqlBulkCopyOptions, BulkOperations ext) { _list = list; _tableName = tableName; _schema = schema; _columns = columns; _sourceAlias = sourceAlias; _targetAlias = targetAlias; _customColumnMappings = customColumnMappings; _sqlTimeout = sqlTimeout; _bulkCopyTimeout = bulkCopyTimeout; _bulkCopyEnableStreaming = bulkCopyEnableStreaming; _bulkCopyNotifyAfter = bulkCopyNotifyAfter; _bulkCopyBatchSize = bulkCopyBatchSize; _outputIdentity = false; _deleteWhenNotMatchedFlag = false; _helper = new BulkOperationsHelpers(); _outputIdentityDic = new Dictionary <int, T>(); _disableIndexList = disableIndexList; _matchTargetOn = new List <string>(); _ext = ext; _disableAllIndexes = disableAllIndexes; _sqlBulkCopyOptions = sqlBulkCopyOptions; _ext.SetBulkExt(this); }
/// <summary> /// /// </summary> /// <param name="tableName"></param> /// <param name="schema"></param> /// <param name="sqlTimeout"></param> /// <param name="ext"></param> /// <param name="conditionSortOrder"></param> /// <param name="whereConditions"></param> /// <param name="parameters"></param> public DeleteQueryReady(string tableName, string schema, int sqlTimeout, BulkOperations ext, int conditionSortOrder, List <Condition> whereConditions, List <SqlParameter> parameters) { _tableName = tableName; _schema = schema; _sqlTimeout = sqlTimeout; _ext = ext; _ext.SetBulkExt(this); _whereConditions = whereConditions; _andConditions = new List <Condition>(); _orConditions = new List <Condition>(); _conditionSortOrder = conditionSortOrder; _parameters = parameters; }
/// <summary> /// /// </summary> /// <param name="singleEntity"></param> /// <param name="tableName"></param> /// <param name="schema"></param> /// <param name="columns"></param> /// <param name="customColumnMappings"></param> /// <param name="sqlTimeout"></param> /// <param name="ext"></param> /// <param name="conditionSortOrder"></param> /// <param name="whereConditions"></param> /// <param name="parameters"></param> public UpdateQueryReady(T singleEntity, string tableName, string schema, HashSet <string> columns, Dictionary <string, string> customColumnMappings, int sqlTimeout, BulkOperations ext, int conditionSortOrder, List <Condition> whereConditions, List <SqlParameter> parameters) { _singleEntity = singleEntity; _tableName = tableName; _schema = schema; _columns = columns; _customColumnMappings = customColumnMappings; _sqlTimeout = sqlTimeout; _ext = ext; _conditionSortOrder = conditionSortOrder; _ext.SetBulkExt(this); _whereConditions = whereConditions; _andConditions = new List <Condition>(); _orConditions = new List <Condition>(); _parameters = parameters; }