What is the fastest way to send a large amount of data from ASP.NET to MSSQL?

Question

ASP.NET

Hello, I faced the task of periodically uploading a large amount of data to SQL.
Pour it all through the for loop and LINQ is a bit of a moronic idea because it takes too much time and resources.
Is there any ready-made mechanism for this task?
In my thoughts so far, only generating a .sql dump using ASP.NET, saving it to a file and then uploading it to the database through SQL Server.

Answer 1

Bulk insert / openrowset