# Socigy Documentation

> Documentation for the Socigy.OpenSource suite of backend SDKs for .NET. Each section below links to the raw markdown of a documentation page so it can be read directly. The complete documentation is also available as a single file at https://docs.socigy.com/llms-full.txt.

## DB 0.3.2

A Roslyn source generator that turns annotated C# classes into a typed PostgreSQL data layer with no boilerplate and no runtime reflection.
_Annotate once. Query forever._

- [Getting started / Installation](https://docs.socigy.com/llms/database/0.3.2/getting-started/installation.md)
- [Getting started / Quickstart](https://docs.socigy.com/llms/database/0.3.2/getting-started/quickstart.md)
- [Getting started / Project structure](https://docs.socigy.com/llms/database/0.3.2/getting-started/project-structure.md)
- [Getting started / Configuration](https://docs.socigy.com/llms/database/0.3.2/getting-started/configuration.md)
- [Tutorial / What you'll build](https://docs.socigy.com/llms/database/0.3.2/tutorial/overview.md)
- [Tutorial / Model the schema](https://docs.socigy.com/llms/database/0.3.2/tutorial/schema.md)
- [Tutorial / Generate and apply migrations](https://docs.socigy.com/llms/database/0.3.2/tutorial/migrations.md)
- [Tutorial / Wire up the context](https://docs.socigy.com/llms/database/0.3.2/tutorial/context.md)
- [Tutorial / Read and write data](https://docs.socigy.com/llms/database/0.3.2/tutorial/data-access.md)
- [Tutorial / Transactions and tests](https://docs.socigy.com/llms/database/0.3.2/tutorial/transactions-and-tests.md)
- [Core concepts / How it works](https://docs.socigy.com/llms/database/0.3.2/core-concepts/how-it-works.md)
- [Core concepts / Connections & DI](https://docs.socigy.com/llms/database/0.3.2/core-concepts/connections-and-di.md)
- [Core concepts / The database context](https://docs.socigy.com/llms/database/0.3.2/core-concepts/database-context.md)
- [Core concepts / Transactions](https://docs.socigy.com/llms/database/0.3.2/core-concepts/transactions.md)
- [Defining models / Tables & classes](https://docs.socigy.com/llms/database/0.3.2/defining-models/tables.md)
- [Defining models / Columns & types](https://docs.socigy.com/llms/database/0.3.2/defining-models/columns.md)
- [Defining models / Default values](https://docs.socigy.com/llms/database/0.3.2/defining-models/defaults.md)
- [Defining models / Constraints](https://docs.socigy.com/llms/database/0.3.2/defining-models/constraints.md)
- [Defining models / JSON columns](https://docs.socigy.com/llms/database/0.3.2/defining-models/json-columns.md)
- [Defining models / Encrypted columns](https://docs.socigy.com/llms/database/0.3.2/defining-models/encrypted-columns.md)
- [Defining models / Flagged enums](https://docs.socigy.com/llms/database/0.3.2/defining-models/flagged-enums.md)
- [Defining models / Sequences](https://docs.socigy.com/llms/database/0.3.2/defining-models/sequences.md)
- [Querying / SELECT](https://docs.socigy.com/llms/database/0.3.2/querying/reading/select.md)
- [Querying / WHERE expressions](https://docs.socigy.com/llms/database/0.3.2/querying/reading/where.md)
- [Querying / Aggregates & scalars](https://docs.socigy.com/llms/database/0.3.2/querying/reading/aggregates.md)
- [Querying / Sorting & pagination](https://docs.socigy.com/llms/database/0.3.2/querying/reading/sorting-pagination.md)
- [Querying / Joins](https://docs.socigy.com/llms/database/0.3.2/querying/reading/joins.md)
- [Querying / Set operations](https://docs.socigy.com/llms/database/0.3.2/querying/reading/set-operations.md)
- [Querying / INSERT](https://docs.socigy.com/llms/database/0.3.2/querying/writing/insert.md)
- [Querying / UPDATE](https://docs.socigy.com/llms/database/0.3.2/querying/writing/update.md)
- [Querying / DELETE](https://docs.socigy.com/llms/database/0.3.2/querying/writing/delete.md)
- [Dynamic tables / Declaring table types](https://docs.socigy.com/llms/database/0.3.2/dynamic-tables/declaring.md)
- [Dynamic tables / Runtime operations](https://docs.socigy.com/llms/database/0.3.2/dynamic-tables/runtime-operations.md)
- [Recipes / Keyset pagination](https://docs.socigy.com/llms/database/0.3.2/recipes/keyset-pagination.md)
- [Recipes / Soft deletes](https://docs.socigy.com/llms/database/0.3.2/recipes/soft-deletes.md)
- [Recipes / Audit columns](https://docs.socigy.com/llms/database/0.3.2/recipes/audit-columns.md)
- [Recipes / Multi-tenant tables](https://docs.socigy.com/llms/database/0.3.2/recipes/multi-tenant.md)
- [Advanced / Value convertors](https://docs.socigy.com/llms/database/0.3.2/advanced/value-convertors.md)
- [Advanced / Procedure mapping](https://docs.socigy.com/llms/database/0.3.2/advanced/procedure-mapping.md)
- [Advanced / DB constants](https://docs.socigy.com/llms/database/0.3.2/advanced/db-constants.md)
- [Advanced / Check constraint DSL](https://docs.socigy.com/llms/database/0.3.2/advanced/check-dsl.md)
- [Advanced / Generator diagnostics](https://docs.socigy.com/llms/database/0.3.2/advanced/generator-diagnostics.md)
- [Observability / Diagnostics & OpenTelemetry](https://docs.socigy.com/llms/database/0.3.2/observability/diagnostics.md)
- [Observability / Logging](https://docs.socigy.com/llms/database/0.3.2/observability/logging.md)
- [Performance / Benchmarks](https://docs.socigy.com/llms/database/0.3.2/performance/benchmarks.md)
- [Migration / Configuration](https://docs.socigy.com/llms/database/0.3.2/migration/configuration.md)
- [Migration / CLI tool](https://docs.socigy.com/llms/database/0.3.2/migration/cli-tool.md)
- [Migration / Schema generation](https://docs.socigy.com/llms/database/0.3.2/migration/schema-generation.md)
- [Migration / Applying migrations](https://docs.socigy.com/llms/database/0.3.2/migration/applying.md)
- [Migration / Custom migrations](https://docs.socigy.com/llms/database/0.3.2/migration/custom-migrations.md)
- [Integrations / ASP.NET Core](https://docs.socigy.com/llms/database/0.3.2/integrations/aspnet-core.md)
- [Integrations / Manual connections](https://docs.socigy.com/llms/database/0.3.2/integrations/manual-connections.md)
- [Integrations / HashiCorp Vault](https://docs.socigy.com/llms/database/0.3.2/integrations/hashicorp-vault.md)
- [Testing / Unit testing](https://docs.socigy.com/llms/database/0.3.2/testing/unit-testing.md)
- [Changelog / Changelog](https://docs.socigy.com/llms/database/0.3.2/changelog.md)

## Full text

- [All documentation in one file](https://docs.socigy.com/llms-full.txt)