End-User Documentation

Use SqlStatement Attributes for Discovery

Use SqlStatement Attributes for Discovery

Statement attributes let you mark string-based members for discovery when you do not want to store SqlStatement wrappers directly.

Available Attributes

  • SqlQueryAttribute
  • SqlInsertAttribute
  • SqlUpdateAttribute
  • SqlDeleteAttribute
  • SqlMergeAttribute
  • SqlStoredProcAttribute

Supported Member Forms

  • Public static fields
  • Public static properties
  • Public static parameterless methods

Example

public static class OrderQueries
{
    [SqlQuery]
    public static string GetByStatus => "SELECT * FROM dbo.orders WHERE status = @Status";
}

Related