首頁>.NET源碼>其他類別
下載

EntityFrameWorkcore.sqlserver.simplebulks

一個非常簡單的.NET核心庫，可以幫助使用SQLBulkCopy類將大量記錄中的記錄同步到數據庫中。

概述

該庫提供擴展方法，以便您可以與EntityFrameWorkCore DBContext Instance dbContextExtensions.cs一起使用，也可以使用sqlConnectionExtensions.cs直接與SQLConnection實例直接使用，而無需使用EntityFrameWorkCore。

nuget

https://www.nuget.org/packages/entityframeworkcore.sqlserver.simplebulks

特徵

  • 散裝插入
  • 批量更新
  • 批量刪除
  • 批量合併
  • 散裝比賽
  • 臨時表
  • 直接插入
  • 直接更新
  • 直接刪除

例子

EntityFrameWorkcore.sqlserver.simplebulks.demo

  • 更新連接字符串： 
     private const string _connectionString = "Server=.;Database=SimpleBulks;User Id=xxx;Password=xxx" ;
  • 構建和運行。

dbContextExtensions

使用lambda表達式

 using EntityFrameworkCore . SqlServer . SimpleBulks . BulkDelete ;
using EntityFrameworkCore . SqlServer . SimpleBulks . BulkInsert ;
using EntityFrameworkCore . SqlServer . SimpleBulks . BulkMerge ;
using EntityFrameworkCore . SqlServer . SimpleBulks . BulkUpdate ;

// Insert all columns
dbct . BulkInsert ( rows ) ;
dbct . BulkInsert ( compositeKeyRows ) ;

// Insert selected columns only
dbct . BulkInsert ( rows ,
    row => new { row . Column1 , row . Column2 , row . Column3 } ) ;
dbct . BulkInsert ( compositeKeyRows ,
    row => new { row . Id1 , row . Id2 , row . Column1 , row . Column2 , row . Column3 } ) ;

dbct . BulkUpdate ( rows ,
    row => new { row . Column3 , row . Column2 } ) ;
dbct . BulkUpdate ( compositeKeyRows ,
    row => new { row . Column3 , row . Column2 } ) ;

dbct . BulkMerge ( rows ,
    row => row . Id ,
    row => new { row . Column1 , row . Column2 } ,
    row => new { row . Column1 , row . Column2 , row . Column3 } ) ;
dbct . BulkMerge ( compositeKeyRows ,
    row => new { row . Id1 , row . Id2 } ,
    row => new { row . Column1 , row . Column2 , row . Column3 } ,
    row => new { row . Id1 , row . Id2 , row . Column1 , row . Column2 , row . Column3 } ) ;
                        
dbct . BulkDelete ( rows ) ;
dbct . BulkDelete ( compositeKeyRows ) ;

使用動態字符串

 using EntityFrameworkCore . SqlServer . SimpleBulks . BulkDelete ;
using EntityFrameworkCore . SqlServer . SimpleBulks . BulkInsert ;
using EntityFrameworkCore . SqlServer . SimpleBulks . BulkMerge ;
using EntityFrameworkCore . SqlServer . SimpleBulks . BulkUpdate ;

dbct . BulkUpdate ( rows ,
    [ "Column3" , "Column2" ] ) ;
dbct . BulkUpdate ( compositeKeyRows ,
    [ "Column3" , "Column2" ] ) ;

dbct . BulkMerge ( rows ,
    "Id" ,
    [ "Column1" , "Column2" ] ,
    [ "Column1" , "Column2" , "Column3" ] ) ;
dbct . BulkMerge ( compositeKeyRows ,
    [ "Id1" , "Id2" ] ,
    [ "Column1" , "Column2" , "Column3" ] ,
    [ "Id1" , "Id2" , "Column1" , "Column2" , "Column3" ] ) ;

