Skip to content

Latest commit

 

History

History
59 lines (40 loc) · 2.51 KB

README.md

File metadata and controls

59 lines (40 loc) · 2.51 KB
Raw

Ef Core postgres COPY binary extension

Codacy Badge

NuGet Generation Build and test

Entity framework core extension to perform Postgres copy

Based on PostgreSQLCopyHelper

Quick Start

Installation

dotnet add package EF.Extensions.PgCopy --version 1.0.4

Usage

var options = new DbContextOptionsBuilder<BloggingContext>()
                .UseNpgsql(ConnectionString, opt => opt.CommandTimeout((int) TimeSpan.FromMinutes(1).TotalSeconds))
                .Options;

await using var dbContext = new BloggingContext(options);
await dbContext.Posts.AddRangeAsync(posts, cancellationToken);
await dbContext.Blogs.AddRangeAsync(blogs, cancellationToken);

// classic use with multiple Insert sql commands
if (!byCopy) return await dbContext.SaveChangesAsync(cancellationToken);

// function based on Postgres Copy command
var result = await dbContext.SaveByCopyChangesAsync(cancellationToken);

Benchmark

BenchmarkDotNet=v0.12.1, OS=macOS Catalina 10.15.4 (19E287) [Darwin 19.4.0]
Intel Core i7-9750H CPU 2.60GHz, 1 CPU, 12 logical and 6 physical cores
.NET Core SDK=3.1.201
  [Host]     : .NET Core 3.1.3 (CoreCLR 4.700.20.11803, CoreFX 4.700.20.12001), X64 RyuJIT
  DefaultJob : .NET Core 3.1.3 (CoreCLR 4.700.20.11803, CoreFX 4.700.20.12001), X64 RyuJIT
Method count Mean Error StdDev Median
Save 100 31.87 ms 0.934 ms 2.726 ms 31.27 ms
SaveEfCopy 100 17.50 ms 1.054 ms 3.074 ms 17.57 ms
Save 100000 26,117.05 ms 739.131 ms 2,156.079 ms
SaveEfCopy 100000 9,157.41 ms 410.181 ms 1,196.518 ms
Save 1000000 372,285.08 ms 47,559.949 ms 137,221.328 ms 319,992.52 ms
SaveEfCopy 1000000 82,974.09 ms 2,410.985 ms 6,878.675 ms 81,184.00 ms