Open
Description
for every table there is seven EF queries sent, in a case of SetOutputIdentity = true
which include IncludeGraph = true
- create table
- create output table
- alter columns
- merge to destination table
- select to retrieve the identity
- delete table
- delete output table
for a single table, this could be reduced, looking at the adapter code, it might be a matter of collecting the sql query and concatenating them together in a way that make sense to execute in batch
next issue about this is if there is a lot of tables, that series of query will be execute for each table, so if there is 100 tables, there will be 700 execute queries, if all the queries can be done in batch / grouped together it would reduce the chattyness of the bulk process