使用構建器方法，以防您需要混合動態和lambda表達式

 new BulkInsertBuilder < Row > ( dbct . GetSqlConnection ( ) )
	. WithColumns ( row => new { row . Column1 , row . Column2 , row . Column3 } )
	// or .WithColumns([ "Column1", "Column2", "Column3" ])
	. WithOutputId ( row => row . Id )
	// or .WithOutputId("Id")
	. ToTable ( dbct . GetTableName ( typeof ( Row ) ) )
	// or .ToTable("Rows")
	. Execute ( rows ) ;

SQLConnectionExtensions

使用lambda表達式

 using EntityFrameworkCore . SqlServer . SimpleBulks . BulkDelete ;
using EntityFrameworkCore . SqlServer . SimpleBulks . BulkInsert ;
using EntityFrameworkCore . SqlServer . SimpleBulks . BulkMerge ;
using EntityFrameworkCore . SqlServer . SimpleBulks . BulkUpdate ;

// Register Type - Table Name globaly
TableMapper . Register ( typeof ( Row ) , "Rows" ) ;
TableMapper . Register ( typeof ( CompositeKeyRow ) , "CompositeKeyRows" ) ;

connection . BulkInsert ( rows ,
           row => new { row . Column1 , row . Column2 , row . Column3 } ) ;
connection . BulkInsert ( compositeKeyRows ,
           row => new { row . Id1 , row . Id2 , row . Column1 , row . Column2 , row . Column3 } ) ;

connection . BulkUpdate ( rows ,
           row => row . Id ,
           row => new { row . Column3 , row . Column2 } ) ;
connection . BulkUpdate ( compositeKeyRows ,
           row => new { row . Id1 , row . Id2 } ,
           row => new { row . Column3 , row . Column2 } ) ;

connection . BulkMerge ( rows ,
           row => row . Id ,
           row => new { row . Column1 , row . Column2 } ,
           row => new { row . Column1 , row . Column2 , row . Column3 } ) ;
connection . BulkMerge ( compositeKeyRows ,
           row => new { row . Id1 , row . Id2 } ,
           row => new { row . Column1 , row . Column2 , row . Column3 } ,
           row => new { row . Id1 , row . Id2 , row . Column1 , row . Column2 , row . Column3 } ) ;
                        
connection . BulkDelete ( rows , row => row . Id ) ;
connection . BulkDelete ( compositeKeyRows , row => new { row . Id1 , row . Id2 } ) ;

使用動態字符串

 using EntityFrameworkCore . SqlServer . SimpleBulks . BulkDelete ;
using EntityFrameworkCore . SqlServer . SimpleBulks . BulkInsert ;
using EntityFrameworkCore . SqlServer . SimpleBulks . BulkMerge ;
using EntityFrameworkCore . SqlServer . SimpleBulks . BulkUpdate ;

connection . BulkInsert ( rows , "Rows" ,
           [ "Column1" , "Column2" , "Column3" ] ) ;
connection . BulkInsert ( rows . Take ( 1000 ) , "Rows" ,
           typeof ( Row ) . GetDbColumnNames ( "Id" ) ) ;
connection . BulkInsert ( compositeKeyRows , "CompositeKeyRows" ,
           [ "Id1" , "Id2" , "Column1" , "Column2" , "Column3" ] ) ;

connection . BulkUpdate ( rows , "Rows" ,
           "Id" ,
           [ "Column3" , "Column2" ] ) ;
connection . BulkUpdate ( compositeKeyRows , "CompositeKeyRows" ,
           [ "Id1" , "Id2" ] ,
           [ "Column3" , "Column2" ] ) ;

connection . BulkMerge ( rows , "Rows" ,
           "Id" ,
           [ "Column1" , "Column2" ] ,
           [ "Column1" , "Column2" , "Column3" ] ) ;
connection . BulkMerge ( compositeKeyRows , "CompositeKeyRows" ,
           [ "Id1" , "Id2" ] ,
           [ "Column1" , "Column2" , "Column3" ] ,
           [ "Id1" , "Id2" , "Column1" , "Column2" , "Column3" ] ) ;

connection . BulkDelete ( rows , "Rows" , "Id" ) ;
connection . BulkDelete ( compositeKeyRows , "CompositeKeyRows" , [ "Id1" , "Id2" ] ) ;

