MuchAdo 1.2.4
dotnet add package MuchAdo --version 1.2.4
NuGet\Install-Package MuchAdo -Version 1.2.4
<PackageReference Include="MuchAdo" Version="1.2.4" />
<PackageVersion Include="MuchAdo" Version="1.2.4" />
<PackageReference Include="MuchAdo" />
paket add MuchAdo --version 1.2.4
#r "nuget: MuchAdo, 1.2.4"
#:package MuchAdo@1.2.4
#addin nuget:?package=MuchAdo&version=1.2.4
#tool nuget:?package=MuchAdo&version=1.2.4
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
Follow the links below for detailed information on MuchAdo features.
- Databases — Work with ADO.NET providers, including provider-specific packages and connector classes for MySQL, PostgreSQL, SQLite, and Microsoft SQL Server.
- Connections — Create and dispose connectors, open and close connections automatically, and configure connector settings.
- Commands — Execute SQL and stored procedures, read records with query and enumeration methods, set command timeouts, cancel commands, and handle execution events.
- Command Batches — Execute multiple SQL statements in one database call, read multiple result sets, and build batches incrementally.
- Transactions — Run manual and automatic transactions, configure transaction settings, roll back uncommitted work, and attach existing transactions.
- Data Mapping — Map data records to strings, value types, enums, blobs, DTOs, tuples, dynamic objects, dictionaries, custom mappers, and mapping delegates.
- Formatted SQL — Build SQL from interpolated fragments and parameter values, including raw SQL, quoted names, concatenation helpers, lists, tuples, clauses, and SQL keyword helpers.
- Parameters — Inject parameters safely, expand collection parameters, use named and unnamed parameter sources, generate DTO-based parameters, create
LIKEparameters, set parameter types, and combine parameter sources. - Resilience — Retry opening connections, running transactions, executing commands or command batches, and wrapping arbitrary idempotent actions.
- Optimizations — Improve performance with prepared commands, cached commands, and connector pooling.
- Analyzers — Add analyzer warnings for potentially incorrect library usage, such as interpolated strings passed to
Command. - Other Libraries — Compare MuchAdo with Dapper across connection handling, query buffering, command batching, transaction tracking, mapping, SQL building, parameters, and optimizations.
For more information, please check out our comprehensive documentation!
| Product | Versions Compatible and additional computed target framework versions. |
|---|---|
| .NET | net5.0 was computed. net5.0-windows was computed. net6.0 was computed. net6.0-android was computed. net6.0-ios was computed. net6.0-maccatalyst was computed. net6.0-macos was computed. net6.0-tvos was computed. net6.0-windows was computed. net7.0 was computed. net7.0-android was computed. net7.0-ios was computed. net7.0-maccatalyst was computed. net7.0-macos was computed. net7.0-tvos was computed. net7.0-windows was computed. net8.0 is compatible. net8.0-android was computed. net8.0-browser was computed. net8.0-ios was computed. net8.0-maccatalyst was computed. net8.0-macos was computed. net8.0-tvos was computed. net8.0-windows was computed. net9.0 is compatible. net9.0-android was computed. net9.0-browser was computed. net9.0-ios was computed. net9.0-maccatalyst was computed. net9.0-macos was computed. net9.0-tvos was computed. net9.0-windows was computed. net10.0 is compatible. net10.0-android was computed. net10.0-browser was computed. net10.0-ios was computed. net10.0-maccatalyst was computed. net10.0-macos was computed. net10.0-tvos was computed. net10.0-windows was computed. |
| .NET Core | netcoreapp2.0 was computed. netcoreapp2.1 was computed. netcoreapp2.2 was computed. netcoreapp3.0 was computed. netcoreapp3.1 was computed. |
| .NET Standard | netstandard2.0 is compatible. netstandard2.1 was computed. |
| .NET Framework | net461 was computed. net462 was computed. net463 was computed. net47 was computed. net471 was computed. net472 was computed. net48 was computed. net481 was computed. |
| MonoAndroid | monoandroid was computed. |
| MonoMac | monomac was computed. |
| MonoTouch | monotouch was computed. |
| Tizen | tizen40 was computed. tizen60 was computed. |
| Xamarin.iOS | xamarinios was computed. |
| Xamarin.Mac | xamarinmac was computed. |
| Xamarin.TVOS | xamarintvos was computed. |
| Xamarin.WatchOS | xamarinwatchos was computed. |
-
.NETStandard 2.0
- Microsoft.Bcl.AsyncInterfaces (>= 10.0.8)
- System.Memory (>= 4.6.3)
- System.Runtime.CompilerServices.Unsafe (>= 6.1.2)
- System.Text.Json (>= 10.0.8)
- System.Threading.Tasks.Extensions (>= 4.6.3)
-
net10.0
- No dependencies.
-
net8.0
- No dependencies.
-
net9.0
- No dependencies.
NuGet packages (5)
Showing the top 5 NuGet packages that depend on MuchAdo:
| Package | Downloads |
|---|---|
|
MuchAdo.MySql
A fluent, powerful, efficient library for querying with MySqlConnector. |
|
|
MuchAdo.Sqlite
A fluent, powerful, efficient library for querying with Microsoft.Data.Sqlite. |
|
|
MuchAdo.Npgsql
A fluent, powerful, efficient library for querying with Npgsql. |
|
|
MuchAdo.SqlServer
A fluent, powerful, efficient library for querying with Microsoft.Data.SqlClient. |
|
|
MuchAdo.Polly
A Polly integration for MuchAdo providing retry policies for database operations. |
GitHub repositories
This package is not used by any popular GitHub repositories.
| Version | Downloads | Last Updated |
|---|---|---|
| 1.2.4 | 249 | 6/1/2026 |
| 1.2.3 | 326 | 5/24/2026 |
| 1.2.2 | 342 | 5/15/2026 |
| 1.2.1 | 450 | 5/4/2026 |
| 1.2.0 | 853 | 4/30/2026 |
| 1.1.0 | 277 | 4/30/2026 |
| 1.0.1 | 272 | 4/29/2026 |
| 1.0.0 | 2,109 | 12/31/2025 |
| 0.0.26 | 2,159 | 8/22/2025 |
| 0.0.25 | 674 | 7/25/2025 |
| 0.0.24 | 601 | 7/1/2025 |
| 0.0.23 | 318 | 6/19/2025 |
| 0.0.22 | 314 | 6/15/2025 |
| 0.0.21 | 857 | 6/12/2025 |
| 0.0.20 | 449 | 6/10/2025 |
| 0.0.19 | 582 | 6/8/2025 |
| 0.0.18 | 295 | 6/7/2025 |
| 0.0.17 | 299 | 6/7/2025 |
| 0.0.16 | 306 | 6/7/2025 |
| 0.0.15 | 298 | 6/4/2025 |