Laughing Waffle

Laughing Waffle is a helper library for doing bulk insert and upate (read upsert) work with SQL Server. Specifically providing help and code generation around the MERGE Statement. There wasn’t a good open source or free packages that do this kind of work, so this project aims to fill that gap.

It is targeting .NET Standard v1.3 for wide compatibility across the .NET ecosystem.

Build Status	Activity	MyGet Downloads	NuGet Downloads	License

What is Laughing Waffle

This library is intended to make Extract, Transform, and Load (ETL) jobs easier. Other tools make both extracting the data easy as well as transforming it from one format to another, but there was no package for helping insert/update on the target side.

Basic Usage

// your collection that needs updated
var toUpsert = new List<YourModel>();

// upsert options
var upsertOptions = new UpsertOptions<YourModel>()
    .AddMatchColumn(p => p.PrimaryKey) // field(s) to match rows on
    .AddMapColumn(p => p.Column1) // columns to update
    .AddMapColumn(p => p.Column2)
    .SetTargetTable("YourModelTable"); // target/destination table

// dapper style use of extension methods on connections
_connection.Upsert(toUpsert, upsertOptions);

Repository Statistics