使用構建器方法，以防您需要混合動態和lambda表達式

 new BulkInsertBuilder < Row > ( connection )
	. WithColumns ( row => new { row . Column1 , row . Column2 , row . Column3 } )
	// or .WithColumns([ "Column1", "Column2", "Column3" ])
	. WithOutputId ( row => row . Id )
	// or .WithOutputId("Id")
	. ToTable ( "Rows" )
	. Execute ( rows ) ;

配置

bulkinsert 

 _context . BulkInsert ( rows ,
    row => new { row . Column1 , row . Column2 , row . Column3 } ,
    options =>
    {
        options . KeepIdentity = false ;
        options . BatchSize = 0 ;
        options . Timeout = 30 ;
        options . LogTo = Console . WriteLine ;
    } ) ;

Bulkupdate 

 _context . BulkUpdate ( rows ,
    row => new { row . Column3 , row . Column2 } ,
    options =>
    {
        options . BatchSize = 0 ;
        options . Timeout = 30 ;
        options . LogTo = Console . WriteLine ;
    } ) ;

散裝

 _context . BulkDelete ( rows ,
    options =>
    {
        options . BatchSize = 0 ;
        options . Timeout = 30 ;
        options . LogTo = Console . WriteLine ;
    } ) ;

批量

 _context . BulkMerge ( rows ,
    row => row . Id ,
    row => new { row . Column1 , row . Column2 } ,
    row => new { row . Column1 , row . Column2 , row . Column3 } ,
    options =>
    {
        options . BatchSize = 0 ;
        options . Timeout = 30 ;
        options . WithHoldLock = false ;
        options . ReturnDbGeneratedId = true ;
        options . LogTo = Console . WriteLine ;
    } ) ;

笨重

 var contactsFromDb = _context . BulkMatch ( matchedContacts ,
    x => new { x . CustomerId , x . CountryIsoCode } ,
    options =>
    {
        options . BatchSize = 0 ;
        options . Timeout = 30 ;
        options . LogTo = Console . WriteLine ;
    } ) ;

誘人

 var customerTableName = _context . CreateTempTable ( customers ,
    x => new
    {
        x . IdNumber ,
        x . FirstName ,
        x . LastName ,
        x . CurrentCountryIsoCode
    } ,
    options =>
    {
        options . BatchSize = 0 ;
        options . Timeout = 30 ;
        options . LogTo = Console . WriteLine ;
    } ) ;

Directinsert 

 _context . DirectInsert ( row ,
    row => new { row . Column1 , row . Column2 , row . Column3 } ,
    options =>
    {
        options . Timeout = 30 ;
        options . LogTo = Console . WriteLine ;
    } ) ;

Directupdate 

 _context . DirectUpdate ( row ,
    row => new { row . Column3 , row . Column2 } ,
    options =>
    {
        options . Timeout = 30 ;
        options . LogTo = Console . WriteLine ;
    } ) ;

DirectDelete 

 _context . DirectDelete ( row ,
    options =>
    {
        options . Timeout = 30 ;
        options . LogTo = Console . WriteLine ;
    } ) ;

返回結果

Bulkupdate 

 var updateResult = dbct . BulkUpdate ( rows , row => new { row . Column3 , row . Column2 } ) ;

Console . WriteLine ( $ "Updated: { updateResult . AffectedRows } row(s)" ) ;

散裝

 var deleteResult = dbct . BulkDelete ( rows ) ;

Console . WriteLine ( $ "Deleted: { deleteResult . AffectedRows } row(s)" ) ;

批量

 var mergeResult = dbct . BulkMerge ( rows ,
    row => row . Id ,
    row => new { row . Column1 , row . Column2 } ,
    row => new { row . Column1 , row . Column2 , row . Column3 } ) ;

Console . WriteLine ( $ "Updated: { mergeResult . UpdatedRows } row(s)" ) ;
Console . WriteLine ( $ "Inserted: { mergeResult . InsertedRows } row(s)" ) ;
Console . WriteLine ( $ "Affected: { mergeResult . AffectedRows } row(s)" ) ;

