Merge Matching on Null about efcore.bulkextensions HOT 3 CLOSED

The problem here is that Sql does not compare Null values:
AND T.[Name] = S.[Name]
is False even when both are null.
But this could be changed to something like:
AND (T.[Name] = S.[Name] OR (T.[Name] IS NULL AND S.[Name] IS NULL))
Then it should work. I will see to fix this soon.

In the meanwhile you can make a workaround by doing 2 updates, where first will have list of those that do not have Null in that column which will be included in UpdateByProperties, while second Update will have only those with Null in that column and that operation will Not have this Property in UpdateByProperties.

from efcore.bulkextensions.

UpdateByProperties Nullable support added in version 2.0.9

from efcore.bulkextensions.

UPDATE: 2.0.9 has bug NullReference Exception.
Upgrade to EF Core 2.1 and use Nuget 2.1.0

from efcore.bulkextensions.