29 packages tagged with “upsert”
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 features.
Library that helps with performing the nifty upsert-from-temp-table-streaming trick 🚀
A simple upserter
Use Excel to create, update, upsert or delete records in Dataverse. Now with better logging, the ability to save and re use data maps, and faster data entry.
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.
This is the core extension package. Always use it in conjunction with the corresponding database package (e.g., ETLBox.Postgres for PostgreSQL or ETLBox.SqlServer for SQL Server). ETLBox.DbExtensions enhances your DbConnection with high-performance bulk operations, including BulkInsert, BulkUpdate, BulkDelete, and BulkMerge. # Adds missing bulk operations directly to IDbConnection. # Provides a complete micro-ORM for efficient data handling. # Extends the connection with simplified ETL functionalities from ETLBox. With ETLBox.DbExtensions, you can process thousands of records in a single operation, significantly reducing execution time and improving database performance. For examples, tutorials, and documentation, visit: https://dbextensions.etlbox.net
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(); DbContext.Employees.Where(a => a.IsActive).BatchUpdate(a => new Employee { Salary = a.Salary + 10000 }); DbContext.Votes.Upsert(() => new Vote { CommentId = cid, Votes = 1 }, v => new Vote { Votes = v.Votes + 1 });
.Net Upsert for combined insert and update operations of strongly typed collections into SQL Server.
Import & export sql to yaml
Package Description
Allows you to either insert or update (upsert) entities with one call using EFCore.
Execute SqlBulkCopy into a temp table and merge the results into target table.
Provides extensions for arrays and collections.
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.
Pouchdb Upsert (pouchdb-upsert) binding library for Bridge.NET projects.
High-performance bulk operations library for Entity Framework Core. Core library providing base functionality for SQL Server and PostgreSQL bulk operations.
SQL Server provider for Gurung.EfBulkOperations. High-performance bulk operations using SqlBulkCopy and MERGE statements for SQL Server 2016 and above.
PostgreSQL provider for Gurung.EfBulkOperations. High-performance bulk operations using binary COPY command and INSERT ON CONFLICT for PostgreSQL 12 and above.
Single-class MySQL helper for .NET with ADO.NET, EF Core, async streaming, pagination, logging, bulk insert/upsert, and transactions.