Installation

Install the NuGet package for your database provider:

Nuget install	NuGet Link
Install-Package PhenX.EntityFrameworkCore.BulkInsert.PostgreSql
Install-Package PhenX.EntityFrameworkCore.BulkInsert.Sqlite
Install-Package PhenX.EntityFrameworkCore.BulkInsert.Sqlite
Install-Package PhenX.EntityFrameworkCore.BulkInsert.MySql
Install-Package PhenX.EntityFrameworkCore.BulkInsert.Oracle

Usage

Register the bulk insert provider in your DbContextOptions:

services.AddDbContext<MyDbContext>(options =>
{
    options
        // .UseSqlServer(connectionString) // or UseNpgsql or UseSqlite, as appropriate

        .UseBulkInsertPostgreSql()
        // OR
        .UseBulkInsertSqlServer()
        // OR
        .UseBulkInsertSqlite()
        // OR
        .UseBulkInsertMySql()
        // OR
        .UseBulkInsertOracle()
        ;
});

Then insert data:

// Asynchronously
await dbContext.ExecuteBulkInsertAsync(entities);

// Or synchronously
dbContext.ExecuteBulkInsert(entities);