Extremely easy way to bulk insert data into SQL Server using SqlBulkCopy class

Insert bulk data into the SQL Server table from an in-memory source or another database table using the SqlBulkCopy class.

00:00 - Introduction
00:32 - Create a new instance of SqlBulkCopy class
01:04 - Different useful properties of SqlBulkCopy class
03:30 - The main method for writing bulk data
04:20 - Using DataTable for bulk insert
07:30 - Using DataReader for bulk insert
10:05 - EnableStreamin property of SqlBulkCopy class

#csharp #dotnet #sqlserver

Some of my popular videos:

Elasticsearch with .NET and introduction: https://youtu.be/9tkrDqMbFMg

Hangfire Scheduling an introduction: https://youtu.be/sQyY0xvJ4-o

ASP.NET Core Authentication with JWT (JSON Web Token): https://youtu.be/vWkPdurauaA

Running Background tasks using IHostedService and BackgroundService (In ASP.NET Core 3.1): https://youtu.be/1Fe7QD7Ovi8

How to build an API Gateway in ASP.NET Core using Ocelot (Build API Gateway in a few minutes): https://youtu.be/hlUGZ6Hmv6s

My blog site: https://dotnetcorecentral.com

Видео Extremely easy way to bulk insert data into SQL Server using SqlBulkCopy class канала DotNet Core Central