Skip to content
This repository has been archived by the owner on Apr 17, 2019. It is now read-only.

BulkDelete #14

Open
Mikado3780 opened this issue Apr 18, 2018 · 0 comments
Open

BulkDelete #14

Mikado3780 opened this issue Apr 18, 2018 · 0 comments
Assignees
@satano
Labels
area-Kros.Utils

Comments

@Mikado3780
Copy link
Collaborator

  • Deleted items will be in DbSet.EditedItems.
  • Items will be inserted by BulkInsert into temp table (be carefull about differences between MS SQL and MS Access, look at BulkInsert or BulkUpdate).
  • Then execute a query with join from temp table to source table.
  • This technique is significaly faster than executing query per item.
@Burgyn Burgyn mentioned this issue Apr 18, 2018
Open
@Burgyn Burgyn added this to the Kros.Utils v1.6.0 milestone Apr 25, 2018
@satano satano removed this from the Kros.Utils v1.6.0 milestone May 29, 2018
Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Assignees

@satano satano

Labels
area-Kros.Utils
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
3 participants
@satano @Burgyn @Mikado3780