RequiresSearchStringEscapeForLike DBDictionary Property
In previous releases, the default value for the property RequiresSearchStringEscapeForLike is true and caused the unexpected escape clause appended to the SQL statement. For example, user created a named query like this:
SELECT o.computerName FROM CompUser o WHERE o.name LIKE ?
At run time the following query is generated:
SELECT t0.computerName FROM CompUser t0 WHERE (t0.name LIKE ? ESCAPE '\')
ESCAPE '\' shouldn’t be appended to the query.
From the 2.3.0 release, RequiresSearchStringEscapeForLike property is set to false by default. You can configure RequiresSearchStringEscapeForLike property to be true if the old behavior is desired.