MoCrud.Dapper 1.1.66

Dapper.MoCrud

A simple CRUD helper extension built on top of Dapper.
Auto-generates Get, GetList, Insert, Update, Delete queries from POCO classes and attributes, minimizing repetitive SQL.

Features

• Auto SQL generation ? Select / Insert / Update / Delete from POCO classes
• Sync & Async ? Every CRUD method has an Async counterpart
• Multi-DB support ? SQL Server, SQL Server 2012+, PostgreSQL, SQLite, MySQL, Oracle, DB2
• Paging ? Server-side paging via GetListPaged
• Partial update ? Update only specific properties
• Composite keys ? Composite Primary Key support
• Custom Resolver ? Swap table/column name strategies with ITableNameResolver, IColumnNameResolver
• ILogger integration ? Query tracing via Microsoft.Extensions.Logging
• net8.0 / netstandard2.0 multi-target

Install

dotnet add package MoCrud.Dapper

Quick Start

1. Define Entity

using Dapper.MoCrud.Attributes;

[Table("Users")]
public class User
{
    [Key]
    public int Id { get; set; }
    public string Name { get; set; }
    public int Age { get; set; }

    [IgnoreInsert]
    [ReadOnly(true)]
    public DateTime CreatedDate { get; set; }
}

2. Set Dialect (default: SQL Server)

CrudHelper.SetDialect(CrudHelper.Dialect.SQLite);

3. CRUD Usage

using Dapper.MoCrud;

// Get by Id
var user = connection.Get<User>(1);

// Get by conditions
var user = connection.Get<User>("where Name = @Name", new { Name = "Alice" });

// GetList ? anonymous object conditions
var users = connection.GetList<User>(new { Age = 30 });

// GetList ? SQL where clause
var users = connection.GetList<User>("where Age > @Age", new { Age = 20 });

// GetAll
var allUsers = connection.GetAll<User>();

// GetListPaged (pageNumber, rowsPerPage, conditions, orderBy)
var paged = connection.GetListPaged<User>(1, 10, "where Age > 20", "Name");

// Insert ? returns new Id
int? newId = connection.Insert(new User { Name = "Bob", Age = 25 });

// Insert ? specify return type
long newId = connection.Insert<long, User>(new User { Name = "Bob", Age = 25 });

// Update ? all properties
connection.Update(user);

// Update ? specific properties only
connection.Update(user, new[] { "Name", "Age" });

// Delete ? by entity
connection.Delete(user);

// Delete ? by Id
connection.Delete<User>(1);

// DeleteList ? anonymous object conditions
connection.DeleteList<User>(new { Age = 30 });

// DeleteList ? SQL where clause
connection.DeleteList<User>("where Age < @Age", new { Age = 18 });

// RecordCount
int count = connection.RecordCount<User>("where Age > @Age", new { Age = 20 });

4. Async Support

Every method has an Async version.

var user  = await connection.GetAsync<User>(1);
var users = await connection.GetListAsync<User>(new { Age = 30 });
int? id   = await connection.InsertAsync(new User { Name = "Eve", Age = 28 });
await connection.UpdateAsync(user);
await connection.DeleteAsync(user);
int count = await connection.RecordCountAsync<User>();

Attributes

Supported Dialects

CrudHelper.SetDialect(CrudHelper.Dialect.SQLServer);      // default
CrudHelper.SetDialect(CrudHelper.Dialect.SQLServer2012);   // OFFSET-FETCH paging
CrudHelper.SetDialect(CrudHelper.Dialect.PostgreSQL);
CrudHelper.SetDialect(CrudHelper.Dialect.SQLite);
CrudHelper.SetDialect(CrudHelper.Dialect.MySQL);
CrudHelper.SetDialect(CrudHelper.Dialect.Oracle);
CrudHelper.SetDialect(CrudHelper.Dialect.DB2);

Custom Resolver

public class SnakeCaseTableNameResolver : CrudHelper.ITableNameResolver
{
    public string ResolveTableName(Type type)
    {
        return CrudHelper.Encapsulate(ToSnakeCase(type.Name));
    }
}

CrudHelper.SetTableNameResolver(new SnakeCaseTableNameResolver());
CrudHelper.SetColumnNameResolver(new MyColumnNameResolver());

Logging

CrudHelper.SetLogger(loggerFactory.CreateLogger("Dapper.MoCrud"));

Generated SQL is traced at LogTrace level.

License

Apache-2.0 ? See LICENSE