基準

bulkinsert

單table/src/entityframeworkcore.sqlserver.simplebulks.benchs.benchs/bulkinsertsingletablebenchs.cs 

 BenchmarkDotNet =v0.13.2, OS =Windows 10 (10.0.19045.5011)
11th Gen Intel Core i7-1165G7 2.80GHz, 1 CPU, 8 logical and 4 physical cores
.NET SDK =8.0.400
  [Host]     : .NET 8.0.8 (8.0.824.36612), X64 RyuJIT AVX2
  Job-LGAVYD : .NET 8.0.8 (8.0.824.36612), X64 RyuJIT AVX2

InvocationCount =1  IterationCount =1  UnrollFactor =1  
WarmupCount =0
方法Rowscount意思是錯誤Gen0 Gen1 Gen2分配
efcoreinsert 100 45.19毫秒na - - - 985.52 kb
bulkinsert 100 32.68 ms na - - - 93.78 kb
efcoreinsert 1000 145.41 ms na 1000.0000 - - 9702.7 kb
bulkinsert 1000 44.94毫秒na - - - 573.84 kb
efcoreinsert 10000 788.90毫秒na 14000.0000 5000.0000 - 95727.38 kb
bulkinsert 10000 126.36毫秒na - - - 5320.53 kb
efcoreinsert 100000 7,107.29毫秒na 146000.0000 36000.0000 - 950162.56 kb
bulkinsert 100000 998.42毫秒na 7000.0000 3000.0000 1000.0000 51730.81 kb
efcoreinsert 250000 18,542.56毫秒na 365000.0000 87000.0000 - 2352262.34 kb
bulkinsert 250000 2,576.88毫秒na 16000.0000 5000.0000 1000.0000 125832.63 kb
efcoreinsert 500000 34,957.34毫秒na 730000.0000 170000.0000 - 4711772.88 kb
bulkinsert 500000 5,553.61毫秒na 30000.0000 9000.0000 1000.0000 252707.77 kb

多個表（1x父行 + 5x子行）/src/entityframeworkcore.sqlserver.simplebulks.benchs.benchmarks/bulkinsertmultipletletablesbenchs.css.cs 

 BenchmarkDotNet =v0.13.2, OS =Windows 10 (10.0.19045.5011)
11th Gen Intel Core i7-1165G7 2.80GHz, 1 CPU, 8 logical and 4 physical cores
.NET SDK =8.0.400
  [Host]     : .NET 8.0.8 (8.0.824.36612), X64 RyuJIT AVX2
  Job-LGAVYD : .NET 8.0.8 (8.0.824.36612), X64 RyuJIT AVX2

InvocationCount =1  IterationCount =1  UnrollFactor =1  
WarmupCount =0
方法Rowscount意思是錯誤Gen0 Gen1 Gen2分配
efcoreinsert 100 226.22 ms na 1000.0000 - - 7438.51 kb
bulkinsert 100 48.38毫秒na - - - 444.18 kb
efcoreinsert 1000 566.95毫秒na 11000.0000 4000.0000 - 73518.48 kb
bulkinsert 1000 125.77毫秒na - - - 3460.21 kb
efcoreinsert 10000 6,268.42毫秒na 114000.0000 30000.0000 - 731076.92 kb
bulkinsert 10000 1,066.74毫秒na 5000.0000 2000.0000 1000.0000 33324.16 kb
efcoreinsert 100000 59,389.89毫秒na 1138000.0000 264000.0000 - 7282561.93 kb
bulkinsert 100000 9,504.12毫秒na 39000.0000 13000.0000 1000.0000 327100.08 kb

Bulkupdate

/src/entityframeworkcore.sqlserver.simplebulks.benchs.benchs.benchs/bulkupdatebenchs.cs 

 BenchmarkDotNet =v0.13.2, OS =Windows 10 (10.0.19045.5011)
11th Gen Intel Core i7-1165G7 2.80GHz, 1 CPU, 8 logical and 4 physical cores
.NET SDK =8.0.400
  [Host]     : .NET 8.0.8 (8.0.824.36612), X64 RyuJIT AVX2
  Job-LGAVYD : .NET 8.0.8 (8.0.824.36612), X64 RyuJIT AVX2

