EFCore.BulkExtensions 10.0.1

dotnet add package EFCore.BulkExtensions --version 10.0.1

NuGet\Install-Package EFCore.BulkExtensions -Version 10.0.1

This command is intended to be used within the Package Manager Console in Visual Studio, as it uses the NuGet module's version of Install-Package.

<PackageReference Include="EFCore.BulkExtensions" Version="10.0.1" />

For projects that support PackageReference, copy this XML node into the project file to reference the package.

<PackageVersion Include="EFCore.BulkExtensions" Version="10.0.1" />
                    

                            Directory.Packages.props

<PackageReference Include="EFCore.BulkExtensions" />
                    

                            Project file

For projects that support Central Package Management (CPM), copy this XML node into the solution Directory.Packages.props file to version the package.

paket add EFCore.BulkExtensions --version 10.0.1

The NuGet Team does not provide support for this client. Please contact its maintainers for support.

#r "nuget: EFCore.BulkExtensions, 10.0.1"

#r directive can be used in F# Interactive and Polyglot Notebooks. Copy this into the interactive tool or source code of the script to reference the package.

#:package EFCore.BulkExtensions@10.0.1

#:package directive can be used in C# file-based apps starting in .NET 10 preview 4. Copy this into a .cs file before any lines of code to reference the package.

#addin nuget:?package=EFCore.BulkExtensions&version=10.0.1
                    

                            Install as a Cake Addin

#tool nuget:?package=EFCore.BulkExtensions&version=10.0.1
                    

                            Install as a Cake Tool

The NuGet Team does not provide support for this client. Please contact its maintainers for support.

EFCore.BulkExtensions

EntityFrameworkCore extensions that offer enterprise-grade performance boost - into overdrive:
-Bulk operations (super fast, en masse DB Protocol): Insert, Update, Delete, Read, Upsert, Sync, SaveChanges.
-Batch ops (chunk-oriented processing): Update, Delete - Deprecated from EF8 (v7+ has native Execute-Up/Del).
-AddOp (additional improvement): Truncate.
Library is Lightweight and very Efficient (warp speed), having all mostly used CRUD operation.
Was selected in top 10 EF Core Extensions recommended by Microsoft.
Latest version is using EF Core 10.
Supports all 5 major sql databases: SQLServer, PostgreSQL, MySQL, Oracle, SQLite.
Check out Testimonials from the Community and User Comments.
With thousands of pleased Users and many satisfied Clients from around the globe.
Customers range from small and medium-sized businesses to large corporations,
of which some are related to big-data/AI industry and fintech companies that have large datasets.
Icon>> and Logo (__):
<img src="/EFCore.BulkExtensions/EFCoreBulk.png" height=60> & <img src="EFCoreBulkLogo_small.png" height=60>
(f.forward | rocket time)

*Also take a look into others highly performant packages:</br> Open source (MIT or cFOSS) authored .Net libraries and other projects (@Infopedia.io personal blog post). | № | Project | Type | Description | | - | ------------------------ | ---- | -------------------------------------------------------- | | 1 | EFCore.BulkExtensions | .Net_Lib(ngt) cF | EF Core Bulk CRUD Ops (Flagship Library) | | 2 | EFCore.UtilExtensions | .Net_Lib(ngt) MIT | EF Core Custom Annotations and AuditInfo | | 3 | EFCore.FluentApiToAnnotation | .Net_Lib(ngt) MIT | Converting FluentApi configuration to Annotations | | 4 | ExcelIO.FastMapper | .Net_Lib(ngt) MIT | Excel I/O Mapper to-from Poco & .xlsx + attribute | | 5 | FixedWidthParserWriter | .Net_Lib(ngt) MIT | Reading & Writing fixed-width/flat data files | | 6 | CsCodeGenerator | .Net_Lib(ngt) MIT | C# code generation based on Classes and elements | | 7 | CsCodeExample | C# Code ( - ) MIT | Examples of C# code in form of a simple tutorial |

License

BulkExtensions licensed under Dual License (cFOSS: conditionallyFree OSS - OpenSource Sustainability & funding).
If you do not meet criteria for free usage of software with community license then you have to buy commercial one.
When eligible for free usage but still need active support, consider purchasing Starter Lic.

Support

If you find this project useful you can mark it by leaving a Github Star ⭐
And even with Community license, if you want help Development, you can make a Donation:
<img src="https://www.buymeacoffee.com/assets/img/custom_images/yellow_img.png" alt="Buy Me A Coffee" height=28> _ or _ :zap: (Moneylution)

Contributing

Please read CONTRIBUTING for details on code of conduct, and the process for submitting Pull Requests.
When opening issues do write detailed explanation of the problem or feature with reproducible example.
Want to Contact for Development & Consulting: codis (Quality Delivery).

Description

Supported databases:
-SQLServer (or AzureSQL) under the hood uses SqlBulkCopy for Insert, Update/Delete = BulkInsert + raw Sql MERGE.
-PostgreSQL (9.5+) is using COPY BINARY combined with ON CONFLICT for Update.
-MySQL (8+) is using MySqlBulkCopy combined with ON DUPLICATE for Update.
-Oracle (8+) is using OracleBulkCopy combined with MERGE for Update.
-SQLite has no Copy tool, instead library uses plain SQL combined with UPSERT.
Bulk Tests can not have UseInMemoryDb because InMemoryProvider does not support Relational-specific methods.
Instead Test options are SqlServer(Developer or Express), LocalDb(if alongside Developer v.), or with other adapters.

Installation

Available on
Package manager console command to install: Install-Package EFCore.BulkExtensions
Main nuget is for all Databases, and specific ones with single provider for those who need small size packages.
Specific ones have adapter suffix: MainNuget + .SqlServer/PostgreSql/MySql/Oracle/Sqlite (