payload: {"action":"created","issue":{"url":"https://api.github.com/repos/npgsql/Npgsql.EntityFrameworkCore.PostgreSQL/issues/999","repository_url":"https://api.github.com/repos/npgsql/Npgsql.EntityFrameworkCore.PostgreSQL","labels_url":"https://api.github.com/repos/npgsql/Npgsql.EntityFrameworkCore.PostgreSQL/issues/999/labels{/name}","comments_url":"https://api.github.com/repos/npgsql/Npgsql.EntityFrameworkCore.PostgreSQL/issues/999/comments","events_url":"https://api.github.com/repos/npgsql/Npgsql.EntityFrameworkCore.PostgreSQL/issues/999/events","html_url":"https://github.com/npgsql/Npgsql.EntityFrameworkCore.PostgreSQL/issues/999","id":485665160,"node_id":"MDU6SXNzdWU0ODU2NjUxNjA=","number":999,"title":"If the database provider is something else from PostgreSql ILIKE should do like","user":{"login":"xrkolovos","id":517802,"node_id":"MDQ6VXNlcjUxNzgwMg==","avatar_url":"https://avatars2.githubusercontent.com/u/517802?v=4","gravatar_id":"","url":"https://api.github.com/users/xrkolovos","html_url":"https://github.com/xrkolovos","followers_url":"https://api.github.com/users/xrkolovos/followers","following_url":"https://api.github.com/users/xrkolovos/following{/other_user}","gists_url":"https://api.github.com/users/xrkolovos/gists{/gist_id}","starred_url":"https://api.github.com/users/xrkolovos/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/xrkolovos/subscriptions","organizations_url":"https://api.github.com/users/xrkolovos/orgs","repos_url":"https://api.github.com/users/xrkolovos/repos","events_url":"https://api.github.com/users/xrkolovos/events{/privacy}","received_events_url":"https://api.github.com/users/xrkolovos/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2019-08-27T08:32:42Z","updated_at":"2019-08-27T09:24:27Z","closed_at":null,"author_association":"NONE","body":"We have a project that supports mssql, mariadb and PostgreSql.\r\n\r\nIn our c# code we use like. We want to change everywhere that we have LIKE to ILIKE so it can work as we want in PostgreSql. If we do this we see that in other dadabases it loads all rows in memory and then executes in c# the operation. It works, but not in sql level.\r\n\r\nSo, can you execute like when the providers aren't PostgreSql? \r\n\r\nOr otherwise, is there a way EF.Functions.Like executing ILIKE in PostgreSql?"},"comment":{"url":"https://api.github.com/repos/npgsql/Npgsql.EntityFrameworkCore.PostgreSQL/issues/comments/525219067","html_url":"https://github.com/npgsql/Npgsql.EntityFrameworkCore.PostgreSQL/issues/999#issuecomment-525219067","issue_url":"https://api.github.com/repos/npgsql/Npgsql.EntityFrameworkCore.PostgreSQL/issues/999","id":525219067,"node_id":"MDEyOklzc3VlQ29tbWVudDUyNTIxOTA2Nw==","user":{"login":"roji","id":1862641,"node_id":"MDQ6VXNlcjE4NjI2NDE=","avatar_url":"https://avatars0.githubusercontent.com/u/1862641?v=4","gravatar_id":"","url":"https://api.github.com/users/roji","html_url":"https://github.com/roji","followers_url":"https://api.github.com/users/roji/followers","following_url":"https://api.github.com/users/roji/following{/other_user}","gists_url":"https://api.github.com/users/roji/gists{/gist_id}","starred_url":"https://api.github.com/users/roji/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/roji/subscriptions","organizations_url":"https://api.github.com/users/roji/orgs","repos_url":"https://api.github.com/users/roji/repos","events_url":"https://api.github.com/users/roji/events{/privacy}","received_events_url":"https://api.github.com/users/roji/received_events","type":"User","site_admin":false},"created_at":"2019-08-27T09:24:27Z","updated_at":"2019-08-27T09:24:27Z","author_association":"MEMBER","body":"If you want to perform case-insensitive searches/comparisons, you may want to take a look at the PostgreSQL [`CITEXT`](https://www.postgresql.org/docs/current/citext.html) type for your columns. This type had numerous issues in previous versions of EF Core, but thanks to version 3.0's type inference it will work much better. Note that switching to this means that *all* comparisons will be insensitive, not just LIKE.\r\n\r\nOtherwise there is currently no way to make EF.Functions.Like translate to ILIKE - the EF Core provider simply translates to LIKE, which on PostgreSQL is case-sensitive like everything else. In general EF Core doesn't exactly aim to make your code behave in an identical way across database.\r\n\r\n/cc @divega, we had this discussion some time ago."}}
other: {"actor":{"display_login":"roji"}}