InvocationCount =1  IterationCount =1  UnrollFactor =1  
WarmupCount =0
方法Rowscount意思是錯誤Gen0 Gen1分配
efcoreupdate 100 61.65毫秒na - - 853.66 kb
Bulkupdate 100 27.33毫秒na - - 63.55 kb
efcoreupdate 1000 143.39毫秒na 1000.0000 - 8398.1 kb
Bulkupdate 1000 43.95毫秒na - - 379.25 kb
efcoreupdate 10000 685.97毫秒na 12000.0000 3000.0000 82396.19 kb
Bulkupdate 10000 182.54毫秒na - - 3499.74 kb
efcoreupdate 100000 8,495.18毫秒na 120000.0000 28000.0000 810248.07 kb
Bulkupdate 100000 2,091.42毫秒na 5000.0000 1000.0000 33819.46 kb
efcoreupdate 250000 17,859.49毫秒na 300000.0000 69000.0000 2005895.77 kb
Bulkupdate 250000 4,290.07毫秒na 13000.0000 7000.0000 84352 KB 
 BenchmarkDotNet =v0.13.2, OS =Windows 10 (10.0.19045.5011)
11th Gen Intel Core i7-1165G7 2.80GHz, 1 CPU, 8 logical and 4 physical cores
.NET SDK =8.0.400
  [Host]     : .NET 8.0.8 (8.0.824.36612), X64 RyuJIT AVX2
  Job-LGAVYD : .NET 8.0.8 (8.0.824.36612), X64 RyuJIT AVX2

InvocationCount =1  IterationCount =1  UnrollFactor =1  
WarmupCount =0
方法Rowscount意思是錯誤Gen0 Gen1分配
Bulkupdate 500000 10.19 s na 27000.0000 16000.0000 164.63 MB
Bulkupdate 1000000 17.03 s na 54000.0000 37000.0000 329.12 MB

散裝

/src/entityframeworkcore.sqlserver.simplebulks.benchs.benchs.benchs/bulkdeletebenchs.cs 

 BenchmarkDotNet =v0.13.2, OS =Windows 10 (10.0.19045.5011)
11th Gen Intel Core i7-1165G7 2.80GHz, 1 CPU, 8 logical and 4 physical cores
.NET SDK =8.0.400
  [Host]     : .NET 8.0.8 (8.0.824.36612), X64 RyuJIT AVX2
  Job-LGAVYD : .NET 8.0.8 (8.0.824.36612), X64 RyuJIT AVX2

InvocationCount =1  IterationCount =1  UnrollFactor =1  
WarmupCount =0
方法Rowscount意思是錯誤Gen0 Gen1分配
efcoredelete 100 73.25毫秒na - - 681.09 kb
散裝100 29.42毫秒na - - 43.45 kb
efcoredelete 1000 176.83毫秒na 1000.0000 1000.0000 6745 kb
散裝1000 27.19毫秒na - - 236.86 kb
efcoredelete 10000 1,489.03毫秒na 10000.0000 2000.0000 66031.55 kb
散裝10000 431.74毫秒na - - 2150.99 kb
efcoredelete 20000 6,084.87毫秒na 20000.0000 7000.0000 132403.3 kb
散裝20000 276.52毫秒na - - 4276.01 kb
efcoredelete 50000 39,933.60毫秒na 49000.0000 14000.0000 326164.25 kb
散裝50000 1,477.09毫秒na 1000.0000 - 10594.63 KB 
 BenchmarkDotNet =v0.13.2, OS =Windows 10 (10.0.19045.5011)
11th Gen Intel Core i7-1165G7 2.80GHz, 1 CPU, 8 logical and 4 physical cores
.NET SDK =8.0.400
  [Host]     : .NET 8.0.8 (8.0.824.36612), X64 RyuJIT AVX2
  Job-LGAVYD : .NET 8.0.8 (8.0.824.36612), X64 RyuJIT AVX2

