{"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":"open","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":1,"created_at":"2018-12-06T06:22:34Z","updated_at":"2018-12-07T16:11:30Z","closed_at":null,"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/445281030","html_url":"https://github.com/zzzprojects/EntityFramework-Plus/issues/440#issuecomment-445281030","issue_url":"https://api.github.com/repos/zzzprojects/EntityFramework-Plus/issues/440","id":445281030,"node_id":"MDEyOklzc3VlQ29tbWVudDQ0NTI4MTAzMA==","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-07T16:11:30Z","updated_at":"2018-12-07T16:11:30Z","author_association":"MEMBER","body":"Hello @FranklinBai ,\r\n\r\nThe v1.8.19 has been released.\r\n\r\nMy developer looked at it today and successfully implemented a solution.\r\n\r\nCould you try it and let me know if that's fixed on your side?\r\n\r\nBest Regards,\r\n\r\nJonathan"}}
{"actor":{"display_login":"JonathanMagnan"}}