Our great sponsors
-
EFCore.BulkExtensions
Entity Framework EF Core efcore Bulk Batch Extensions with BulkCopy in .Net for Insert Update Delete Read (CRUD), Truncate and SaveChanges operations on SQL Server, PostgreSQL, MySQL, SQLite
-
bulk-writer
Provides guidance for fast ETL jobs, an IDataReader implementation for SqlBulkCopy (or the MySql or Oracle equivalents) that wraps an IEnumerable, and libraries for mapping entites to table columns.
-
WorkOS
The modern identity platform for B2B SaaS. The APIs are flexible and easy-to-use, supporting authentication, user identity, and complex enterprise features like SSO and SCIM provisioning.
EF Core works for me and inserting/updating several thousand records at a time. I also found this nuget that works great https://github.com/borisdj/EFCore.BulkExtensions
You can check out my BulkWriter library: https://github.com/jbogard/bulk-writer it’s basically “LINQ-2-SqlBulkInsert”.