ninjanye
ignore case for IQueryable
Some databases, such as Postgre is case sensitive.
You could implement case insensitive queries for IQueryable, by using toLower before applying filter clause. I implemented it on my own branch on 'contains', I could share it here if you want.
There is small example:
This is certainly a good new feature. Be good to have it as a configurable option though. e.g.
context.Search(x => x.String1).CaseInsensitive().Contains("TeSt");
I'll can try and look at this in more detail and get something pushed through.
Yes, I made it in my branch, it just have different name. In my project it's called IgnoreCase()
That sounds good. Have you implemented it for all comparison methods (e.g. .StartsWith, .Contains, .EndsWith etc?) or just the contains method? If it's all done, feel free to submit a PR.
Hi! Where is a solution because I cannot find it? I want to have possibility to decide about case sensitive or case insensitive comparison especially when it comes to Containing. Thanks in advanced
What Db engine do you use?
On Fri, 26 Jun 2020, 23:41 PatryxCShark, [email protected] wrote:
Hi! Where is a solution because I cannot find it? I want to have possibility to decide about case sensitive or case insensitive comparison especially when it comes to Containing. Thanks in advanced
— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub https://github.com/ninjanye/SearchExtensions/issues/15#issuecomment-650391038, or unsubscribe https://github.com/notifications/unsubscribe-auth/ABCD4FX2Q3UKRO6Q5VXSA3TRYUBYXANCNFSM4CYUPRZQ .
MS SQL, but sometimes I have IQueryable which is done in memory. If I know is process on memory side, should I do IQueryable.AsEnumerable() and then use SetCulture?
Ms sql is case insensitive. This change is required only for DB engines who are case sensitive, for example postgres sql.
On Sat, 27 Jun 2020, 00:03 PatryxCShark, [email protected] wrote:
MS SQL, but sometimes I have IQueryable which is done in memory. If I know is process on memory side, should I do IQueryable.AsEnumerable() and then use SetCulture?
— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub https://github.com/ninjanye/SearchExtensions/issues/15#issuecomment-650400068, or unsubscribe https://github.com/notifications/unsubscribe-auth/ABCD4FUWVZE7P764AQ7KGQTRYUEKHANCNFSM4CYUPRZQ .