querybuilder
querybuilder copied to clipboard
[Breaking Change] string WhereX methods should not use the LOWER method by default
Currently SqlKata will try to apply a case insensitive operation, for WhereString operations, for example this query
var query = new Query("Car").WhereLike("Name", "AM");
will get translated to
SELECT * FROM [Car] WHERE LOWER([Name]) like 'am'
What requested is to keep the default behavior of the database, and only apply the transformation if explicitly needed
Acceptance Criteria:
- The default value for the
caseSensitiveforWhereLike,WhereStarts,WhereEndsshould betrueinstead offalse - The documentation should be updated to reflect this change
I agree with @ahmad-moussawi. Also, calling LOWER on every parameter has a significant performance overhead.