Socigy.OpenSource.DB 0.1.77

Socigy.OpenSource.DB

A Roslyn source-generator–powered ORM for PostgreSQL. Define your tables with C# attributes, let the generator produce strongly-typed insert/update/delete/query builders, and use the CLI tool to generate and apply migrations — all without writing a line of SQL by hand.

Features

• Attribute-driven schema — map classes to tables with [Table], [Column], [PrimaryKey], [Default], and more
• Fluent CRUD builders — insert, update, delete, and query via generated builder methods
• Lambda WHERE clauses — Query(x => x.Priority > 5 && x.Name != null) translates to SQL
• Flagged enums — N:M junction tables auto-generated from [FlaggedEnum] / [FlaggedEnumTable] + [FlagTable]
• Auto-increment sequences — [AutoIncrement] exposes typed sequence helpers
• CHECK constraints — simple [Check("sql")] or type-safe [Check(typeof(T))] with the DbCheck DSL
• Validation attributes — [Min], [Max], [Bigger], [Lower], [StringLength], [Unique], and more
• Cross-platform constants — DbDefaults and DbValues sentinel constants translate to correct SQL per engine
• Migration tool — CLI that diffs your schema and generates versioned migration files

Installation

Install via NuGet:

dotnet add package Socigy.OpenSource.DB

Or in your .csproj:

<PackageReference Include="Socigy.OpenSource.DB" Version="*" />

The package includes both the runtime Core library and the Roslyn source generator. No manual project-reference wiring is needed.

Documentation

Quick Example

// 1. Define your model
[Table("users")]
public partial class User
{
    [PrimaryKey, Default(DbDefaults.Guid.Random)]
    public Guid Id { get; set; }

    [StringLength(50, MinLength = 3)]
    public string Username { get; set; } = "";

    [Default(DbDefaults.Time.Now)]
    public DateTime CreatedAt { get; set; }
}

// 2. Insert
var user = new User { Username = "alice" };
await user.Insert()
    .WithConnection(conn)
    .ExcludeAutoFields()
    .WithValuePropagation()   // writes DB-generated Id/CreatedAt back to instance
    .ExecuteAsync();

// 3. Query
var users = await User.Query(x => x.Username != null)
    .WithConnection(conn)
    .OrderBy(x => new object[] { x.CreatedAt })
    .Limit(10)
    .ExecuteAsync()
    .ToListAsync();

// 4. Update (selected fields only)
user.Username = "alice2";
await user.Update()
    .WithConnection(conn)
    .WithFields(x => new object[] { x.Username })
    .ExecuteAsync();

// 5. Delete
await user.Delete().WithConnection(conn).ExecuteAsync();