/DB

Generator diagnostics

Every build-time warning and error the source generator can raise, with its SCGDB id, what triggers it, and how to suppress or escalate it from .editorconfig.

updated 5 Jun 20264 min readv0.3.0View as Markdown

Overview

Beyond emitting code, the source generator inspects your tables and .sql procedure files at build time and reports problems as standard Roslyn diagnostics. Each one has a stable SCGDB### id, shows up in the IDE error list and in dotnet build output, and points at the offending property, attribute, or .sql file.

Because they are ordinary compiler diagnostics, you control their severity from .editorconfig exactly like any analyzer rule — see Configuring severity. All diagnostics share the Socigy.DB category.

Table & column definitions

These fire on the [Table] class or property they describe, so the squiggle lands directly on your C# source.

Id Severity Triggered when
SCGDB001 Error [AutoIncrement] is applied to a property whose type is not short, int, or long.
SCGDB002 Error [Encrypted] is combined with [ValueConvertor], [JsonColumn], or [RawJsonColumn] on the same property. See Encrypted columns.
SCGDB016 Warning A [Table] class declares no [PrimaryKey] column. Generated Update() / Delete() need a primary key to target rows.
SCGDB017 Warning A [Table] class has no mapped columns.
SCGDB018 Error A [Column("")] is given an empty or whitespace name.

SQL procedure files

These fire while processing procedure-mapping .sql files and attach to the .sql file itself.

Id Severity Triggered when
SCGDB003 Warning A .sql file contains no {{Type}} / {{Type.Property}} placeholder. Suppress per-file with -- @ignore warning — see Suppressing the placeholder warning.
SCGDB004 Error A placeholder references a type that does not exist in the compilation.
SCGDB005 Error A {{Type.Property}} placeholder references a property that does not exist on the named type.
SCGDB006 Error A placeholder is malformed; it must be {{TypeName}} (table) or {{TypeName.PropertyName}} (column).
SCGDB007 Error A placeholder references a type that is not a [Table] / [FlagTable].
SCGDB008 Error A placeholder's simple type name is ambiguous; use a fully-qualified name.
SCGDB009 Warning A -- @param is declared but never referenced in the SQL body.
SCGDB010 Warning The SQL body references @name but no matching -- @param declaration exists.
SCGDB011 Warning The -- @returns type cannot be resolved in the compilation.
SCGDB012 Warning A -- @param line is malformed; expected -- @param name: CSharpType.
SCGDB013 Warning A .sql file is registered as <AdditionalFiles> but lives outside Socigy/Procedures/, so it was ignored.
SCGDB014 Warning A .sql file has an empty body after its header and produced no method.
SCGDB015 Error Two procedure files resolve to the same method name in the same namespace group. Only the first is emitted.
NOTE
SCGDB009 and SCGDB010 analyse raw SQL text, so unusual constructs (PostgreSQL @@ operators, casts inside string literals) can occasionally produce a false positive. They are warnings by design — silence an individual rule with .editorconfig if it does not fit your SQL style.

Suppressing diagnostics

Per-file: `-- @ignore warning`

The missing-placeholder warning (SCGDB003) is silenced for a single .sql file by adding the directive to its header:

-- @ignore warning: optional free-form reason

See Procedure mapping → Suppressing the placeholder warning.

Inline: `#pragma` and `[SuppressMessage]`

Diagnostics reported on a .cs location (the table and column rules) can be suppressed inline like any analyzer warning:

#pragma warning disable SCGDB016
[Table("audit_log")] // intentionally key-less, append-only table
public partial class AuditLog { /* ... */ }
#pragma warning restore SCGDB016

Configuring severity

Set any diagnostic's severity from .editorconfig. The section glob must match the file the diagnostic points at — .cs for table/column rules, .sql for procedure rules — or use a global section:

# Promote the missing-primary-key warning to an error
[*.cs]
dotnet_diagnostic.SCGDB016.severity = error

# Make a missing schema placeholder a hard build error
[*.sql]
dotnet_diagnostic.SCGDB003.severity = error

# Silence "declared but unused parameter" everywhere
[*.sql]
dotnet_diagnostic.SCGDB009.severity = none

Valid severities are error, warning, suggestion, silent, none, and default.

NOTE
.editorconfig severity and the -- @ignore warning directive are independent and complementary. Use the directive to silence one file; use .editorconfig to change a rule across the whole project.