Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

why the Update and delete Cannot Use the Temp Table? #49

Closed
MaxGorGor opened this issue Jun 8, 2018 · 2 comments
Closed

why the Update and delete Cannot Use the Temp Table? #49

MaxGorGor opened this issue Jun 8, 2018 · 2 comments
Labels

Comments

@MaxGorGor
Copy link

why the Update and delete Cannot Use the Temp Table?

@borisdj
Copy link
Owner

borisdj commented Jun 8, 2018

In code TableInfo.cs there is comment regarding this:

if (tableInfo.BulkConfig.UseTempDB == true && !isExplicitTransaction && operationType != OperationType.Insert)
{
    throw new InvalidOperationException("UseTempDB when set then BulkOperation has to be inside Transaction. More info in README of the library in GitHub.");
    // Otherwise throws exception: 'Cannot access destination table' (gets Dropped too early because transaction ends before operation is finished)
}

@borisdj
Copy link
Owner

borisdj commented Jul 13, 2018

Now they can with explicit transaction.
I have updated previous comment.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
None yet
Development

No branches or pull requests

2 participants