If you are dealing with large datasets then use Entity Framework Extensions library to perform bulk operations in the database, see the tutorial link.
.NET 10.0
Install Z.EntityFramework.Extensions.EFCor and Microsoft.EntityFrameworkCore.SqlServer packages from NuGet. Inside the "CSV Files" you will find bulk csv files which you can use for testing purpose.
The following things are implemented in this repository:
- Bulk Inserting a large CSV file on SQL Server Database
- Copying large DB data from one Table to another Table
- Bulk Updates and Deletion
- BulkInsert BulkMerge BulkDelete
Your support of every $5 will be a great reward for me to carry on my work. Thank you !
