LF.EntityFramework.Extention
2.0.1
dotnet add package LF.EntityFramework.Extention --version 2.0.1
NuGet\Install-Package LF.EntityFramework.Extention -Version 2.0.1
<PackageReference Include="LF.EntityFramework.Extention" Version="2.0.1" />
<PackageVersion Include="LF.EntityFramework.Extention" Version="2.0.1" />
<PackageReference Include="LF.EntityFramework.Extention" />
paket add LF.EntityFramework.Extention --version 2.0.1
#r "nuget: LF.EntityFramework.Extention, 2.0.1"
#:package LF.EntityFramework.Extention@2.0.1
#addin nuget:?package=LF.EntityFramework.Extention&version=2.0.1
#tool nuget:?package=LF.EntityFramework.Extention&version=2.0.1
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)
| Product | Versions Compatible and additional computed target framework versions. |
|---|---|
| .NET | net8.0 is compatible. net8.0-android was computed. net8.0-browser was computed. net8.0-ios was computed. net8.0-maccatalyst was computed. net8.0-macos was computed. net8.0-tvos was computed. net8.0-windows was computed. net9.0 was computed. net9.0-android was computed. net9.0-browser was computed. net9.0-ios was computed. net9.0-maccatalyst was computed. net9.0-macos was computed. net9.0-tvos was computed. net9.0-windows was computed. net10.0 was computed. net10.0-android was computed. net10.0-browser was computed. net10.0-ios was computed. net10.0-maccatalyst was computed. net10.0-macos was computed. net10.0-tvos was computed. net10.0-windows was computed. |
| .NET Framework | net45 is compatible. net451 was computed. net452 was computed. net46 was computed. net461 was computed. net462 was computed. net463 was computed. net47 was computed. net471 was computed. net472 was computed. net48 was computed. net481 was computed. |
-
.NETFramework 4.5.2
- EntityFramework (>= 6.4.4)
-
net8.0
- Microsoft.Data.SqlClient (>= 6.1.4)
- Microsoft.EntityFrameworkCore (>= 9.0.13)
- Microsoft.EntityFrameworkCore.Relational (>= 9.0.13)
- Microsoft.EntityFrameworkCore.SqlServer (>= 9.0.13)
NuGet packages
This package is not used by any NuGet packages.
GitHub repositories
This package is not used by any popular GitHub repositories.
Faster than Faster, Bulk insert 1,000,000 records just need 20 seconds,.net 8.0 supported