{"action":"opened","issue":{"url":"https://api.github.com/repos/borisdj/EFCore.BulkExtensions/issues/59","repository_url":"https://api.github.com/repos/borisdj/EFCore.BulkExtensions","labels_url":"https://api.github.com/repos/borisdj/EFCore.BulkExtensions/issues/59/labels{/name}","comments_url":"https://api.github.com/repos/borisdj/EFCore.BulkExtensions/issues/59/comments","events_url":"https://api.github.com/repos/borisdj/EFCore.BulkExtensions/issues/59/events","html_url":"https://github.com/borisdj/EFCore.BulkExtensions/issues/59","id":340742959,"node_id":"MDU6SXNzdWUzNDA3NDI5NTk=","number":59,"title":"tableInfo.BulkConfig.UseTempDB = false;","user":{"login":"tb0pl","id":29332403,"node_id":"MDQ6VXNlcjI5MzMyNDAz","avatar_url":"https://avatars2.githubusercontent.com/u/29332403?v=4","gravatar_id":"","url":"https://api.github.com/users/tb0pl","html_url":"https://github.com/tb0pl","followers_url":"https://api.github.com/users/tb0pl/followers","following_url":"https://api.github.com/users/tb0pl/following{/other_user}","gists_url":"https://api.github.com/users/tb0pl/gists{/gist_id}","starred_url":"https://api.github.com/users/tb0pl/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/tb0pl/subscriptions","organizations_url":"https://api.github.com/users/tb0pl/orgs","repos_url":"https://api.github.com/users/tb0pl/repos","events_url":"https://api.github.com/users/tb0pl/events{/privacy}","received_events_url":"https://api.github.com/users/tb0pl/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2018-07-12T18:09:54Z","updated_at":"2018-07-12T18:09:54Z","closed_at":null,"author_association":"NONE","body":"Would it be possible for you to remove the following line of code? The code works fine without it if used within explicit transaction. The line causes issue in Sql Server since it requires account to have high privilege like db_owner or similar since normal tables are used as temp tables in merge operation and have to be created and dropped.\r\n\r\n```c#\r\nif (operationType != OperationType.Insert)\r\n            {\r\n                tableInfo.BulkConfig.UseTempDB = false; // TempDB can only be used with Insert.\r\n                // Other Operations done with customTemp table.\r\n                // If using tempdb[#] throws exception: 'Cannot access destination table' (gets Droped too early, probably because transaction ends)\r\n            }\r\n```\r\n"}}
{"actor":{"display_login":"tb0pl"}}