{"action":"created","issue":{"url":"https://api.github.com/repos/zzzprojects/EntityFramework-Plus/issues/440","repository_url":"https://api.github.com/repos/zzzprojects/EntityFramework-Plus","labels_url":"https://api.github.com/repos/zzzprojects/EntityFramework-Plus/issues/440/labels{/name}","comments_url":"https://api.github.com/repos/zzzprojects/EntityFramework-Plus/issues/440/comments","events_url":"https://api.github.com/repos/zzzprojects/EntityFramework-Plus/issues/440/events","html_url":"https://github.com/zzzprojects/EntityFramework-Plus/issues/440","id":388073025,"node_id":"MDU6SXNzdWUzODgwNzMwMjU=","number":440,"title":"BatchUpdate number increment failing in Oracle","user":{"login":"FranklinBai","id":45649840,"node_id":"MDQ6VXNlcjQ1NjQ5ODQw","avatar_url":"https://avatars0.githubusercontent.com/u/45649840?v=4","gravatar_id":"","url":"https://api.github.com/users/FranklinBai","html_url":"https://github.com/FranklinBai","followers_url":"https://api.github.com/users/FranklinBai/followers","following_url":"https://api.github.com/users/FranklinBai/following{/other_user}","gists_url":"https://api.github.com/users/FranklinBai/gists{/gist_id}","starred_url":"https://api.github.com/users/FranklinBai/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/FranklinBai/subscriptions","organizations_url":"https://api.github.com/users/FranklinBai/orgs","repos_url":"https://api.github.com/users/FranklinBai/repos","events_url":"https://api.github.com/users/FranklinBai/events{/privacy}","received_events_url":"https://api.github.com/users/FranklinBai/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":{"login":"JonathanMagnan","id":23240780,"node_id":"MDQ6VXNlcjIzMjQwNzgw","avatar_url":"https://avatars0.githubusercontent.com/u/23240780?v=4","gravatar_id":"","url":"https://api.github.com/users/JonathanMagnan","html_url":"https://github.com/JonathanMagnan","followers_url":"https://api.github.com/users/JonathanMagnan/followers","following_url":"https://api.github.com/users/JonathanMagnan/following{/other_user}","gists_url":"https://api.github.com/users/JonathanMagnan/gists{/gist_id}","starred_url":"https://api.github.com/users/JonathanMagnan/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/JonathanMagnan/subscriptions","organizations_url":"https://api.github.com/users/JonathanMagnan/orgs","repos_url":"https://api.github.com/users/JonathanMagnan/repos","events_url":"https://api.github.com/users/JonathanMagnan/events{/privacy}","received_events_url":"https://api.github.com/users/JonathanMagnan/received_events","type":"User","site_admin":false},"assignees":[{"login":"JonathanMagnan","id":23240780,"node_id":"MDQ6VXNlcjIzMjQwNzgw","avatar_url":"https://avatars0.githubusercontent.com/u/23240780?v=4","gravatar_id":"","url":"https://api.github.com/users/JonathanMagnan","html_url":"https://github.com/JonathanMagnan","followers_url":"https://api.github.com/users/JonathanMagnan/followers","following_url":"https://api.github.com/users/JonathanMagnan/following{/other_user}","gists_url":"https://api.github.com/users/JonathanMagnan/gists{/gist_id}","starred_url":"https://api.github.com/users/JonathanMagnan/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/JonathanMagnan/subscriptions","organizations_url":"https://api.github.com/users/JonathanMagnan/orgs","repos_url":"https://api.github.com/users/JonathanMagnan/repos","events_url":"https://api.github.com/users/JonathanMagnan/events{/privacy}","received_events_url":"https://api.github.com/users/JonathanMagnan/received_events","type":"User","site_admin":false}],"milestone":null,"comments":4,"created_at":"2018-12-06T06:22:34Z","updated_at":"2018-12-08T18:45:56Z","closed_at":"2018-12-08T06:18:42Z","author_association":"NONE","body":"Info\r\nDatabase : Oracle 11gR2\r\nEntityFramework: 6.2.0\r\nZ.EntityFramework.Plus.EF6: 1.8.16\r\nOfficial Oracle ODP.NET, Managed Entity Framework Driver : 18.3.0\r\nDatabase First\r\n\r\nI need to increment number in EF6 using Batch update in Oracle database. Something like this:\r\n\r\nupdate PERSONS set AGE = AGE + 1;\r\n\r\nI tried:\r\n\r\ndbContext.PERSONS.Where(p => p.AGE < 20).Update(p => new PERSONS { AGE = p.AGE + 1 });\r\n\r\nBut it is failing in Oracle database I'm using. Simple number update works though.\r\n\r\ndbContext.PERSONS.Where(p => p.AGE < 20).Update(p => new PERSONS { AGE = 21 });\r\n\r\nCan you please have a look on it? Maybe I'm doing something wrong.\r\n\r\nThank you!"},"comment":{"url":"https://api.github.com/repos/zzzprojects/EntityFramework-Plus/issues/comments/445480941","html_url":"https://github.com/zzzprojects/EntityFramework-Plus/issues/440#issuecomment-445480941","issue_url":"https://api.github.com/repos/zzzprojects/EntityFramework-Plus/issues/440","id":445480941,"node_id":"MDEyOklzc3VlQ29tbWVudDQ0NTQ4MDk0MQ==","user":{"login":"JonathanMagnan","id":23240780,"node_id":"MDQ6VXNlcjIzMjQwNzgw","avatar_url":"https://avatars0.githubusercontent.com/u/23240780?v=4","gravatar_id":"","url":"https://api.github.com/users/JonathanMagnan","html_url":"https://github.com/JonathanMagnan","followers_url":"https://api.github.com/users/JonathanMagnan/followers","following_url":"https://api.github.com/users/JonathanMagnan/following{/other_user}","gists_url":"https://api.github.com/users/JonathanMagnan/gists{/gist_id}","starred_url":"https://api.github.com/users/JonathanMagnan/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/JonathanMagnan/subscriptions","organizations_url":"https://api.github.com/users/JonathanMagnan/orgs","repos_url":"https://api.github.com/users/JonathanMagnan/repos","events_url":"https://api.github.com/users/JonathanMagnan/events{/privacy}","received_events_url":"https://api.github.com/users/JonathanMagnan/received_events","type":"User","site_admin":false},"created_at":"2018-12-08T18:45:56Z","updated_at":"2018-12-08T18:45:56Z","author_association":"MEMBER","body":"Hello @brunom ,\r\n\r\nIf you have the same problem, please open a new issue.\r\n\r\nBest Regards,\r\n\r\nJonathan"}}
{"actor":{"display_login":"JonathanMagnan"}}