Column


Column Input

Gets or sets columns to map with the direction Input.

The key is required for operation such as BulkUpdate and BulkMerge.

Read more: Column Input

Example

context.BulkMerge(list, options => 
        options.ColumnInputExpression = entity => new {entity.ID, entity.Code}
); 

Column Output

Gets or sets columns to map with the direction Output.

Read more: Column Output

Example

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.

Read more: Column InputOutput

Example

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.

Read more: Column Primary Key

Example

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 execute the insert statement.

Read more: Column Ignore on Merge Insert

Example

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 execute the update statement.

Read more: Column Ignore on Merge Update

Example

context.BulkMerge(list, options => 
        options.IgnoreOnMergeUpdateExpression = entity => new {entity.CreatedDate, entity.CreatedUser}
);