{"action":"created","issue":{"url":"https://api.github.com/repos/npgsql/Npgsql.EntityFrameworkCore.PostgreSQL/issues/1010","repository_url":"https://api.github.com/repos/npgsql/Npgsql.EntityFrameworkCore.PostgreSQL","labels_url":"https://api.github.com/repos/npgsql/Npgsql.EntityFrameworkCore.PostgreSQL/issues/1010/labels{/name}","comments_url":"https://api.github.com/repos/npgsql/Npgsql.EntityFrameworkCore.PostgreSQL/issues/1010/comments","events_url":"https://api.github.com/repos/npgsql/Npgsql.EntityFrameworkCore.PostgreSQL/issues/1010/events","html_url":"https://github.com/npgsql/Npgsql.EntityFrameworkCore.PostgreSQL/issues/1010","id":489065361,"node_id":"MDU6SXNzdWU0ODkwNjUzNjE=","number":1010,"title":"NodaTime Date Math will be translated locally","user":{"login":"schmitch","id":1641401,"node_id":"MDQ6VXNlcjE2NDE0MDE=","avatar_url":"https://avatars1.githubusercontent.com/u/1641401?v=4","gravatar_id":"","url":"https://api.github.com/users/schmitch","html_url":"https://github.com/schmitch","followers_url":"https://api.github.com/users/schmitch/followers","following_url":"https://api.github.com/users/schmitch/following{/other_user}","gists_url":"https://api.github.com/users/schmitch/gists{/gist_id}","starred_url":"https://api.github.com/users/schmitch/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/schmitch/subscriptions","organizations_url":"https://api.github.com/users/schmitch/orgs","repos_url":"https://api.github.com/users/schmitch/repos","events_url":"https://api.github.com/users/schmitch/events{/privacy}","received_events_url":"https://api.github.com/users/schmitch/received_events","type":"User","site_admin":false},"labels":[{"id":355737759,"node_id":"MDU6TGFiZWwzNTU3Mzc3NTk=","url":"https://api.github.com/repos/npgsql/Npgsql.EntityFrameworkCore.PostgreSQL/labels/bug","name":"bug","color":"ee0701","default":true}],"state":"open","locked":false,"assignee":{"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},"assignees":[{"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}],"milestone":{"url":"https://api.github.com/repos/npgsql/Npgsql.EntityFrameworkCore.PostgreSQL/milestones/20","html_url":"https://github.com/npgsql/Npgsql.EntityFrameworkCore.PostgreSQL/milestone/20","labels_url":"https://api.github.com/repos/npgsql/Npgsql.EntityFrameworkCore.PostgreSQL/milestones/20/labels","id":3754747,"node_id":"MDk6TWlsZXN0b25lMzc1NDc0Nw==","number":20,"title":"3.0.0","description":null,"creator":{"login":"austindrenski","id":21338699,"node_id":"MDQ6VXNlcjIxMzM4Njk5","avatar_url":"https://avatars3.githubusercontent.com/u/21338699?v=4","gravatar_id":"","url":"https://api.github.com/users/austindrenski","html_url":"https://github.com/austindrenski","followers_url":"https://api.github.com/users/austindrenski/followers","following_url":"https://api.github.com/users/austindrenski/following{/other_user}","gists_url":"https://api.github.com/users/austindrenski/gists{/gist_id}","starred_url":"https://api.github.com/users/austindrenski/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/austindrenski/subscriptions","organizations_url":"https://api.github.com/users/austindrenski/orgs","repos_url":"https://api.github.com/users/austindrenski/repos","events_url":"https://api.github.com/users/austindrenski/events{/privacy}","received_events_url":"https://api.github.com/users/austindrenski/received_events","type":"User","site_admin":false},"open_issues":8,"closed_issues":31,"state":"open","created_at":"2018-10-21T18:00:51Z","updated_at":"2019-09-04T13:59:41Z","due_on":null,"closed_at":null},"comments":1,"created_at":"2019-09-04T10:06:03Z","updated_at":"2019-09-04T15:34:41Z","closed_at":null,"author_association":"NONE","body":"Currently having something like that:\r\n\r\n`oc.Order.ActivationDate.Plus(Period.FromMonths(1))`\r\n\r\nor\r\n`oc.Order.ActivationDate.PlusMonths(1)`\r\n\r\nwill \"warn\"(fail in 3.0) with:\r\n\r\n` The LINQ expression 'where ([oc].ActivationDate.Plus(__FromMonths_3) >= __nowLocalDate_4)' could not be translated and will be evaluated locally.`\r\n\r\nit would be great if that would be supported since `DateTime.Add` is supported aswell."},"comment":{"url":"https://api.github.com/repos/npgsql/Npgsql.EntityFrameworkCore.PostgreSQL/issues/comments/527956154","html_url":"https://github.com/npgsql/Npgsql.EntityFrameworkCore.PostgreSQL/issues/1010#issuecomment-527956154","issue_url":"https://api.github.com/repos/npgsql/Npgsql.EntityFrameworkCore.PostgreSQL/issues/1010","id":527956154,"node_id":"MDEyOklzc3VlQ29tbWVudDUyNzk1NjE1NA==","user":{"login":"schmitch","id":1641401,"node_id":"MDQ6VXNlcjE2NDE0MDE=","avatar_url":"https://avatars1.githubusercontent.com/u/1641401?v=4","gravatar_id":"","url":"https://api.github.com/users/schmitch","html_url":"https://github.com/schmitch","followers_url":"https://api.github.com/users/schmitch/followers","following_url":"https://api.github.com/users/schmitch/following{/other_user}","gists_url":"https://api.github.com/users/schmitch/gists{/gist_id}","starred_url":"https://api.github.com/users/schmitch/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/schmitch/subscriptions","organizations_url":"https://api.github.com/users/schmitch/orgs","repos_url":"https://api.github.com/users/schmitch/repos","events_url":"https://api.github.com/users/schmitch/events{/privacy}","received_events_url":"https://api.github.com/users/schmitch/received_events","type":"User","site_admin":false},"created_at":"2019-09-04T15:34:41Z","updated_at":"2019-09-04T15:34:41Z","author_association":"NONE","body":"well that is really helpful. Unfortunatly the code I would've needed would have looked like that:\r\n`new LocalDate(oc.Order.ActivationDate.Year, oc.Order.ActivationDate.Month, 15) + Period.FromMonths(1)`\r\n\r\nbut `new LocalDate` can't be translated, too. (with recent postgres versions Npgsql could translate it to `make_date` I guess)\r\n\r\nSo in the end I created a `DbFunction` that will do what I wanted.\r\nIf you think that's worth another issue aswell, I would create one. \r\n(I think I should also look into the source code, maybe I can try to fix it by myself)"}}
{"actor":{"display_login":"schmitch"}}