/// <summary> /// Updates existing records in bulk. /// </summary> /// <param name="list"></param> /// <param name="tableName"></param> /// <param name="schema"></param> /// <param name="columns"></param> /// <param name="customColumnMappings"></param> /// <param name="bulkCopySettings"></param> /// <param name="propertyInfoList"></param> public BulkUpdate(BulkOperations bulk, IEnumerable <T> list, string tableName, string schema, HashSet <string> columns, Dictionary <string, string> customColumnMappings, BulkCopySettings bulkCopySettings, List <PropertyInfo> propertyInfoList) : base(bulk, list, tableName, schema, columns, customColumnMappings, bulkCopySettings, propertyInfoList) { _updatePredicates = new List <PredicateCondition>(); _parameters = new List <SqlParameter>(); _conditionSortOrder = 1; _nullableColumnDic = new Dictionary <string, bool>(); }
/// <summary> /// /// </summary> /// <param name="singleEntity"></param> /// <param name="tableName"></param> /// <param name="columns"></param> /// <param name="schema"></param> /// <param name="sqlTimeout"></param> /// <param name="ext"></param> public UpdateQueryAddColumn(T singleEntity, string tableName, HashSet <string> columns, string schema, int sqlTimeout, BulkOperations ext) { _singleEntity = singleEntity; _tableName = tableName; _columns = columns; _schema = schema; _sqlTimeout = sqlTimeout; _ext = ext; _customColumnMappings = new Dictionary <string, string>(); }
#pragma warning restore CS1591 // Missing XML comment for publicly visible type or member /// <summary> /// /// </summary> /// <param name="bulk"></param> /// <param name="list"></param> /// <param name="tableName"></param> /// <param name="columns"></param> /// <param name="customColumnMappings"></param> /// <param name="schema"></param> /// <param name="bulkCopySettings"></param> /// <param name="propertyInfoList"></param> protected AbstractColumnSelection(BulkOperations bulk, IEnumerable <T> list, string tableName, HashSet <string> columns, Dictionary <string, string> customColumnMappings, string schema, BulkCopySettings bulkCopySettings, List <PropertyInfo> propertyInfoList) { _bulk = bulk; _disableAllIndexes = false; CustomColumnMappings = customColumnMappings; _list = list; _tableName = tableName; _columns = columns; _schema = schema; _bulkCopySettings = bulkCopySettings; _propertyInfoList = propertyInfoList; }
/// <summary> /// /// </summary> /// <param name="tableName"></param> /// <param name="schema"></param> /// <param name="sqlTimeout"></param> /// <param name="ext"></param> public DeleteQuery(string tableName, string schema, int sqlTimeout, BulkOperations ext) { _tableName = tableName; _schema = schema; _sqlTimeout = sqlTimeout; _ext = ext; _whereConditions = new List <Condition>(); _andConditions = new List <Condition>(); _orConditions = new List <Condition>(); _parameters = new List <SqlParameter>(); _conditionSortOrder = 1; }
/// <summary> /// Updates existing records in bulk. /// </summary> /// <param name="list"></param> /// <param name="tableName"></param> /// <param name="schema"></param> /// <param name="columns"></param> /// <param name="disableAllIndexes"></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> /// <param name="disableIndexList"></param> /// <param name="bulkCopyDelegates"></param> public BulkUpdate(IEnumerable <T> list, string tableName, string schema, HashSet <string> columns, HashSet <string> disableIndexList, bool disableAllIndexes, Dictionary <string, string> customColumnMappings, int sqlTimeout, int bulkCopyTimeout, bool bulkCopyEnableStreaming, int?bulkCopyNotifyAfter, int?bulkCopyBatchSize, SqlBulkCopyOptions sqlBulkCopyOptions, BulkOperations ext, IEnumerable <SqlRowsCopiedEventHandler> bulkCopyDelegates) : base(list, tableName, schema, columns, disableIndexList, disableAllIndexes, customColumnMappings, sqlTimeout, bulkCopyTimeout, bulkCopyEnableStreaming, bulkCopyNotifyAfter, bulkCopyBatchSize, sqlBulkCopyOptions, ext, bulkCopyDelegates) { _ext.SetBulkExt(this); _updatePredicates = new List <Condition>(); _parameters = new List <SqlParameter>(); _conditionSortOrder = 1; }
/// <summary> /// /// </summary> /// <param name="singleEntity"></param> /// <param name="tableName"></param> /// <param name="ext"></param> public DeleteQueryTable(T singleEntity, string tableName, BulkOperations ext) { _singleEntity = singleEntity; _sqlTimeout = 600; _schema = Constants.DefaultSchemaName; Columns = new HashSet <string>(); CustomColumnMappings = new Dictionary <string, string>(); _tableName = tableName; _ext = ext; _schema = Constants.DefaultSchemaName; Columns = new HashSet <string>(); CustomColumnMappings = new Dictionary <string, string>(); }
/// <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> public UpdateQuery(T singleEntity, string tableName, string schema, HashSet <string> columns, Dictionary <string, string> customColumnMappings, int sqlTimeout, BulkOperations ext) { _singleEntity = singleEntity; _tableName = tableName; _schema = schema; _columns = columns; _customColumnMappings = customColumnMappings; _sqlTimeout = sqlTimeout; _ext = ext; _whereConditions = new List <Condition>(); _andConditions = new List <Condition>(); _orConditions = new List <Condition>(); _parameters = new List <SqlParameter>(); _conditionSortOrder = 1; }
/// <summary> /// /// </summary> /// <param name="list"></param> /// <param name="tableName"></param> /// <param name="ext"></param> public Table(IEnumerable <T> list, string tableName, BulkOperations ext) { _bulkCopyBatchSize = null; _bulkCopyNotifyAfter = null; _bulkCopyEnableStreaming = false; _helper = new BulkOperationsHelper(); _tableName = tableName; _sqlTimeout = 600; _bulkCopyTimeout = 600; _ext = ext; _list = list; _schema = Constants.DefaultSchemaName; Columns = new HashSet <string>(); UpdateOnList = new List <string>(); DeleteOnList = new List <string>(); CustomColumnMappings = new Dictionary <string, string>(); _sqlBulkCopyOptions = SqlBulkCopyOptions.Default; }
#pragma warning restore CS1591 // Missing XML comment for publicly visible type or member /// <summary> /// /// </summary> /// <param name="list"></param> /// <param name="tableName"></param> /// <param name="columns"></param> /// <param name="schema"></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> /// <param name="bulkCopyDelegates"></param> protected AbstractColumnSelection(IEnumerable <T> list, string tableName, HashSet <string> columns, string schema, int sqlTimeout, int bulkCopyTimeout, bool bulkCopyEnableStreaming, int?bulkCopyNotifyAfter, int?bulkCopyBatchSize, SqlBulkCopyOptions sqlBulkCopyOptions, BulkOperations ext, IEnumerable <SqlRowsCopiedEventHandler> bulkCopyDelegates) { _disableAllIndexes = false; _disableIndexList = new HashSet <string>(); _customColumnMappings = new Dictionary <string, string>(); _list = list; _tableName = tableName; _columns = columns; _schema = schema; _sqlTimeout = sqlTimeout; _bulkCopyTimeout = bulkCopyTimeout; _bulkCopyEnableStreaming = bulkCopyEnableStreaming; _bulkCopyNotifyAfter = bulkCopyNotifyAfter; _bulkCopyBatchSize = bulkCopyBatchSize; _sqlBulkCopyOptions = sqlBulkCopyOptions; _ext = ext; _bulkCopyDelegates = bulkCopyDelegates; }
#pragma warning restore CS1591 // Missing XML comment for publicly visible type or member /// <summary> /// /// </summary> /// <param name="list"></param> /// <param name="tableName"></param> /// <param name="schema"></param> /// <param name="columns"></param> /// <param name="customColumnMappings"></param> /// <param name="bulkCopySettings"></param> /// <param name="propertyInfoList"></param> protected AbstractOperation(BulkOperations bulk, IEnumerable <T> list, string tableName, string schema, HashSet <string> columns, Dictionary <string, string> customColumnMappings, BulkCopySettings bulkCopySettings, List <PropertyInfo> propertyInfoList) { this.bulk = bulk; _list = list; _tableName = tableName; _schema = schema; _columns = columns; _disableAllIndexes = false; _customColumnMappings = customColumnMappings; _identityColumn = null; _collationColumnDic = new Dictionary <string, string>(); _outputIdentityDic = new Dictionary <int, T>(); _outputIdentity = ColumnDirectionType.Input; _matchTargetOn = new List <string>(); _bulkCopySettings = bulkCopySettings; _tableHint = "HOLDLOCK"; _ordinalDic = new Dictionary <string, int>(); _propertyInfoList = propertyInfoList; }
/// <summary> /// /// </summary> /// <param name="list"></param> /// <param name="tableName"></param> /// <param name="columns"></param> /// <param name="schema"></param> /// <param name="sourceAlias"></param> /// <param name="targetAlias"></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 AllColumnSelect(IEnumerable <T> list, string tableName, HashSet <string> columns, string schema, string sourceAlias, string targetAlias, int sqlTimeout, int bulkCopyTimeout, bool bulkCopyEnableStreaming, int?bulkCopyNotifyAfter, int?bulkCopyBatchSize, SqlBulkCopyOptions sqlBulkCopyOptions, BulkOperations ext) { _helper = new BulkOperationsHelpers(); _disableAllIndexes = false; _disableIndexList = new HashSet <string>(); _list = list; _columns = columns; _tableName = tableName; _schema = schema; _sourceAlias = sourceAlias; _targetAlias = targetAlias; _sqlTimeout = sqlTimeout; _bulkCopyTimeout = bulkCopyTimeout; _bulkCopyEnableStreaming = bulkCopyEnableStreaming; _bulkCopyNotifyAfter = bulkCopyNotifyAfter; _bulkCopyBatchSize = bulkCopyBatchSize; _sqlBulkCopyOptions = sqlBulkCopyOptions; _ext = ext; CustomColumnMappings = new Dictionary <string, string>(); }
/// <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="bulkCopyTimeout"></param> /// <param name="bulkCopyEnableStreaming"></param> /// <param name="bulkCopyNotifyAfter"></param> /// <param name="bulkCopyBatchSize"></param> /// <param name="sqlBulkCopyOptions"></param> /// <param name="ext"></param> public BulkInsert(IEnumerable <T> list, string tableName, string schema, HashSet <string> columns, HashSet <string> disableIndexList, bool disableAllIndexes, string sourceAlias, string targetAlias, Dictionary <string, string> customColumnMappings, int bulkCopyTimeout, bool bulkCopyEnableStreaming, int?bulkCopyNotifyAfter, int?bulkCopyBatchSize, SqlBulkCopyOptions sqlBulkCopyOptions, BulkOperations ext) { _list = list; _tableName = tableName; _schema = schema; _columns = columns; _sourceAlias = sourceAlias; _targetAlias = targetAlias; _helper = new BulkOperationsHelpers(); _updateOnList = new List <string>(); _disableIndexList = disableIndexList; _disableAllIndexes = disableAllIndexes; _customColumnMappings = customColumnMappings; _bulkCopyTimeout = bulkCopyTimeout; _bulkCopyEnableStreaming = bulkCopyEnableStreaming; _bulkCopyNotifyAfter = bulkCopyNotifyAfter; _bulkCopyBatchSize = bulkCopyBatchSize; _ext = ext; _sqlBulkCopyOptions = sqlBulkCopyOptions; _ext.SetBulkExt(this); }
#pragma warning restore CS1591 // Missing XML comment for publicly visible type or member /// <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="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> protected AbstractOperation(IEnumerable <T> list, string tableName, string schema, HashSet <string> columns, HashSet <string> disableIndexList, bool disableAllIndexes, 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; _disableIndexList = disableIndexList; _disableAllIndexes = disableAllIndexes; _customColumnMappings = customColumnMappings; _sqlTimeout = sqlTimeout; _bulkCopyTimeout = bulkCopyTimeout; _bulkCopyEnableStreaming = bulkCopyEnableStreaming; _bulkCopyNotifyAfter = bulkCopyNotifyAfter; _bulkCopyBatchSize = bulkCopyBatchSize; _sqlBulkCopyOptions = sqlBulkCopyOptions; _ext = ext; _identityColumn = null; _helper = new BulkOperationsHelper(); _outputIdentityDic = new Dictionary <int, T>(); _outputIdentity = ColumnDirection.Input; _matchTargetOn = new List <string>(); }
/// <summary> /// /// </summary> /// <param name="ext"></param> public Setup(BulkOperations ext) { _ext = ext; }
/// <summary> /// /// </summary> /// <param name="list"></param> /// <param name="tableName"></param> /// <param name="columns"></param> /// <param name="customColumnMappings"></param> /// <param name="schema"></param> /// <param name="bulkCopySettings"></param> /// <param name="propertyInfoList"></param> public BulkAddColumnList(BulkOperations bulk, IEnumerable <T> list, string tableName, HashSet <string> columns, Dictionary <string, string> customColumnMappings, string schema, BulkCopySettings bulkCopySettings, List <PropertyInfo> propertyInfoList) : base(bulk, list, tableName, columns, customColumnMappings, schema, bulkCopySettings, propertyInfoList) { }
/// <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="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, Dictionary <string, string> customColumnMappings, int sqlTimeout, int bulkCopyTimeout, bool bulkCopyEnableStreaming, int?bulkCopyNotifyAfter, int?bulkCopyBatchSize, SqlBulkCopyOptions sqlBulkCopyOptions, BulkOperations ext) : base(list, tableName, schema, columns, disableIndexList, disableAllIndexes, customColumnMappings, sqlTimeout, bulkCopyTimeout, bulkCopyEnableStreaming, bulkCopyNotifyAfter, bulkCopyBatchSize, sqlBulkCopyOptions, ext) { _ext.SetBulkExt(this); _deleteWhenNotMatchedFlag = false; }
/// <summary> /// /// </summary> /// <param name="list"></param> /// <param name="tableName"></param> /// <param name="columns"></param> /// <param name="schema"></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 AllColumnSelect(IEnumerable <T> list, string tableName, HashSet <string> columns, string schema, int sqlTimeout, int bulkCopyTimeout, bool bulkCopyEnableStreaming, int?bulkCopyNotifyAfter, int?bulkCopyBatchSize, SqlBulkCopyOptions sqlBulkCopyOptions, BulkOperations ext) : base(list, tableName, columns, schema, sqlTimeout, bulkCopyTimeout, bulkCopyEnableStreaming, bulkCopyNotifyAfter, bulkCopyBatchSize, sqlBulkCopyOptions, ext) { }
/// <summary> /// /// </summary> /// <param name="list"></param> /// <param name="tableName"></param> /// <param name="columns"></param> /// <param name="schema"></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> /// <param name="bulkCopyDelegates"></param> public BulkAddColumnList(IEnumerable <T> list, string tableName, HashSet <string> columns, string schema, int sqlTimeout, int bulkCopyTimeout, bool bulkCopyEnableStreaming, int?bulkCopyNotifyAfter, int?bulkCopyBatchSize, SqlBulkCopyOptions sqlBulkCopyOptions, BulkOperations ext, IEnumerable <SqlRowsCopiedEventHandler> bulkCopyDelegates) : base(list, tableName, columns, schema, sqlTimeout, bulkCopyTimeout, bulkCopyEnableStreaming, bulkCopyNotifyAfter, bulkCopyBatchSize, sqlBulkCopyOptions, ext, bulkCopyDelegates) { }
/// <summary> /// /// </summary> /// <param name="list"></param> /// <param name="ext"></param> public BulkForCollection(IEnumerable <T> list, BulkOperations ext) { _list = list; _ext = ext; }
/// <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="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> /// <param name="bulkCopyDelegates"></param> public BulkInsert(IEnumerable <T> list, string tableName, string schema, HashSet <string> columns, HashSet <string> disableIndexList, bool disableAllIndexes, Dictionary <string, string> customColumnMappings, int sqlTimeout, int bulkCopyTimeout, bool bulkCopyEnableStreaming, int?bulkCopyNotifyAfter, int?bulkCopyBatchSize, SqlBulkCopyOptions sqlBulkCopyOptions, BulkOperations ext, IEnumerable <SqlRowsCopiedEventHandler> bulkCopyDelegates) : base(list, tableName, schema, columns, disableIndexList, disableAllIndexes, customColumnMappings, sqlTimeout, bulkCopyTimeout, bulkCopyEnableStreaming, bulkCopyNotifyAfter, bulkCopyBatchSize, sqlBulkCopyOptions, ext, bulkCopyDelegates) { _ext.SetBulkExt(this); }
/// <summary> /// /// </summary> /// <param name="sourceAlias"></param> /// <param name="targetAlias"></param> /// <param name="ext"></param> public Setup(string sourceAlias, string targetAlias, BulkOperations ext) { _sourceAlias = sourceAlias; _targetAlias = targetAlias; _ext = ext; }
/// <summary> /// /// </summary> /// <param name="bulk"></param> /// <param name="list"></param> public BulkForCollection(BulkOperations bulk, IEnumerable <T> list) { _bulk = bulk; _list = list; }
/// <summary> /// /// </summary> /// <param name="list"></param> /// <param name="sourceAlias"></param> /// <param name="targetAlias"></param> /// <param name="ext"></param> public CollectionSelect(IEnumerable <T> list, string sourceAlias, string targetAlias, BulkOperations ext) { _list = list; _sourceAlias = sourceAlias; _targetAlias = targetAlias; _ext = ext; }
/// <summary> /// /// </summary> /// <param name="ext"></param> public DeleteQueryObject(BulkOperations ext) { _ext = ext; }
/// <summary> /// /// </summary> /// <param name="list"></param> /// <param name="ext"></param> public CollectionSelect(IEnumerable <T> list, BulkOperations ext) { _list = list; _ext = ext; }