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.

Sign up for GitHub

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

Jump to bottom

Support for ExecuteUpdate/Delete which spans multiple tables (TPT, TPC...) #28520

Open
smitpatel opened this issue Jul 26, 2022 · 3 comments
Open

Support for ExecuteUpdate/Delete which spans multiple tables (TPT, TPC...) #28520

smitpatel opened this issue Jul 26, 2022 · 3 comments
Labels
area-bulkcud customer-reported type-enhancement
Milestone
Backlog

Comments

@smitpatel
Copy link
Member

  • TPT
  • Entity splitting
  • TPC (when the delete is not based on key)

We can support via multiple commands in same batch. Could be complicated to figure out the rows affect count depending on the meaning of it. Delete is somewhat easier but Update could be tricky as we need to figure out which property set goes where.
@ajcvickers ajcvickers added this to the Backlog milestone Jul 28, 2022
@smitpatel
Copy link
Member Author

Also keep in mind that if we start sending multiple commands then we need to add transaction around it.

This was referenced Jul 30, 2022
Merged
Closed
@roji roji mentioned this issue Nov 23, 2022
Closed
@roji roji changed the title Support for Bulk Update/Delete which spans multiple tables Support for ExecuteUpdate/Delete which spans multiple tables (TPT, TPC...) Nov 23, 2022
@kev24uk

This comment was marked as off-topic.

Sign in to view
@roji

This comment was marked as off-topic.

Sign in to view
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
area-bulkcud customer-reported type-enhancement
Projects
None yet
Milestone
Backlog
Development

No branches or pull requests
4 participants
@ajcvickers @smitpatel @roji @kev24uk