search

oysteinkrog / SQLite.Net-PCL

Simple, powerful, cross-platform SQLite client and ORM - Updated version with PCL support
MIT License
353 stars 162 forks source link

Ability to do case insensitive OrderBy and ThenBy #339

Open igorkulman opened 7 years ago

igorkulman commented 7 years ago

SQLite supports doing case insensitive sorting using ORDER BY Column COLLATE NOCASE ASC. It would be nice to have the ability to use this in the OrderBy and ThenBy methods so we do not have to write queries by hand to use this.

smedvedev commented 7 years ago

Good suggestion, but pay attention to the fact that "COLLATE NOCASE" works only with ASCII. I would extend this issue with using expression in the OrderBy like ( t=> t.Name.ToLower()).