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

Try it online

Column Output

Gets or sets columns to map with the direction Output.

context.BulkMerge(list, options => 
        options.ColumnOutputExpression = entity => new {entity.ModifiedDate, entity.ModifiedUser}
); 

Try it online

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

Try it online

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

Try it online

Ignore On Merge Insert

Gets or sets columns to ignore when the BulkMerge method executes the insert statement.

context.BulkMerge(list, options => 
        options.IgnoreOnMergeInsertExpression = entity => new {entity.ModifiedDate, entity.ModifiedUser}
); 

Try it online

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

Try it online