Annotate once. Query forever.

From zero to a typed query in minutes.

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

1. 01Add the NuGet package.
   bash

   ⧉ copy

   dotnet add package Socigy.OpenSource.DB

2. 02Annotate a C# class as a table. Make it partial so the generator can augment it.
   C#

   ⧉ copy

   [Table("users")]
   public partial class User
   {
       [PrimaryKey, Default(DbDefaults.Guid.Random)]
       public Guid Id { get; set; }
   
       // C# initializer → DEFAULT 'anonymous' in DDL
       public string Username { get; set; } = "anonymous";
   
       [Default(DbDefaults.Time.Now)]
       public DateTime CreatedAt { get; set; }
   }

3. 03Build once — the generator emits Insert(), Query(), Update(), and Delete() methods. Then use them.
   C#

   ⧉ copy

   // INSERT — skip [Default] columns so the database generates them
   var user = new User { Username = "alice" };
   await user.Insert()
       .WithConnection(conn)
       .ExcludeAutoFields()
       .ExecuteAsync();
   
   // SELECT with a typed WHERE predicate
   await foreach (var u in User.Query(x => x.Username == "alice")
       .WithConnection(conn).ExecuteAsync())
   {
       Console.WriteLine($"{u.Id}: {u.Username}");
   }