LinqToSql Plus Column
Column Input
Gets or sets columns to map with the direction Input
.
The key is required for operation such as BulkUpdate
and BulkMerge
.
context.BulkMerge(list, options =>
options.ColumnInputExpression = entity => new {entity.ID, entity.Code}
);
Column Output
Gets or sets columns to map with the direction Output
.
context.BulkMerge(list, options =>
options.ColumnOutputExpression = entity => new {entity.ModifiedDate, entity.ModifiedUser}
);
Column InputOutput
Gets or sets columns to map with the direction InputOutput
.
The key is required for operation such as BulkUpdate
and BulkMerge
.
context.BulkMerge(list, options =>
options.ColumnInputOutputExpression = entity => new {entity.ID, entity.Code}
);
Column Primary Key
Gets or sets columns to use as the key
for the operation.
context.BulkMerge(list, options =>
options.ColumnPrimaryKeyExpression = entity => new { entity.Code1, entity.Code2 }
);
Ignore On Merge Insert
Gets or sets columns to ignore when the BulkMerge
method executes the insert
statement.
context.BulkMerge(list, options =>
options.IgnoreOnMergeUpdateExpression = entity => new {entity.ModifiedDate, entity.ModifiedUser}
);
Ignore On Merge Update
Gets or sets columns to ignore when the BulkMerge
method executes the update
statement.
context.BulkMerge(list, options =>
options.IgnoreOnMergeUpdateExpression = entity => new {entity.CreatedDate, entity.CreatedUser}
);