Load CSV to MS SQL Server 500x Faster with C# Bulk Insert
Stop wasting time with slow database inserts! In this video, we dive deep into the world of high-performance data handling. We’ll show you how to take a CSV file with thousands of rows and blast it into an MSSQL database using C# in just a fraction of a second.
We don't just show you the "fast way" we prove it. Watch a real-time head-to-head battle between the traditional foreach loop and the powerhouse SqlBulkCopy.
What you’ll learn in this video:
✅ Data Generation: How to use Random.Shared in .NET 10 to generate sample CSV data efficiently.
✅ The "Slow" Way: Why row-by-row insertion via foreach kills your performance.
✅ The "Pro" Way: Implementing Bulk Insert by converting generic lists to DataTable and mapping columns.
✅ Performance Benchmarking: Using Stopwatch to see the massive difference in milliseconds.
Resources & Links:
📌 How to run MSSQL on Docker: • Install Docker on Mac & RDBMS on Docker | ...
📌 VS Code SQL Server Extension Setup: • How to Install and Use the MSSQL Server Ex...
📌 .NET Environment Setup in VS Code: • C# with Visual Studio Code on Mac | Set Up...
📌 Command: dotnet add package Microsoft.Data.SqlClient --prerelease
Chapters:
00:00 Introduction
00:52 Create a database and table
02:05 Create a console app
02:45 Install SqlClient NuGet package
03:31 Generate CSV file
04:05 Insert data via foreach
04:31 Read CSV file
04:59 Truncate table data
05:06 Bulk Insert
06:15 Check the results