MuchAdo.MySql

MuchAdo

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
• track the current transaction for correct command execution
• map data records into simple types, tuples, and DTOs
• use formatted SQL to build SQL statements
• use parameters with commands and stored procedures
• improve performance by preparing, caching, and pooling
• provide analyzers to help ensure proper use of the library

For more information, please check out our comprehensive documentation!