Is there any difference in performance when you add a huge amount of data into the database using EF Core (row by row) or using SQL Server stored procedures?
-
I have a data table with around 13000 rows. I want to add all of them to the database. Which method has the best performance, using C# and EF Core or using SQL Server stored procedures?
You're neglecting the specifics; e.g. SQL Server / EF Bulk Insert.
"Before entering on an understanding, I have meditated for a long time, and have foreseen what might happen. It is not genius which reveals to me suddenly, secretly, what I have to say or to do in a circumstance unexpected by other people; it is reflection, it is meditation." - Napoleon I
-
I have a data table with around 13000 rows. I want to add all of them to the database. Which method has the best performance, using C# and EF Core or using SQL Server stored procedures?
[BULK INSERT (Transact-SQL) - SQL Server | Microsoft Docs](https://docs.microsoft.com/en-us/sql/t-sql/statements/bulk-insert-transact-sql?view=sql-server-ver15)