To bulk operation sql server, it have a high efficiency. Bulk insert 1,000,000 records just need 20 seconds How to use it: using LF.EntityFramework.Extention; BulkExecuteOption.SingleTaskMaxCount = 10000;//more than 10000 entities start multiple threads BulkExecuteOption.TaskCount = 10; //threads count for bulk do it ------.net framework 4.5.2 above DBcontext.BulkInsert(IEnumrobleEntities) DBcontext.BulkUpdate(IEnumrobleEntities) DBcontext.BulkDelete(IEnumrobleEntities) ------.net 8.0 above var option =new BulkExecutionOptions { ContextFactory=()=> new AppDbContext(), MaxDegreeOfParallelism=2}; //new a dbcontext var option =new BulkExecutionOptions { ContextFactory = () => _factory.CreateDbContext(), MaxDegreeOfParallelism=2}; //注入dbcontext工厂 DBcontext.BulkInsert(IEnumrobleEntities,option) DBcontext.BulkUpdate(IEnumrobleEntities,option) DBcontext.BulkDelete(IEnumrobleEntities,option)
$ dotnet add package LF.EntityFramework.ExtentionNo README available.