Annotate once. Query forever.

From annotated class to typed queries, through the context.

Follow the steps to get DB wired up. Everything you need is in one package.

1. 01Install the package. The generator, runtime, and migration CLI ship in one reference.
   bash

   ⧉ copy

   dotnet add package Socigy.OpenSource.DB

2. 02Model a table as a partial C# class. Attributes map it to PostgreSQL; the generator writes the rest.
   C#

   ⧉ copy

   using Socigy.OpenSource.DB.Attributes;
   
   [Table("users")]
   public partial class User
   {
       [PrimaryKey, Default(DbDefaults.Guid.Random)]
       public Guid Id { get; set; }
   
       [Unique]
       public required string Username { get; set; }
   
       public string? Email { get; set; }
   
       [Default(DbDefaults.Time.Now)]
       public DateTime CreatedAt { get; set; }
   }

3. 03Name the database in socigy.json. The generator emits a typed context (IAppDb) and its DI wiring.
   JSON

   ⧉ copy

   {
     "database": {
       "platform": "postgresql",
       "databaseName": "AppDb"
     }
   }

4. 04Register the context, then read and write through it. No connection strings in your handlers, no SQL.
   C#

   ⧉ copy

   builder.AddAppDb();                  // connection factory + migrations
   builder.Services.AddAppDbContext();  // ISocigyDatabaseFactory<IAppDb>
   
   var app = builder.Build();
   await app.EnsureLatestAppDbMigration();
   
   app.MapPost("/users", (User user, ISocigyDatabaseFactory<IAppDb> db) =>
       db.ExecuteAsync(d => d.Users.InsertAsync(user)));
   
   app.MapGet("/users/{name}", (string name, ISocigyDatabaseFactory<IAppDb> db) =>
       db.ExecuteAsync(d => d.Users.FirstOrDefaultAsync(u => u.Username == name)));