MooDb 0.9.2

MooDb™

MooDb is a small, explicit micro ORM for SQL Server.

It is designed for developers who want a clean API over ADO.NET without taking on the weight of a large ORM. MooDb is stored procedure first, supports raw SQL when needed, and keeps common database work predictable.

MooDb is released under the MIT License and is free to use in both personal and commercial projects.

Why MooDb

MooDb is built around a few simple ideas:

• Stored procedure first by default
• Raw SQL is available through an explicit Sql surface
• Small public API that is easy to learn and hard to misuse
• Predictable mapping for classes, constructor-based models, and simple types
• Strict auto-mapping when you want result shapes checked more closely
• Custom mapping when you want full control
• Multiple results without making the caller manage live readers
• Transactions with the same general shape as the main entry point
• Bulk loading for fast back-office and batch data movement
• No forced abstraction layer for ordinary usage

MooDb stays close to ADO.NET while removing repetitive plumbing.

Installation

<PackageReference Include="MooDb" Version="x.y.z" />

MooDb targets SQL Server and is built on Microsoft.Data.SqlClient.

Quick start

using MooDb;

var db = new MooDbContext(connectionString);

var user = await db.SingleAsync<User>(
    "dbo.usp_User_GetById",
    new MooParams()
        .AddInt("@UserId", 42));

MooDb is designed to keep database access explicit and predictable.

For raw SQL, use the explicit Sql surface:

var user = await db.Sql.SingleAsync<User>(
    "select UserId, DisplayName from dbo.tbl_User where UserId = @UserId",
    new MooParams()
        .AddInt("@UserId", 42));

Main concepts

• MooDbContext is the main entry point
• MooDbContext.Sql is the raw SQL escape hatch
• MooTransaction is the transactional entry point
• MooParams builds SQL Server parameters fluently
• IMooMultiReader handles multiple results from one execution
• MooBulk handles SQL Server bulk loading
• MooDbContextOptions controls timeout and strict auto-mapping
• AddMooDbContextFactory() registers factory support for dependency injection

Documentation

Full documentation is available at:

https://moodb.net

Recommended starting points:

• Start Here
• Philosophy
• Creating a MooDb Instance
• Your First Stored Procedure Call