Using MSSQLDataService when updating objects with empty strings
MSSQLDataService converts empty strings to NULL when updating objects.
When building a limitations, if the argument in the equality check is passed String.Empty, the request will be generated as IS NULL and everything works as it should. This simplification eliminates the need to write complex Where clauses-expressions.
If there is a need to distinguish between NULL and String.Empty, it is possible to unasledovala from MSSQLDataService and override method
public virtual string ConvertSimpleValueToQueryValueString(object value)
so that was not replaced
if (valType == typeof(string))
{
if ((string)value == string.Empty)
return "NULL";
else
return "'" + value.ToString().Replace("'", """) + "'";
}
Special attention should be paid to this feature, if you use the imported data or the SQL statements that run in a bypass service data.