BulkUpdate is case insensitive

[yanzubenyan]

In batch update, the original value of the field is D18, L=1600. In this case, changing L to l will not update

[borisdj]

What Db are you using, I've tested it with both SqlServer and works fine.
Generated Sql:

UPDATE i SET [Description] = N'D18, l=1600'
FROM [Item] AS [i]
WHERE [i].[ItemId] <= 500

Maybe you Db is case insensitive or something.
Anyway if you can write a test where it would be reproducible.

[yanzubenyan]

[yanzubenyan]

Just like in the picture, my l update to the sqlserver database is still L

[borisdj]

I see the issue is actually BulkUpdate and not BatchUpdate, but still I'm not able to reproduce it.

[yanzubenyan]

text.zip

[borisdj]

Quite peculiar issue.
BulkUpdate uses MERGE that has EXISTS to skip updating same rows, but in this case seems that sql comparison L to l is same, probably because of collation: 'Chinese_PRC_CI_AS'.
With BulkConfig OmitClauseExistsExcept it can be turned of, just call it like this:
await _baseBomDetailRep.Context.BulkUpdateAsync(bulckall, new BulkConfig { OmitClauseExistsExcept = true });

[yanzubenyan]

thank you for your answer