/// <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;
}
