EF.Extensions.PgCopy 1.0.0

Ef Core postgres COPY binary extension

Entity framwork core extension to perform Postgres copy

Based on PostgreSQLCopyHelper

Postgres Copy command

Preview of use

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

TODO

• Test Multi entities tracking (SaveByCopyChanges)
• mixing saving entities with saveChanges and SaveByCopyChanges functions at the same time
• Auto load from NpgsqlDbType and BuiltInPostgresType attribute
• Get DBConnection from dbContext.Database
• Test with different column types
• BenchMark COPY vs multi insert methods
• Caching PostgreSQLCopyHelperFactory
• SaveCopyChanges extension
• Transaction handling
• Unit tests
• Packaging library