InvocationCount =1  IterationCount =1  UnrollFactor =1  
WarmupCount =0
方法Rowscount意思是錯誤Gen0 Gen1分配
散裝100000 937.7毫秒na 3000.0000 1000.0000 20.67 MB
散裝250000 2,619.7毫秒na 7000.0000 3000.0000 51.7 MB
散裝500000 4,897.7毫秒na 13000.0000 6000.0000 103.22 MB
散裝1000000 9,466.0毫秒na 26000.0000 12000.0000 206.28 MB

批量

/src/entityframeworkcore.sqlserver.simplebulks.benchs.benchsmarks/bulkmergebenchs.cs 

 BenchmarkDotNet =v0.13.2, OS =Windows 10 (10.0.19045.5011)
11th Gen Intel Core i7-1165G7 2.80GHz, 1 CPU, 8 logical and 4 physical cores
.NET SDK =8.0.400
  [Host]     : .NET 8.0.8 (8.0.824.36612), X64 RyuJIT AVX2
  Job-LGAVYD : .NET 8.0.8 (8.0.824.36612), X64 RyuJIT AVX2

InvocationCount =1  IterationCount =1  UnrollFactor =1  
WarmupCount =0
方法Rowscount意思是錯誤Gen0 Gen1 Gen2分配
efcoreupsert 100 82.11 ms na - - - 1840.23 kb
批量100 34.27毫秒na - - - 162.96 kb
efcoreupsert 1000 266.86毫秒na 2000.0000 1000.0000 - 17984.91 kb
批量1000 79.45毫秒na - - - 1213.33 KB
efcoreupsert 10000 1,451.20毫秒na 26000.0000 8000.0000 - 178385.15 kb
批量10000 677.47毫秒na 1000.0000 - - 11679.42 KB
efcoreupsert 100000 13,902.06毫秒na 266000.0000 63000.0000 - 1762696.52 kb
批量100000 3,415.31毫秒na 16000.0000 6000.0000 1000.0000 115233.2 kb
efcoreupsert 250000 36,167.51毫秒na 665000.0000 152000.0000 - 4362872.57 kb
批量250000 7,681.71毫秒na 37000.0000 11000.0000 1000.0000 284187.09 kb

/SRC/EntityFrameWorkcore.sqlserver.simplebulks.benchsmarkss/bulkmergergereturndbgeneratedIdbenchs.css.cs 

 BenchmarkDotNet =v0.13.2, OS =Windows 10 (10.0.19045.5011)
11th Gen Intel Core i7-1165G7 2.80GHz, 1 CPU, 8 logical and 4 physical cores
.NET SDK =8.0.400
  [Host]     : .NET 8.0.8 (8.0.824.36612), X64 RyuJIT AVX2
  Job-LGAVYD : .NET 8.0.8 (8.0.824.36612), X64 RyuJIT AVX2

InvocationCount =1  IterationCount =1  UnrollFactor =1  
WarmupCount =0
方法Rowscount意思是錯誤Gen0 Gen1 Gen2分配
returndbgeneratedID 100 38.45 ms na - - - 151.09 kb
notreturndbgeneratedId 100 37.75毫秒na - - - 116.8 kb
returndbgeneratedID 1000 67.42 ms na - - - 1099.48 kb
notreturndbgeneratedId 1000 60.02 ms na - - - 769.23 KB
returndbgeneratedID 10000 783.73毫秒na 1000.0000 - - 10543.62 KB
notreturndbgeneratedId 10000 501.07 ms na 1000.0000 - - 7348.79 kb
returndbgeneratedID 100000 3,187.89毫秒na 14000.0000 5000.0000 1000.0000 103878.09 kb
notreturndbgeneratedId 100000 2,741.31毫秒na 11000.0000 5000.0000 1000.0000 72936.01 kb 
 BenchmarkDotNet =v0.13.2, OS =Windows 10 (10.0.19045.5011)
