LinqToSql Plus is a library that dramatically improves LinqToSql performances by using bulk and batch operations.
People using this library often report performance enhancement by 50x times and more!
The library is installed through NuGet. Extension methods are added automatically to your DbContext.
It easy to use, easy to customize.
Bulk operation methods give you additional flexibility by allowing to customize options such as primary key, columns and more.
Bulk Operations Available:
|Operations||1,000 Entities||2,000 Entities||5,000 Entities|
|SubmitChanges||1,000 ms||2,000 ms||5,000 ms|
|BulkInsert||6 ms||10 ms||15 ms|
|BulkUpdate||50 ms||55 ms||65 ms|
|BulkDelete||45 ms||50 ms||60 ms|
|BulkMerge||65 ms||80 ms||110 ms|
Batch Operations method allow to perform UPDATE or DELETE operation directly in the database using a LINQ Query without loading entities in the context.
Everything is executed on the database side to let you get the best performance available.
Batch Operations Available:
| Operations | 1,000 Entities | 2,000 Entities | 5,000 Entities | | :————– | ————-: | ————-: | ————-: | | SubmitChanges | 1,000 ms | 2,000 ms | 5,000 ms | | DeleteFromQuery | 1 ms | 1 ms | 1 ms | | UpdateFromQuery | 1 ms | 1 ms | 1 ms | –!>