Introduction

The MuchAdo class library provides an intuitive API for working with relational databases like MySQL, PostgreSQL, SQLite, and Microsoft SQL Server. It is similar to Dapper and other micro ORMs for .NET.

var shortWidgets = await connector
    .CommandFormat(
        $"select id, name from widgets where height <= {maxHeight}")
    .QueryAsync<(long Id, string Name)>(cancellationToken);

To use MuchAdo, add a reference to the NuGet package that corresponds to your database. Strongly consider adding a reference to MuchAdo.Analyzers as well.

Key Features

• open and close database connections automatically
• use a fluent API to execute commands and read data
• read multiple result sets from command batches
• leverage transactions simply and correctly
• map data records into simple types, tuples, and DTOs
• use formatted SQL to build SQL statements
• specify parameters for commands and stored procedures
• support resilience by retrying transient failures
• improve performance by preparing, caching, and pooling
• provide analyzers to help ensure proper use of the library