Skip to content

[Breaking Change] string WhereX methods should not use the LOWER method by default #610

@ahmad-moussawi

Description

@ahmad-moussawi

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 caseSensitive for WhereLike, WhereStarts, WhereEnds should be true instead of false
  • The documentation should be updated to reflect this change

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions