Table of Contents

Aurelius.Sql.BaseTypes Namespace

Classes

Name Description
TSQLField Represents a column reference in a SQL statement, combining the owning table descriptor with the column name.
TSQLInsertField Extends TSQLField with a parameter placeholder name, representing a column value in an INSERT statement.
TSQLJoin Represents a SQL JOIN between two relations, carrying the join type, key-pair conditions, and any custom SQL conditions.
TSQLJoinCustom​Segment Holds a raw SQL condition string that is injected verbatim into a JOIN's ON clause, used when a join condition cannot be expressed as a simple key-pair.
TSQLJoinSegment Describes a single key-pair condition within a SQL JOIN clause, pairing a primary-key field with the corresponding foreign-key field.
TSQLOrderField Extends TSQLField for use in ORDER BY clauses, pairing a column reference with a sort direction.
TSQLRelation Abstract base class for SQL relational constructs such as tables and joins.
TSQLSelectField Extends TSQLField for use in SELECT clauses, optionally applying an aggregate function to the column.
TSQLTable Describes a database table (or view) referenced in a SQL command, carrying the table name, optional schema, and the alias used in the generated SQL.
TSQLUpdateField Extends TSQLField with a parameter placeholder name, representing a column assignment in an UPDATE statement.
TSQLWhereField Extends TSQLField for use in WHERE clauses, pairing a column reference with a comparison operator and a parameter placeholder name.

Enumerations

Name Description
TAggregateFunction Identifies the aggregate SQL function to apply to a select field.
TJoinType Specifies the type of SQL JOIN to generate between two relations.
TOrderDirection Specifies the sort direction for a column in an ORDER BY clause.
TWhereOperator Specifies the comparison operator used in a SQL WHERE predicate.