Maybe implement a bulkinsert/update is also a good idea?

[walaqi]

for mysql, insert into tableA (a,b,c) values (1,2,3), (3,4,5), (7,8,9). -- a is the primary key.
insert into tableA(a,b,c) values (1,2,3), (3,4,5), (7,8,9) on duplicate key b=values(b), c=values(c).

[tangdf]

@walaqi
Batching of Statement in Entity Framework Core
dotnet/efcore#9270

http://www.talkingdotnet.com/what-is-batching-of-statement-in-entity-framework-core/
http://www.cnblogs.com/tdfblog/p/batching-of-statement-in-entity-framework-core.html