11th Gen Intel Core i7-1165G7 2.80GHz, 1 CPU, 8 logical and 4 physical cores
.NET SDK =8.0.400
  [Host]     : .NET 8.0.8 (8.0.824.36612), X64 RyuJIT AVX2
  Job-LGAVYD : .NET 8.0.8 (8.0.824.36612), X64 RyuJIT AVX2

InvocationCount =1  IterationCount =1  UnrollFactor =1  
WarmupCount =0
方法Rowscount意思是錯誤Gen0 Gen1 Gen2分配
returndbgeneratedID 250000 7.799 s na 32000.0000 8000.0000 - 249.8 MB
notreturndbgeneratedId 250000 6.619 s na 24000.0000 7000.0000 - 177.7 MB
returndbgeneratedID 500000 15.051 s na 66000.0000 19000.0000 1000.0000 500.64 MB
notreturndbgeneratedId 500000 14.328 s na 47000.0000 14000.0000 - 355.19 MB
returndbgeneratedID 1000000 32.449 s na 129000.0000 34000.0000 - 1003.67 MB
notreturndbgeneratedId 1000000 28.253 s na 95000.0000 28000.0000 - 710.22 MB

笨重

單列/src/entityframeworkcore.sqlserver.simplebulks.benchs.benchs.benchs/bulkmatchsinglecolumnbenchs.cs 

 BenchmarkDotNet =v0.13.2, OS =Windows 10 (10.0.19045.5011)
11th Gen Intel Core i7-1165G7 2.80GHz, 1 CPU, 8 logical and 4 physical cores
.NET SDK =8.0.400
  [Host]     : .NET 8.0.8 (8.0.824.36612), X64 RyuJIT AVX2
  Job-LGAVYD : .NET 8.0.8 (8.0.824.36612), X64 RyuJIT AVX2

InvocationCount =1  IterationCount =1  UnrollFactor =1  
WarmupCount =0
方法Rowscount意思是錯誤Gen0 Gen1 Gen2分配
efcoreselect 100 97.373 MS na - - - 1008.33 kb
efcoreBatchSelect 100 7.166毫秒na - - - 94.77 kb
笨重100 8.570毫秒na - - - 106.63 KB
efcoreselect 1000 720.250毫秒na 1000.0000 - - 9761.42 kb
efcoreBatchSelect 1000 6.375毫秒na - - - 908.18 kb
笨重1000 15.445毫秒na - - - 820.36 kb
efcoreselect 10000 8,075.686毫秒na 15000.0000 1000.0000 - 97115.62 KB
efcoreBatchSelect 10000 66.438毫秒na 1000.0000 - - 9092.91 kb
笨重10000 69.430毫秒na 1000.0000 - - 8177.76 kb
efcoreselect 100000 81,088.718毫秒na 159000.0000 31000.0000 1000.0000 972204.7 KB
efcoreBatchSelect 100000 920.412 ms na 11000.0000 4000.0000 1000.0000 91808.56 kb
笨重100000 742.030 ms na 13000.0000 6000.0000 1000.0000 82419.43 kb 
 BenchmarkDotNet =v0.13.2, OS =Windows 10 (10.0.19045.5011)
11th Gen Intel Core i7-1165G7 2.80GHz, 1 CPU, 8 logical and 4 physical cores
.NET SDK =8.0.400
  [Host]     : .NET 8.0.8 (8.0.824.36612), X64 RyuJIT AVX2
  Job-LGAVYD : .NET 8.0.8 (8.0.824.36612), X64 RyuJIT AVX2

InvocationCount =1  IterationCount =1  UnrollFactor =1  
WarmupCount =0
方法Rowscount意思是錯誤Gen0 Gen1 Gen2分配
efcoreBatchSelect 250000 2.101 s na 26000.0000 11000.0000 1000.0000 224.05 MB
笨重250000 2.067 s na 32000.0000 12000.0000 1000.0000 201.64 MB
efcoreBatchSelect 500000 4.239 s na 53000.0000 20000.0000 2000.0000 448.85 MB
笨重500000 4.507 s na 62000.0000 24000.0000 1000.0000 404.03 MB
efcoreBatchSelect 1000000 8.523 s na 103000.0000 38000.0000 1000.0000 898.44 MB
笨重1000000 11.585 s na 123000.0000 46000.0000 1000.0000 808.82 MB

