What’s the best way to insert a bulk number of

Question

What’s the best way to insert a bulk number of

rows into ms sql server using ef core
I have like 28k rows need to be inserted and it should go in a transaction with other operation there are other computation as well
Should I need to loop through that 28k data and call insert operation directly ?

0

14.03.2024

4 ответов

21 просмотр

QWxp

Mr Thieves
you have two options: 1. loop all 25k and do what ...

bulk update/insert was a builtin ext in ef 7|8 iirc

0

9 месяцев назад

Mr Thieves

QWxp
bulk update/insert was a builtin ext in ef 7|8 iir...

Стикер

0

9 месяцев назад

QWxp

https://learn.microsoft.com/en-us/ef/core/saving/execute-insert-update-delete

0

9 месяцев назад

Mr Thieves · Accepted Answer

Mr Thieves

you have two options: 1. loop all 25k and do what you want and add it one by one. 2. or using this premium package for do what you want https://entityframework-extensions.net/bulk-insert

0

9 месяцев назад

Похожие чаты

What’s the best way to insert a bulk number of

4 ответов

Похожие вопросы