borisdj/EFCore.BulkExtensions
EFCore.BulkExtensions
EFCore.BulkExtensions is a library for executing high-performance batch insert, update, and delete operations within the Entity Framework Core ecosystem. It functions as a database batch processing toolkit and a wrapper for native SQL Bulk Copy to enable faster data ingestion and synchronization across multiple database providers.
The library provides specialized capabilities for relational data synchronization, allowing users to align database tables with local entity lists through bulk upserts and conditional synchronization. It also supports relational data graph insertions, which enable the addition of large sets of parent and child records across multiple tables while maintaining foreign key relationships.
The tool covers a broad range of bulk data operations, including general CRUD processing, table truncation, and direct table-to-table data copying. It further includes utilities for server-side batch updates and high-performance database migration to move large volumes of data without loading entities into application memory.
Features
- EF Core Bulk Operations - Provides high-performance batch insert, update, and delete operations tailored for the Entity Framework Core ecosystem.
- Bulk Record Insertions - Enables high-speed insertion of large record volumes in a single database operation to minimize network overhead.
- Automatic Table Synchronizers - Automatically aligns database table content with local datasets via bulk inserts, updates, and deletions.
- Batch Processing - Offers a comprehensive toolkit for manipulating large datasets on the server to minimize application memory usage.
- Bulk CRUD Engines - Implements a high-performance engine for executing bulk create, read, update, and delete actions on large datasets.
- Bulk Data Ingestion - Provides high-performance utilities for importing large volumes of data using native database bulk copy mechanisms.
- Batch SQL Executions - Executes raw SQL commands directly on the database engine to avoid the overhead of loading entities into memory.
- Batch Insert, Update, or Delete Operations - Executes multiple row modifications or deletions in a single round trip to the database using filtered queries.
- Set-Based Synchronizations - Compares local and database datasets using primary keys to automatically determine which records require synchronization.
- Data Synchronization - Ensures parity between local entity lists and the database through bulk upserts and full synchronization.
- Relational Graph Operations - Executes bulk operations across related parent-child tables to maintain strict referential integrity.
- Relation Graph Upserting - Supports inserting large sets of parent and child records while maintaining referential integrity across relational graphs.
- Graph-Based Insertions - Adds large sets of related records across multiple tables while preserving parent-child foreign key relationships.
- Bulk Update Utilities - Provides tools for performing batch modifications on database records using filtered queries on the server.
- Joined Bulk Updates - Performs mass record updates by joining temporary staging tables with target tables for maximum efficiency.
- Data Set Alignments - Aligns destination tables with source data sets through targeted updates or deletions using optional filters.
- Relational Data Synchronization - Aligns database tables with local entity lists through bulk upserts and conditional synchronization.
- Cross-Database Data Migrations - Implements high-performance data movement between tables or databases using optimized bulk copy mechanisms.
- Temporary Table Staging - Streams incoming data into ephemeral tables to optimize high-volume merge and update operations.
- DAG-Based Dependency Resolution - Analyzes entity relationships using directed acyclic graphs to determine the correct order for bulk operations.
- Conditional Synchronizations - Synchronizes data between sources and destinations by filtering specific records for targeted inserts, updates, or deletions.
- Object Relational Mappers - Bulk CRUD operations and batch processing for Entity Framework Core.
- Object Relational Mapping - Bulk operation extensions for Entity Framework Core.