多列/src/entityframeworkcore.sqlserver.simplebulks.benchs.benchmarks/bulkmatchmatchmatchmatchmultiplecolumnsbenchs.cs 

 BenchmarkDotNet =v0.13.2, OS =Windows 10 (10.0.19045.5011)
11th Gen Intel Core i7-1165G7 2.80GHz, 1 CPU, 8 logical and 4 physical cores
.NET SDK =8.0.400
  [Host]     : .NET 8.0.8 (8.0.824.36612), X64 RyuJIT AVX2
  Job-LGAVYD : .NET 8.0.8 (8.0.824.36612), X64 RyuJIT AVX2

InvocationCount =1  IterationCount =1  UnrollFactor =1  
WarmupCount =0
方法Rowscount意思是錯誤Gen0 Gen1分配
efcoreselect 100 130.11 ms na - - 1256.8 kb
笨重100 15.46毫秒na - - 173.56 kb
efcoreselect 1000 997.87毫秒na 2000.0000 - 12373.85 kb
笨重1000 43.35毫秒na - - 1358.77 kb
efcoreselect 10000 9,769.96毫秒na 20000.0000 4000.0000 123595.97 kb
笨重10000 238.80毫秒na 2000.0000 1000.0000 13768.49 kb
efcoreselect 100000 89,204.16毫秒na 201000.0000 51000.0000 1237424.23 kb
笨重100000 2,612.00毫秒na 21000.0000 8000.0000 138686.52 kb 
 BenchmarkDotNet =v0.13.2, OS =Windows 10 (10.0.19045.5011)
11th Gen Intel Core i7-1165G7 2.80GHz, 1 CPU, 8 logical and 4 physical cores
.NET SDK =8.0.400
  [Host]     : .NET 8.0.8 (8.0.824.36612), X64 RyuJIT AVX2
  Job-LGAVYD : .NET 8.0.8 (8.0.824.36612), X64 RyuJIT AVX2

InvocationCount =1  IterationCount =1  UnrollFactor =1  
WarmupCount =0
方法Rowscount意思是錯誤Gen0 Gen1分配
笨重250000 6.709 s na 53000.0000 19000.0000 340.68 MB
笨重500000 12.939 s na 107000.0000 36000.0000 683.46 MB
笨重1000000 25.418 s na 214000.0000 74000.0000 1369.34 MB

誘人

/src/entityframeworkcore.sqlserver.simplebulks.benchs.benchs.benchs/temptablebenchs.cs 

 BenchmarkDotNet =v0.13.2, OS =Windows 10 (10.0.19045.5011)
11th Gen Intel Core i7-1165G7 2.80GHz, 1 CPU, 8 logical and 4 physical cores
.NET SDK =8.0.400
  [Host]     : .NET 8.0.8 (8.0.824.36612), X64 RyuJIT AVX2
  Job-LGAVYD : .NET 8.0.8 (8.0.824.36612), X64 RyuJIT AVX2

InvocationCount =1  IterationCount =1  UnrollFactor =1  
WarmupCount =0
方法Rowscount意思是錯誤Gen0 Gen1 Gen2分配
可見的100 7.639毫秒na - - - 68.03 KB
可見的1000 14.077 ms na - - - 373.76 kb
可見的10000 89.789毫秒na - - - 3455.46 kb
可見的100000 574.937 MS na 4000.0000 1000.0000 - 34081.95 kb
可見的250000 1,403.071 ms na 12000.0000 5000.0000 1000.0000 85229.91 kb
可見的500000 2,838.562毫秒na 22000.0000 8000.0000 1000.0000 170241.85 kb
可見的1000000 6,198.206毫秒na 43000.0000 14000.0000 1000.0000 340282.7 kb

執照

EntityFrameWorkCore.sqlserver.simplebulks已獲得MIT許可證的許可。

展開
附加信息
相關應用
爲您推薦
相關資訊 全部