Adds basic support for "Upsert" operations to EF Core.
Uses `INSERT … ON CONFLICT DO UPDATE` in PostgreSQL/Sqlite, `MERGE` in SqlServer and `INSERT INTO … ON DUPLICATE KEY UPDATE` in MySQL.
Also supports injecting sql command generators to add support for other providers
Extend your IDbConnection with high-performance bulk operations
Features: BulkInsert, BulkDelete, BulkUpdate, BulkMerge, and more!
Support: SQL Server, MySQL, Oracle, PostgreSQL, SQLite, and more!
Online Example: https://dotnetfiddle.net/ltIqrC
Include free and prime features.
An improved version of SqlBulkCopy.
Features: BulkInsert, BulkDelete, BulkUpdate, BulkMerge, and more!
Support: SQL Server, MySQL, Oracle, PostgreSQL, SQLite, and more!
DataTable Example: https://dotnetfiddle.net/2B7QpT
Entity Example: https://dotnetfiddle.net/istUUT
Include free and prime...
More information
High performance operation for MS SQL Server built for Dapper ORM. Including bulk operations Insert, Update, Delete, Get as well as Upsert both single and bulk.
Entity Framework Core Batch Extensions for INSERT UPDATE DELETE UPSERT MERGE operations by generating SQLs. NOTE that you should install the corresponding provider package.
Commonly Used Extension Methods:
DbContext.Auditlogs.Where(a => a.Time == DateTime.Now.AddDays(-30)).BatchDelete();...
More information
Entity Framework Core Batch Extensions for INSERT UPDATE DELETE UPSERT MERGE operations by generating SQLs. NOTE that you should install the corresponding provider package.
Commonly Used Extension Methods:
DbContext.Auditlogs.Where(a => a.Time == DateTime.Now.AddDays(-30)).BatchDelete();...
More information
Entity Framework Core Batch Extensions for INSERT UPDATE DELETE UPSERT MERGE operations by generating SQLs. NOTE that you should install the corresponding provider package.
Commonly Used Extension Methods:
DbContext.Auditlogs.Where(a => a.Time == DateTime.Now.AddDays(-30)).BatchDelete();...
More information
Entity Framework Core Batch Extensions for INSERT UPDATE DELETE UPSERT MERGE operations by generating SQLs. NOTE that you should install the corresponding provider package.
Commonly Used Extension Methods:
DbContext.Auditlogs.Where(a => a.Time == DateTime.Now.AddDays(-30)).BatchDelete();...
More information
Entity Framework Core Batch Extensions for INSERT UPDATE DELETE UPSERT MERGE operations by generating SQLs. NOTE that you should install the corresponding provider package.
Commonly Used Extension Methods:
DbContext.Auditlogs.Where(a => a.Time == DateTime.Now.AddDays(-30)).BatchDelete();...
More information
Bulk Data API/Tools for SQL Server databases. Easily perform bulk "upsert" operations on your database. Nifty helper utility for moving around large sets of data.
Entity Framework Core Batch Extensions for INSERT UPDATE DELETE UPSERT MERGE operations by generating SQLs. NOTE that you should install the corresponding provider package.
Commonly Used Extension Methods:
DbContext.Auditlogs.Where(a => a.Time == DateTime.Now.AddDays(-30)).BatchDelete();...
More information
Entity Framework Core Batch Extensions for INSERT UPDATE DELETE UPSERT MERGE operations by generating SQLs. NOTE that you should install the corresponding provider package.
Commonly Used Extension Methods:
DbContext.Auditlogs.Where(a => a.Time == DateTime.Now.AddDays(-30)).BatchDelete();...
More information
Adds basic support for "Upsert" operations to EF Core.
Uses `INSERT … ON CONFLICT DO UPDATE` in PostgreSQL/Sqlite, `MERGE` in SqlServer and `INSERT INTO … ON DUPLICATE KEY UPDATE` in MySQL.
Also supports injecting sql command generators to add support for other providers