Skip to content

v3.12.2

Choose a tag to compare

View all tags
@JonathanMagnan JonathanMagnan released this 07 Jun 19:54
· 892 commits to master since this release
v3.12.2
094a6de

Download the library here

ADDED: MergeMatchedAndConditionExpression options for SQL Server.

By example, when specifying one or multiple key to add in the condition

ctx.BulkMerge(list, operation => 
   operation.MergeMatchedAndConditionExpression = entity => 
      new {entity.ColumnFakeKey1, entity.ColumnFakeKey2});

The MATCHED part is modified to ADD the condition expression specified.

WHEN MATCHED  AND DestinationTable.[ColumnFakeKey1] = StagingTable.[ColumnFakeKey1] AND DestinationTable.[ColumnFakeKey2] = StagingTable.[ColumnFakeKey2] THEN
    UPDATE
    SET     [ColumnFakeKey1] = StagingTable.[ColumnFakeKey1], [ColumnFakeKey2] = StagingTable.[ColumnFakeKey2], [ColumnInt] = StagingTable.[ColumnInt]

PRO Version unlocked for the current month (June)

Assets 2
Loading