{"action":"opened","issue":{"url":"https://api.github.com/repos/linq2db/linq2db/issues/806","repository_url":"https://api.github.com/repos/linq2db/linq2db","labels_url":"https://api.github.com/repos/linq2db/linq2db/issues/806/labels{/name}","comments_url":"https://api.github.com/repos/linq2db/linq2db/issues/806/comments","events_url":"https://api.github.com/repos/linq2db/linq2db/issues/806/events","html_url":"https://github.com/linq2db/linq2db/issues/806","id":250920320,"number":806,"title":"Firebird: Multiple update or insert","user":{"login":"Franki1986","id":6066590,"avatar_url":"https://avatars2.githubusercontent.com/u/6066590?v=4","gravatar_id":"","url":"https://api.github.com/users/Franki1986","html_url":"https://github.com/Franki1986","followers_url":"https://api.github.com/users/Franki1986/followers","following_url":"https://api.github.com/users/Franki1986/following{/other_user}","gists_url":"https://api.github.com/users/Franki1986/gists{/gist_id}","starred_url":"https://api.github.com/users/Franki1986/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Franki1986/subscriptions","organizations_url":"https://api.github.com/users/Franki1986/orgs","repos_url":"https://api.github.com/users/Franki1986/repos","events_url":"https://api.github.com/users/Franki1986/events{/privacy}","received_events_url":"https://api.github.com/users/Franki1986/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2017-08-17T12:01:29Z","updated_at":"2017-08-17T12:01:29Z","closed_at":null,"body":"Hello,\r\n\r\nI would like to create a batch for a list. The BulkCopy does not work, because it has a limit for BulkCopyType.MultipleRows. So is there another way to create a batch?\r\nFirebird has the possibility to create an update or insert with matching columns.\r\nSo how could I create a metod that can be called like this : context.UpdateOrInsert(list);\r\n\r\nThat in the result sql creates something like this:\r\n\r\nUPDATE OR INSERT Table (ID, NAME, STREET) VALUES (1, \"MAX\", \"STREET 1\") MATCHING (ID);\r\nUPDATE OR INSERT Table (ID, NAME, STREET) VALUES (2, \"MAX_1\", \"STREET 2\") MATCHING (ID);\r\nUPDATE OR INSERT Table (ID, NAME, STREET) VALUES (3, \"MAX_2\", \"STREET 3\") MATCHING (ID);\r\n\r\nA creation of this SQL would be much faster.."}}
{"actor":{"display_login":"Franki1986"}}