View All Blog Posts

Empty String and NULL Behaviour

26 November 2012

By Default Data Sync detects NULL and an Empty String as a difference, however certain Data Sources such as CSV and SharePoint cannot differentiate between NULL and Empty String. Therefore we automatically override this behaviour for you when using these providers.

If you want to force NULL and Empty String to be considered Equal during the comparison you can do this within the Project Automation feature. Simply set the Property EmptyStringAndNullAreEqual to True on one of the Data source Tables using the BeforeCompare Method.

For Example

Project Automation

public override void BeforeCompare(ProjectAutomationLoadResult loadResult)
    loadResult.TableA.EmptyStringAndNullAreEqual = true;
| |