{"action":"opened","issue":{"url":"https://api.github.com/repos/fsprojects/SQLProvider/issues/514","repository_url":"https://api.github.com/repos/fsprojects/SQLProvider","labels_url":"https://api.github.com/repos/fsprojects/SQLProvider/issues/514/labels{/name}","comments_url":"https://api.github.com/repos/fsprojects/SQLProvider/issues/514/comments","events_url":"https://api.github.com/repos/fsprojects/SQLProvider/issues/514/events","html_url":"https://github.com/fsprojects/SQLProvider/issues/514","id":293529772,"number":514,"title":"Oracle - unable to insert rows into table without primary key?","user":{"login":"RustyF","id":277341,"avatar_url":"https://avatars1.githubusercontent.com/u/277341?v=4","gravatar_id":"","url":"https://api.github.com/users/RustyF","html_url":"https://github.com/RustyF","followers_url":"https://api.github.com/users/RustyF/followers","following_url":"https://api.github.com/users/RustyF/following{/other_user}","gists_url":"https://api.github.com/users/RustyF/gists{/gist_id}","starred_url":"https://api.github.com/users/RustyF/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/RustyF/subscriptions","organizations_url":"https://api.github.com/users/RustyF/orgs","repos_url":"https://api.github.com/users/RustyF/repos","events_url":"https://api.github.com/users/RustyF/events{/privacy}","received_events_url":"https://api.github.com/users/RustyF/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2018-02-01T13:27:49Z","updated_at":"2018-02-01T13:27:49Z","closed_at":null,"author_association":"NONE","body":"I'm currently using the Oracle Provider to insert rows but hitting a KeyNotFoundException during ctx.SubmitUpdates().  I think is due to the table not having any primary key. I think this is the match expression in the ProcessUpdates() code that fails: -\r\n\r\n````\r\nmatch e.GetPkColumnOption primaryKeyColumn.[e.Table.Name].Column with\r\n| [] ->  e.SetPkColumnSilent(primaryKeyColumn.[e.Table.Name].Column, id)\r\n| _ -> () // if the primary key exists, do nothing\r\n          // this is because non-identity columns will have been set\r\n          // manually and in that case scope_identity would bring back 0 \"\" or whatever\r\n````\r\ni.e. there are no entries in the primary key dictionary keyed on the table name.  \r\n\r\nJust wondering if this is intentional or whether we need to account for this case?"}}
{"actor":{"display_login":"RustyF"}}